Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Friday, November 4, 2011

Oracle Purchase Order 11i and R12 Tables

PURCHASE ORDER
Un Changed = 180
New Tables = 33
Deleted = 6

11i TABLES                                                R12 TABLES
1 CHV_AUTHORIZATIONS  CHV_AUTHORIZATIONS
2 CHV_BUCKET_PATTERNS  CHV_BUCKET_PATTERNS
3 CHV_CUM_ADJUSTMENTS CHV_CUM_ADJUSTMENTS
4 CHV_CUM_PERIOD_ITEMS  CHV_CUM_PERIOD_ITEMS
5 CHV_CUM_PERIODS  CHV_CUM_PERIODS
6 CHV_HISTORY_CUM_PERIODS  CHV_HISTORY_CUM_PERIODS
7 CHV_HISTORY_SCHEDULES  CHV_HISTORY_SCHEDULES
8 CHV_HORIZONTAL_SCHEDULES  CHV_HORIZONTAL_SCHEDULES
9 CHV_ITEM_ORDERS  CHV_ITEM_ORDERS
10 CHV_ORG_OPTIONS  CHV_ORG_OPTIONS
11 CHV_PURGE_CUM_LIST  CHV_PURGE_CUM_LIST
12 CHV_PURGE_SCHEDULE_LIST  CHV_PURGE_SCHEDULE_LIST
13 CHV_SCHEDULE_HEADERS  CHV_SCHEDULE_HEADERS
14 CHV_SCHEDULE_ITEMS  CHV_SCHEDULE_ITEMS
15 CHV_SCHEDULE_ORGANIZATIONS  CHV_SCHEDULE_ORGANIZATIONS
16 EDW_PO_VENDOR_HIERARCHIES  EDW_PO_VENDOR_HIERARCHIES
17 FND_FUNCTION_PARAMETER_MAP  FND_FUNCTION_PARAMETER_MAP
18 FND_NOTIFICATIONS  FND_NOTIFICATIONS
19 MLOG$_PO_COMMODITY_CATEGOR  MLOG$_PO_COMMODITY_CATEGOR
20 MLOG$_PO_VENDOR_SITES_ALL
21 MLOG$_PO_VENDORS
22 PO_ACCEPTANCES  PO_ACCEPTANCES
23 PO_ACCRUAL_ACCOUNTS_TEMP_ALL     PO_ACCRUAL_ACCOUNTS_TEMP_ALL
24 PO_ACCRUAL_RECONCILE_TEMP_ALL
25 PO_ACCRUAL_WRITE_OFFS_ALL  PO_ACCRUAL_WRITE_OFFS_ALL
26 PO_ACCRUAL_WRITE_OFFS_ALL_EFC    PO_ACCRUAL_WRITE_OFFS_ALL_EFC
27 PO_ACTION_HISTORY  PO_ACTION_HISTORY
28 PO_ADDRESS_DETAILS_GT  PO_ADDRESS_DETAILS_GT
29 PO_AGENTS PO_AGENTS
30 PO_APPROVAL_LIST_HEADERS  PO_APPROVAL_LIST_HEADERS
31 PO_APPROVAL_LIST_LINES  PO_APPROVAL_LIST_LINES
32 PO_APPROVED_SUPPLIER_LIST  PO_APPROVED_SUPPLIER_LIST
33 PO_ASL_ATTRIBUTES  PO_ASL_ATTRIBUTES
34 PO_ASL_DOCUMENTS  PO_ASL_DOCUMENTS
35 PO_ASL_STATUS_RULES  PO_ASL_STATUS_RULES
36 PO_ASL_STATUSES  PO_ASL_STATUSES
37 PO_ATT_TMP_RECORDS  PO_ATT_TMP_RECORDS
38 PO_AUTOSOURCE_DOCUMENTS_ALL     PO_AUTOSOURCE_DOCUMENTS_ALL
39 PO_AUTOSOURCE_RULES  PO_AUTOSOURCE_RULES
40 PO_AUTOSOURCE_VENDORS  PO_AUTOSOURCE_VENDORS
41 PO_CHANGE_REQUESTS  PO_CHANGE_REQUESTS
42 PO_COMMODITIES_B  PO_COMMODITIES_B
43 PO_COMMODITIES_TL  PO_COMMODITIES_TL
44 PO_COMMODITY_CATEGORIES  PO_COMMODITY_CATEGORIES
45 PO_COMMODITY_GRANTS  PO_COMMODITY_GRANTS
46 PO_COMMUNICATION_GT  PO_COMMUNICATION_GT
47 PO_CONTROL_FUNCTIONS  PO_CONTROL_FUNCTIONS
48 PO_CONTROL_GROUPS_ALL  PO_CONTROL_GROUPS_ALL
49 PO_CONTROL_RULES  PO_CONTROL_RULES
50 PO_CONTROL_RULES_EFC  PO_CONTROL_RULES_EFC
51 PO_DISTRIBUTIONS_ALL  PO_DISTRIBUTIONS_ALL
52 PO_DISTRIBUTIONS_ALL_EBS  PO_DISTRIBUTIONS_ALL_EBS
53 PO_DISTRIBUTIONS_ARCHIVE_ALL  PO_DISTRIBUTIONS_ARCHIVE_ALL
54 PO_DISTRIBUTIONS_GT  PO_DISTRIBUTIONS_GT
55 PO_DISTRIBUTIONS_INTERFACE  PO_DISTRIBUTIONS_INTERFACE
56 PO_DOCUMENT_TYPES_ALL_B  PO_DOCUMENT_TYPES_ALL_B
57 PO_DOCUMENT_TYPES_ALL_TL  PO_DOCUMENT_TYPES_ALL_TL
58 PO_EMPLOYEE_HIERARCHIES_ALL  PO_EMPLOYEE_HIERARCHIES_ALL
59 PO_ENCUMBRANCE_GT  PO_ENCUMBRANCE_GT
60 PO_GA_ORG_ASSIGNMENTS  PO_GA_ORG_ASSIGNMENTS
61 PO_GA_ORG_ASSIGNMENTS_ARCHIVE  PO_GA_ORG_ASSIGNMENTS_ARCHIVE
62 PO_HAZARD_CLASSES_B  PO_HAZARD_CLASSES_B
63 PO_HAZARD_CLASSES_TL  PO_HAZARD_CLASSES_TL
64 PO_HEADERS_ALL  PO_HEADERS_ALL
65 PO_HEADERS_ALL_EBS  PO_HEADERS_ALL_EBS
66 PO_HEADERS_ARCHIVE_ALL  PO_HEADERS_ARCHIVE_ALL
67 PO_HEADERS_GT  PO_HEADERS_GT
68 PO_HEADERS_INTERFACE  PO_HEADERS_INTERFACE
69 PO_HISTORY_POS_ALL  PO_HISTORY_POS_ALL
70 PO_HISTORY_RECEIPTS  PO_HISTORY_RECEIPTS
71 PO_HISTORY_REQUISITIONS_ALL  PO_HISTORY_REQUISITIONS_ALL
72 PO_HISTORY_VENDORS  PO_HISTORY_VENDORS
73 PO_INTERFACE_ERRORS  PO_INTERFACE_ERRORS
74 PO_JOB_ASSOCIATIONS_B  PO_JOB_ASSOCIATIONS_B
75 PO_JOB_ASSOCIATIONS_TL  PO_JOB_ASSOCIATIONS_TL
76 PO_LINE_LOCATIONS_ALL  PO_LINE_LOCATIONS_ALL
77 PO_LINE_LOCATIONS_ALL_EBS PO_LINE_LOCATIONS_ALL_EBS
78 PO_LINE_LOCATIONS_ARCHIVE_ALL     PO_LINE_LOCATIONS_ARCHIVE_ALL
79 PO_LINE_LOCATIONS_GT  PO_LINE_LOCATIONS_GT
80 PO_LINE_TYPES_B  PO_LINE_TYPES_B
81 PO_LINE_TYPES_TL  PO_LINE_TYPES_TL
82 PO_LINES_ALL  PO_LINES_ALL
83 PO_LINES_ALL_EBS  PO_LINES_ALL_EBS
84 PO_LINES_ARCHIVE_ALL  PO_LINES_ARCHIVE_ALL
85 PO_LINES_GT  PO_LINES_GT
86 PO_LINES_INTERFACE  PO_LINES_INTERFACE
87 PO_LOCATION_ASSOCIATIONS_ALL      PO_LOCATION_ASSOCIATIONS_ALL
88 PO_MASSCANCEL_INCLUDES_ALL  PO_MASSCANCEL_INCLUDES_ALL
89 PO_MASSCANCEL_INTERIM  PO_MASSCANCEL_INTERIM
90 PO_MC_DISTRIBUTIONS  PO_MC_DISTRIBUTIONS
91 PO_MC_HEADERS  PO_MC_HEADERS
92 PO_NOTE_ATTRIBUTES  PO_NOTE_ATTRIBUTES
93 PO_NOTE_REFERENCES  PO_NOTE_REFERENCES
94 PO_NOTES  PO_NOTES
95 PO_NOTIFICATION_CONTROLS  PO_NOTIFICATION_CONTROLS
96 PO_NOTIFICATIONS_ALL  PO_NOTIFICATIONS_ALL
97 PO_ONLINE_REPORT_TEXT  PO_ONLINE_REPORT_TEXT
98 PO_ONLINE_REPORT_TEXT_GT  PO_ONLINE_REPORT_TEXT_GT
99 PO_POSITION_CONTROLS_ALL  PO_POSITION_CONTROLS_ALL
100 PO_PRICE_DIFF_INTERFACE  PO_PRICE_DIFF_INTERFACE
101 PO_PRICE_DIFFERENTIALS  PO_PRICE_DIFFERENTIALS
102 PO_PRICE_DIFFERENTIALS_ARCHIVE  PO_PRICE_DIFFERENTIALS_ARCHIVE
103 PO_PURGE_PO_LIST  PO_PURGE_PO_LIST
104 PO_PURGE_REQ_LIST  PO_PURGE_REQ_LIST
105 PO_PURGE_VENDOR_LIST  PO_PURGE_VENDOR_LIST
106 PO_QUALITY_CODES  PO_QUALITY_CODES
107 PO_QUOTATION_APPROVALS_ALL  PO_QUOTATION_APPROVALS_ALL
108 PO_RELATED_TEMPLATES  PO_RELATED_TEMPLATES
109 PO_RELEASES_ALL  PO_RELEASES_ALL
110 PO_RELEASES_ALL_EBS  PO_RELEASES_ALL_EBS
111 PO_RELEASES_ARCHIVE_ALL  PO_RELEASES_ARCHIVE_ALL
112 PO_RELEASES_GT  PO_RELEASES_GT
113 PO_REQ_DIST_INTERFACE_ALL  PO_REQ_DIST_INTERFACE_ALL
114 PO_REQ_DISTRIBUTIONS_ALL PO_REQ_DISTRIBUTIONS_ALL
115 PO_REQ_DISTRIBUTIONS_ALL_EFC  PO_REQ_DISTRIBUTIONS_ALL_EFC
116 PO_REQ_DISTRIBUTIONS_GT  PO_REQ_DISTRIBUTIONS_GT
117 PO_REQ_HEADERS_GT  PO_REQ_HEADERS_GT
118 PO_REQ_LINES_GT  PO_REQ_LINES_GT
119 PO_REQ_SPLIT_LINES_GT  PO_REQ_SPLIT_LINES_GT
120 PO_REQEXPRESS_HEADERS_ALL  PO_REQEXPRESS_HEADERS_ALL
121 PO_REQEXPRESS_LINES_ALL  PO_REQEXPRESS_LINES_ALL
122 PO_REQUISITION_HEADERS_ALL  PO_REQUISITION_HEADERS_ALL
123 PO_REQUISITION_LINES_ALL  PO_REQUISITION_LINES_ALL
124 PO_REQUISITION_LINES_ALL_EFC  PO_REQUISITION_LINES_ALL_EFC
125 PO_REQUISITION_SUPPLIERS  PO_REQUISITION_SUPPLIERS
126 PO_REQUISITIONS_INT_ALL_EFC  PO_REQUISITIONS_INT_ALL_EFC
127 PO_REQUISITIONS_INTERFACE_ALL   PO_REQUISITIONS_INTERFACE_ALL
128 PO_RESCHEDULE_INTERFACE  PO_RESCHEDULE_INTERFACE
129 PO_RETRIEVED_TIMECARDS  PO_RETRIEVED_TIMECARDS
130 PO_RETROPRICE_GT  PO_RETROPRICE_GT
131 PO_RFQ_VENDORS  PO_RFQ_VENDORS
132 PO_RULE_EXPENSE_ACCOUNTS  PO_RULE_EXPENSE_ACCOUNTS
133 PO_SESSION_GT  PO_SESSION_GT
134 PO_SUPPLIER_ITEM_CAPACITY PO_SUPPLIER_ITEM_CAPACITY
135 PO_SUPPLIER_ITEM_TOLERANCE  PO_SUPPLIER_ITEM_TOLERANCE
136 PO_SYSTEM_PARAMETERS_ALL  PO_SYSTEM_PARAMETERS_ALL
137 PO_UN_NUMBERS_B  PO_UN_NUMBERS_B
138 PO_UN_NUMBERS_TL  PO_UN_NUMBERS_TL
139 PO_UNIQUE_IDENTIFIER_CONT_ALL  PO_UNIQUE_IDENTIFIER_CONT_ALL
140 PO_USAGE_ATTRIBUTES  PO_USAGE_ATTRIBUTES
141 PO_USAGES  PO_USAGES
142 PO_VENDOR_CONTACTS
143 PO_VENDOR_LIST_ENTRIES  PO_VENDOR_LIST_ENTRIES
144 PO_VENDOR_LIST_HEADERS  PO_VENDOR_LIST_HEADERS
145 PO_VENDOR_SITES_ALL
146 PO_VENDOR_SITES_ALL_EBS  PO_VENDOR_SITES_ALL_EBS
147 PO_VENDORS
148 PO_VENDORS_EBS  PO_VENDORS_EBS
149 PO_WF_CANDIDATE_REQ_LINES_TEMP   PO_WF_CANDIDATE_REQ_LINES_TEMP
150 PO_WF_DEBUG  PO_WF_DEBUG
151 POA_BIS_SAVINGS  POA_BIS_SAVINGS
152 POA_BIS_SAVINGS_EFC  POA_BIS_SAVINGS_EFC
153 POA_BIS_SAVINGS_RPT  POA_BIS_SAVINGS_RPT
154 POA_BIS_SAVINGS_RPT_EFC  POA_BIS_SAVINGS_RPT_EFC
155 POA_BIS_SUPPLIER_PERFORMAN_EFC  POA_BIS_SUPPLIER_PERFORMAN_EFC
156 POA_BIS_SUPPLIER_PERFORMANCE    POA_BIS_SUPPLIER_PERFORMANCE
157 POA_CM_DISTRIBUTIONS  POA_CM_DISTRIBUTIONS
158 POA_CM_EVAL_SCORES  POA_CM_EVAL_SCORES
159 POA_CM_EVALUATION  POA_CM_EVALUATION
160 RCV_ACCOUNTING_EVENT_TYPES  RCV_ACCOUNTING_EVENT_TYPES
161 RCV_ACCOUNTING_EVENTS  RCV_ACCOUNTING_EVENTS
162 RCV_FTE_TRANSACTION_LINES  RCV_FTE_TRANSACTION_LINES
163 RCV_GAPLESS_INVOICE_NUMBERS  RCV_GAPLESS_INVOICE_NUMBERS
164 RCV_HEADERS_INTERFACE  RCV_HEADERS_INTERFACE
165 RCV_LOT_TRANSACTIONS  RCV_LOT_TRANSACTIONS
166 RCV_LOTS_INTERFACE  RCV_LOTS_INTERFACE
167 RCV_LOTS_SUPPLY  RCV_LOTS_SUPPLY
168 RCV_MC_REC_SUB_LEDGER  RCV_MC_REC_SUB_LEDGER
169 RCV_MC_SHIPMENT_HEADERS   RCV_MC_SHIPMENT_HEADERS
170 RCV_MC_SUB_LEDGER_DETAILS  RCV_MC_SUB_LEDGER_DETAILS
171 RCV_MC_TRANSACTIONS  RCV_MC_TRANSACTIONS
172 RCV_PARAMETERS  RCV_PARAMETERS
173 RCV_RECEIVING_SUB_LEDGER RCV_RECEIVING_SUB_LEDGER
174 RCV_ROUTING_HEADERS_OLD RCV_ROUTING_HEADERS_OLD
175 RCV_ROUTING_STEPS  RCV_ROUTING_STEPS
176 RCV_SERIAL_TRANSACTIONS  RCV_SERIAL_TRANSACTIONS
177 RCV_SERIALS_INTERFACE  RCV_SERIALS_INTERFACE
178 RCV_SERIALS_SUPPLY  RCV_SERIALS_SUPPLY
179 RCV_SHIPMENT_HEADERS  RCV_SHIPMENT_HEADERS
180 RCV_SHIPMENT_LINES  RCV_SHIPMENT_LINES
181 RCV_SHIPMENT_LINES_EFC  RCV_SHIPMENT_LINES_EFC
182 RCV_SUB_LEDGER_DETAILS  RCV_SUB_LEDGER_DETAILS
183 RCV_SUPPLY  RCV_SUPPLY
184 RCV_TRANSACTIONS  RCV_TRANSACTIONS
185 RCV_TRANSACTIONS_INTERFACE  RCV_TRANSACTIONS_INTERFACE
186 RCV_UPGRADE_STEPS  RCV_UPGRADE_STEPS
187                                                      PO_ATTR_VALUES_ARCHIVE
188                                                      PO_ATTR_VALUES_INTERFACE
189
PO_ATTR_VALUES_TLP_ARCHIVE
190
PO_ATTR_VALUES_TLP_INTERFACE
191
PO_ATTRIBUTE_VALUES
192
PO_ATTRIBUTE_VALUES_DRAFT
193
PO_ATTRIBUTE_VALUES_TLP
194
PO_ATTRIBUTE_VALUES_TLP_DRAFT
195
PO_BC_DISTRIBUTIONS
196
PO_CHANGE_ORDER_TOLERANCES_ALL
197
PO_DISTRIBUTIONS_DRAFT_ALL
198
PO_DOC_STYLE_HEADERS
199
PO_DOC_STYLE_LINES_B
200
PO_DOC_STYLE_LINES_TL
201
PO_DOC_STYLE_VALUES
202
PO_DOCUMENT_TOTALS_GT
203
PO_DRAFTS
204
PO_GA_ORG_ASSIGN_DRAFT
205
PO_HEADERS_DRAFT_ALL
206
PO_LINE_LOCATIONS_DRAFT_ALL
207
PO_LINE_LOCATIONS_INTERFACE
208
PO_LINES_DRAFT_ALL
209
PO_NOTIFICATION_CTRL_DRAFT
210
PO_PRICE_DIFF_DRAFT
211
PO_RCV_CHARGE_ALLOCATIONS
212
PO_RCV_CHARGES
213
PO_VALIDATION_RESULTS_GT
214
PO_VENDOR_CONTACTS_OBS
215
PO_VENDOR_SITES_OBS
216
PO_VENDORS_OBS
217
PO_WF_USER_TMP
218
RCV_CHARGES_INTERFACE
219
RCV_STAGING_TABLE

No comments:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect