Friday, 19 April 2013

PO 11i AND R12 TABLES

Oracle Apps :      Purchasing (PO)
SR.#R11R12
Table NameTable Name
1CHV_AUTHORIZATIONSCHV_AUTHORIZATIONSSAME
2CHV_BUCKET_PATTERNSCHV_BUCKET_PATTERNSSAME
3CHV_CUM_ADJUSTMENTSCHV_CUM_ADJUSTMENTSSAME
4CHV_CUM_PERIOD_ITEMSCHV_CUM_PERIOD_ITEMSSAME
5CHV_CUM_PERIODSCHV_CUM_PERIODSSAME
6CHV_HISTORY_CUM_PERIODSCHV_HISTORY_CUM_PERIODSSAME
7CHV_HISTORY_SCHEDULESCHV_HISTORY_SCHEDULESSAME
8CHV_HORIZONTAL_SCHEDULESCHV_HORIZONTAL_SCHEDULESSAME
9CHV_ITEM_ORDERSCHV_ITEM_ORDERSSAME
10CHV_ORG_OPTIONSCHV_ORG_OPTIONSSAME
11CHV_PURGE_CUM_LISTCHV_PURGE_CUM_LISTSAME
12CHV_PURGE_SCHEDULE_LISTCHV_PURGE_SCHEDULE_LISTSAME
13CHV_SCHEDULE_HEADERSCHV_SCHEDULE_HEADERSSAME
14CHV_SCHEDULE_ITEMSCHV_SCHEDULE_ITEMSSAME
15CHV_SCHEDULE_ORGANIZATIONSCHV_SCHEDULE_ORGANIZATIONSSAME
16EDW_PO_VENDOR_HIERARCHIESEDW_PO_VENDOR_HIERARCHIESSAME
17FND_FUNCTION_PARAMETER_MAPFND_FUNCTION_PARAMETER_MAPSAME
18FND_NOTIFICATIONSFND_NOTIFICATIONSSAME
19MLOG$_PO_COMMODITY_CATEGORMLOG$_PO_COMMODITY_CATEGORSAME
20MLOG$_PO_VENDOR_SITES_ALLDELETED
21MLOG$_PO_VENDORSDELETED
22PO_ACCEPTANCESPO_ACCEPTANCESSAME
23PO_ACCRUAL_ACCOUNTS_TEMP_ALLPO_ACCRUAL_ACCOUNTS_TEMP_ALLSAME
24PO_ACCRUAL_RECONCILE_TEMP_ALLDELETED
25PO_ACCRUAL_WRITE_OFFS_ALLPO_ACCRUAL_WRITE_OFFS_ALLSAME
26PO_ACCRUAL_WRITE_OFFS_ALL_EFCPO_ACCRUAL_WRITE_OFFS_ALL_EFCSAME
27PO_ACTION_HISTORYPO_ACTION_HISTORYSAME
28PO_ADDRESS_DETAILS_GTPO_ADDRESS_DETAILS_GTSAME
29PO_AGENTSPO_AGENTSSAME
30PO_APPROVAL_LIST_HEADERSPO_APPROVAL_LIST_HEADERSSAME
31PO_APPROVAL_LIST_LINESPO_APPROVAL_LIST_LINESSAME
32PO_APPROVED_SUPPLIER_LISTPO_APPROVED_SUPPLIER_LISTSAME
33PO_ASL_ATTRIBUTESPO_ASL_ATTRIBUTESSAME
34PO_ASL_DOCUMENTSPO_ASL_DOCUMENTSSAME
35PO_ASL_STATUS_RULESPO_ASL_STATUS_RULESSAME
36PO_ASL_STATUSESPO_ASL_STATUSESSAME
37PO_ATT_TMP_RECORDSPO_ATT_TMP_RECORDSSAME
38PO_AUTOSOURCE_DOCUMENTS_ALLPO_AUTOSOURCE_DOCUMENTS_ALLSAME
39PO_AUTOSOURCE_RULESPO_AUTOSOURCE_RULESSAME
40PO_AUTOSOURCE_VENDORSPO_AUTOSOURCE_VENDORSSAME
41PO_CHANGE_REQUESTSPO_CHANGE_REQUESTSSAME
42PO_COMMODITIES_BPO_COMMODITIES_BSAME
43PO_COMMODITIES_TLPO_COMMODITIES_TLSAME
44PO_COMMODITY_CATEGORIESPO_COMMODITY_CATEGORIESSAME
45PO_COMMODITY_GRANTSPO_COMMODITY_GRANTSSAME
46PO_COMMUNICATION_GTPO_COMMUNICATION_GTSAME
47PO_CONTROL_FUNCTIONSPO_CONTROL_FUNCTIONSSAME
48PO_CONTROL_GROUPS_ALLPO_CONTROL_GROUPS_ALLSAME
49PO_CONTROL_RULESPO_CONTROL_RULESSAME
50PO_CONTROL_RULES_EFCPO_CONTROL_RULES_EFCSAME
51PO_DISTRIBUTIONS_ALLPO_DISTRIBUTIONS_ALLSAME
52PO_DISTRIBUTIONS_ALL_EBSPO_DISTRIBUTIONS_ALL_EBSSAME
53PO_DISTRIBUTIONS_ARCHIVE_ALLPO_DISTRIBUTIONS_ARCHIVE_ALLSAME
54PO_DISTRIBUTIONS_GTPO_DISTRIBUTIONS_GTSAME
55PO_DISTRIBUTIONS_INTERFACEPO_DISTRIBUTIONS_INTERFACESAME
56PO_DOCUMENT_TYPES_ALL_BPO_DOCUMENT_TYPES_ALL_BSAME
57PO_DOCUMENT_TYPES_ALL_TLPO_DOCUMENT_TYPES_ALL_TLSAME
58PO_EMPLOYEE_HIERARCHIES_ALLPO_EMPLOYEE_HIERARCHIES_ALLSAME
59PO_ENCUMBRANCE_GTPO_ENCUMBRANCE_GTSAME
60PO_GA_ORG_ASSIGNMENTSPO_GA_ORG_ASSIGNMENTSSAME
61PO_GA_ORG_ASSIGNMENTS_ARCHIVEPO_GA_ORG_ASSIGNMENTS_ARCHIVESAME
62PO_HAZARD_CLASSES_BPO_HAZARD_CLASSES_BSAME
63PO_HAZARD_CLASSES_TLPO_HAZARD_CLASSES_TLSAME
64PO_HEADERS_ALLPO_HEADERS_ALLSAME
65PO_HEADERS_ALL_EBSPO_HEADERS_ALL_EBSSAME
66PO_HEADERS_ARCHIVE_ALLPO_HEADERS_ARCHIVE_ALLSAME
67PO_HEADERS_GTPO_HEADERS_GTSAME
68PO_HEADERS_INTERFACEPO_HEADERS_INTERFACESAME
69PO_HISTORY_POS_ALLPO_HISTORY_POS_ALLSAME
70PO_HISTORY_RECEIPTSPO_HISTORY_RECEIPTSSAME
71PO_HISTORY_REQUISITIONS_ALLPO_HISTORY_REQUISITIONS_ALLSAME
72PO_HISTORY_VENDORSPO_HISTORY_VENDORSSAME
73PO_INTERFACE_ERRORSPO_INTERFACE_ERRORSSAME
74PO_JOB_ASSOCIATIONS_BPO_JOB_ASSOCIATIONS_BSAME
75PO_JOB_ASSOCIATIONS_TLPO_JOB_ASSOCIATIONS_TLSAME
76PO_LINE_LOCATIONS_ALLPO_LINE_LOCATIONS_ALLSAME
77PO_LINE_LOCATIONS_ALL_EBSPO_LINE_LOCATIONS_ALL_EBSSAME
78PO_LINE_LOCATIONS_ARCHIVE_ALLPO_LINE_LOCATIONS_ARCHIVE_ALLSAME
79PO_LINE_LOCATIONS_GTPO_LINE_LOCATIONS_GTSAME
80PO_LINE_TYPES_BPO_LINE_TYPES_BSAME
81PO_LINE_TYPES_TLPO_LINE_TYPES_TLSAME
82PO_LINES_ALLPO_LINES_ALLSAME
83PO_LINES_ALL_EBSPO_LINES_ALL_EBSSAME
84PO_LINES_ARCHIVE_ALLPO_LINES_ARCHIVE_ALLSAME
85PO_LINES_GTPO_LINES_GTSAME
86PO_LINES_INTERFACEPO_LINES_INTERFACESAME
87PO_LOCATION_ASSOCIATIONS_ALLPO_LOCATION_ASSOCIATIONS_ALLSAME
88PO_MASSCANCEL_INCLUDES_ALLPO_MASSCANCEL_INCLUDES_ALLSAME
89PO_MASSCANCEL_INTERIMPO_MASSCANCEL_INTERIMSAME
90PO_MC_DISTRIBUTIONSPO_MC_DISTRIBUTIONSSAME
91PO_MC_HEADERSPO_MC_HEADERSSAME
92PO_NOTE_ATTRIBUTESPO_NOTE_ATTRIBUTESSAME
93PO_NOTE_REFERENCESPO_NOTE_REFERENCESSAME
94PO_NOTESPO_NOTESSAME
95PO_NOTIFICATION_CONTROLSPO_NOTIFICATION_CONTROLSSAME
96PO_NOTIFICATIONS_ALLPO_NOTIFICATIONS_ALLSAME
97PO_ONLINE_REPORT_TEXTPO_ONLINE_REPORT_TEXTSAME
98PO_ONLINE_REPORT_TEXT_GTPO_ONLINE_REPORT_TEXT_GTSAME
99PO_POSITION_CONTROLS_ALLPO_POSITION_CONTROLS_ALLSAME
100PO_PRICE_DIFF_INTERFACEPO_PRICE_DIFF_INTERFACESAME
101PO_PRICE_DIFFERENTIALSPO_PRICE_DIFFERENTIALSSAME
102PO_PRICE_DIFFERENTIALS_ARCHIVEPO_PRICE_DIFFERENTIALS_ARCHIVESAME
103PO_PURGE_PO_LISTPO_PURGE_PO_LISTSAME
104PO_PURGE_REQ_LISTPO_PURGE_REQ_LISTSAME
105PO_PURGE_VENDOR_LISTPO_PURGE_VENDOR_LISTSAME
106PO_QUALITY_CODESPO_QUALITY_CODESSAME
107PO_QUOTATION_APPROVALS_ALLPO_QUOTATION_APPROVALS_ALLSAME
108PO_RELATED_TEMPLATESPO_RELATED_TEMPLATESSAME
109PO_RELEASES_ALLPO_RELEASES_ALLSAME
110PO_RELEASES_ALL_EBSPO_RELEASES_ALL_EBSSAME
111PO_RELEASES_ARCHIVE_ALLPO_RELEASES_ARCHIVE_ALLSAME
112PO_RELEASES_GTPO_RELEASES_GTSAME
113PO_REQ_DIST_INTERFACE_ALLPO_REQ_DIST_INTERFACE_ALLSAME
114PO_REQ_DISTRIBUTIONS_ALLPO_REQ_DISTRIBUTIONS_ALLSAME
115PO_REQ_DISTRIBUTIONS_ALL_EFCPO_REQ_DISTRIBUTIONS_ALL_EFCSAME
116PO_REQ_DISTRIBUTIONS_GTPO_REQ_DISTRIBUTIONS_GTSAME
117PO_REQ_HEADERS_GTPO_REQ_HEADERS_GTSAME
118PO_REQ_LINES_GTPO_REQ_LINES_GTSAME
119PO_REQ_SPLIT_LINES_GTPO_REQ_SPLIT_LINES_GTSAME
120PO_REQEXPRESS_HEADERS_ALLPO_REQEXPRESS_HEADERS_ALLSAME
121PO_REQEXPRESS_LINES_ALLPO_REQEXPRESS_LINES_ALLSAME
122PO_REQUISITION_HEADERS_ALLPO_REQUISITION_HEADERS_ALLSAME
123PO_REQUISITION_LINES_ALLPO_REQUISITION_LINES_ALLSAME
124PO_REQUISITION_LINES_ALL_EFCPO_REQUISITION_LINES_ALL_EFCSAME
125PO_REQUISITION_SUPPLIERSPO_REQUISITION_SUPPLIERSSAME
126PO_REQUISITIONS_INT_ALL_EFCPO_REQUISITIONS_INT_ALL_EFCSAME
127PO_REQUISITIONS_INTERFACE_ALLPO_REQUISITIONS_INTERFACE_ALLSAME
128PO_RESCHEDULE_INTERFACEPO_RESCHEDULE_INTERFACESAME
129PO_RETRIEVED_TIMECARDSPO_RETRIEVED_TIMECARDSSAME
130PO_RETROPRICE_GTPO_RETROPRICE_GTSAME
131PO_RFQ_VENDORSPO_RFQ_VENDORSSAME
132PO_RULE_EXPENSE_ACCOUNTSPO_RULE_EXPENSE_ACCOUNTSSAME
133PO_SESSION_GTPO_SESSION_GTSAME
134PO_SUPPLIER_ITEM_CAPACITYPO_SUPPLIER_ITEM_CAPACITYSAME
135PO_SUPPLIER_ITEM_TOLERANCEPO_SUPPLIER_ITEM_TOLERANCESAME
136PO_SYSTEM_PARAMETERS_ALLPO_SYSTEM_PARAMETERS_ALLSAME
137PO_UN_NUMBERS_BPO_UN_NUMBERS_BSAME
138PO_UN_NUMBERS_TLPO_UN_NUMBERS_TLSAME
139PO_UNIQUE_IDENTIFIER_CONT_ALLPO_UNIQUE_IDENTIFIER_CONT_ALLSAME
140PO_USAGE_ATTRIBUTESPO_USAGE_ATTRIBUTESSAME
141PO_USAGESPO_USAGESSAME
142PO_VENDOR_CONTACTSDELETED
143PO_VENDOR_LIST_ENTRIESPO_VENDOR_LIST_ENTRIESSAME
144PO_VENDOR_LIST_HEADERSPO_VENDOR_LIST_HEADERSSAME
145PO_VENDOR_SITES_ALLDELETED
146PO_VENDOR_SITES_ALL_EBSPO_VENDOR_SITES_ALL_EBSSAME
147PO_VENDORSDELETED
148PO_VENDORS_EBSPO_VENDORS_EBSSAME
149PO_WF_CANDIDATE_REQ_LINES_TEMPPO_WF_CANDIDATE_REQ_LINES_TEMPSAME
150PO_WF_DEBUGPO_WF_DEBUGSAME
151POA_BIS_SAVINGSPOA_BIS_SAVINGSSAME
152POA_BIS_SAVINGS_EFCPOA_BIS_SAVINGS_EFCSAME
153POA_BIS_SAVINGS_RPTPOA_BIS_SAVINGS_RPTSAME
154POA_BIS_SAVINGS_RPT_EFCPOA_BIS_SAVINGS_RPT_EFCSAME
155POA_BIS_SUPPLIER_PERFORMAN_EFCPOA_BIS_SUPPLIER_PERFORMAN_EFCSAME
156POA_BIS_SUPPLIER_PERFORMANCEPOA_BIS_SUPPLIER_PERFORMANCESAME
157POA_CM_DISTRIBUTIONSPOA_CM_DISTRIBUTIONSSAME
158POA_CM_EVAL_SCORESPOA_CM_EVAL_SCORESSAME
159POA_CM_EVALUATIONPOA_CM_EVALUATIONSAME
160RCV_ACCOUNTING_EVENT_TYPESRCV_ACCOUNTING_EVENT_TYPESSAME
161RCV_ACCOUNTING_EVENTSRCV_ACCOUNTING_EVENTSSAME
162RCV_FTE_TRANSACTION_LINESRCV_FTE_TRANSACTION_LINESSAME
163RCV_GAPLESS_INVOICE_NUMBERSRCV_GAPLESS_INVOICE_NUMBERSSAME
164RCV_HEADERS_INTERFACERCV_HEADERS_INTERFACESAME
165RCV_LOT_TRANSACTIONSRCV_LOT_TRANSACTIONSSAME
166RCV_LOTS_INTERFACERCV_LOTS_INTERFACESAME
167RCV_LOTS_SUPPLYRCV_LOTS_SUPPLYSAME
168RCV_MC_REC_SUB_LEDGERRCV_MC_REC_SUB_LEDGERSAME
169RCV_MC_SHIPMENT_HEADERSRCV_MC_SHIPMENT_HEADERSSAME
170RCV_MC_SUB_LEDGER_DETAILSRCV_MC_SUB_LEDGER_DETAILSSAME
171RCV_MC_TRANSACTIONSRCV_MC_TRANSACTIONSSAME
172RCV_PARAMETERSRCV_PARAMETERSSAME
173RCV_RECEIVING_SUB_LEDGERRCV_RECEIVING_SUB_LEDGERSAME
174RCV_ROUTING_HEADERS_OLDRCV_ROUTING_HEADERS_OLDSAME
175RCV_ROUTING_STEPSRCV_ROUTING_STEPSSAME
176RCV_SERIAL_TRANSACTIONSRCV_SERIAL_TRANSACTIONSSAME
177RCV_SERIALS_INTERFACERCV_SERIALS_INTERFACESAME
178RCV_SERIALS_SUPPLYRCV_SERIALS_SUPPLYSAME
179RCV_SHIPMENT_HEADERSRCV_SHIPMENT_HEADERSSAME
180RCV_SHIPMENT_LINESRCV_SHIPMENT_LINESSAME
181RCV_SHIPMENT_LINES_EFCRCV_SHIPMENT_LINES_EFCSAME
182RCV_SUB_LEDGER_DETAILSRCV_SUB_LEDGER_DETAILSSAME
183RCV_SUPPLYRCV_SUPPLYSAME
184RCV_TRANSACTIONSRCV_TRANSACTIONSSAME
185RCV_TRANSACTIONS_INTERFACERCV_TRANSACTIONS_INTERFACESAME
186RCV_UPGRADE_STEPSRCV_UPGRADE_STEPSSAME
187PO_ATTR_VALUES_ARCHIVENEW
188PO_ATTR_VALUES_INTERFACENEW
189PO_ATTR_VALUES_TLP_ARCHIVENEW
190PO_ATTR_VALUES_TLP_INTERFACENEW
191PO_ATTRIBUTE_VALUESNEW
192PO_ATTRIBUTE_VALUES_DRAFTNEW
193PO_ATTRIBUTE_VALUES_TLPNEW
194PO_ATTRIBUTE_VALUES_TLP_DRAFTNEW
195PO_BC_DISTRIBUTIONSNEW
196PO_CHANGE_ORDER_TOLERANCES_ALLNEW
197PO_DISTRIBUTIONS_DRAFT_ALLNEW
198PO_DOC_STYLE_HEADERSNEW
199PO_DOC_STYLE_LINES_BNEW
200PO_DOC_STYLE_LINES_TLNEW
201PO_DOC_STYLE_VALUESNEW
202PO_DOCUMENT_TOTALS_GTNEW
203PO_DRAFTSNEW
204PO_GA_ORG_ASSIGN_DRAFTNEW
205PO_HEADERS_DRAFT_ALLNEW
206PO_LINE_LOCATIONS_DRAFT_ALLNEW
207PO_LINE_LOCATIONS_INTERFACENEW
208PO_LINES_DRAFT_ALLNEW
209PO_NOTIFICATION_CTRL_DRAFTNEW
210PO_PRICE_DIFF_DRAFTNEW
211PO_RCV_CHARGE_ALLOCATIONSNEW
212PO_RCV_CHARGESNEW
213PO_VALIDATION_RESULTS_GTNEW
214PO_VENDOR_CONTACTS_OBSNEW
215PO_VENDOR_SITES_OBSNEW
216PO_VENDORS_OBSNEW
217PO_WF_USER_TMPNEW
218RCV_CHARGES_INTERFACENEW
219RCV_STAGING_TABLENEW




TOTAL186213









Changes in R12:


Un Changed = 180


New Tables = 33


Deleted = 6

2 comments:

  1. Hi siva krishna,I hope u ru fine,myself i am introducing this is Rajesh from Ahmadabad.Recently i visited u r portal.it is very nice.keep maintain update this blog.Nice articals u r uploaded.Take care.

    Thankfully
    Rajesh.

    ReplyDelete
  2. please provide the information about how to join different tables but having common data with different column names it would be helpful for all the freshers :)

    ReplyDelete