WRITE TO A FILE USING UTL_FILE

• Create a Table

 Create Table xx_parameters (

 param_name VARCHAR2(100) ,

 param_value NUMBER );

• Input some parameters
• Create a Directory 

CREATE OR REPLACE DIRECTORY DIR_MYTEMP AS '/home/oracle/ebsutl12/';

• Create the Procedure

CREATE OR REPLACE PROCEDURE xxtest_procedure_utl

AS

   CURSOR c_cur1

   IS

      SELECT param_name, param_value

        FROM xx_parameters;

   l_file   UTL_FILE.file_type;

   l_dir    VARCHAR2 (50)      := 'DIR_MYTEMP';

   l_name   VARCHAR2 (20)      := 'mydatafile.txt';

BEGIN

   l_file := UTL_FILE.fopen (l_dir, l_name, 'W');

   FOR cur_rec IN c_cur1

   LOOP

      UTL_FILE.put_line (l_file,

                         cur_rec.param_name || ',' || cur_rec.param_value

                        );

   END LOOP;

   UTL_FILE.fclose (l_file);

EXCEPTION

   WHEN UTL_FILE.invalid_path

   THEN

      DBMS_OUTPUT.put_line (‘invalid_path’);

      RAISE;

   WHEN UTL_FILE.invalid_mode

   THEN

      DBMS_OUTPUT.put_line (‘invalid_mode’);

      RAISE;

   WHEN UTL_FILE.invalid_filehandle

   THEN

      DBMS_OUTPUT.put_line (‘invalid_filehandle’);

      RAISE;

   WHEN UTL_FILE.invalid_operation

   THEN

      DBMS_OUTPUT.put_line (‘invalid_operation’);

      RAISE;

   WHEN UTL_FILE.read_error

   THEN

      DBMS_OUTPUT.put_line (‘read_error’);

      RAISE;

   WHEN UTL_FILE.write_error

   THEN

      DBMS_OUTPUT.put_line (‘write_error’);

      RAISE;

   WHEN UTL_FILE.internal_error

   THEN

      DBMS_OUTPUT.put_line (‘internal_error’);

      RAISE;

END xxtest_procedure_utl;

/

• Executing the procedure will create a file named mydatafile.txt in directory /home/oracle/ebsutl12/

Sample of DBMS_LOCK.SLEEP

• Create a Table

Create Table T_Sleep_Test(
S_No Number,
Dateandtime Date);

• Create a Procedure

CREATE OR REPLACE PROCEDURE XXTEST_PROCEDURE

IS

   l_cnt   NUMBER;

BEGIN

   l_cnt := 0;

   EXECUTE IMMEDIATE 'Truncate Table Xxsleep_table';

   FOR l_cnt IN 1 .. 5

   LOOP

      INSERT INTO xxsleep_table

           VALUES (l_cnt, SYSDATE);

      COMMIT;

      DBMS_LOCK.sleep (10);

   END LOOP;

END;

• Values get inserted into the table created above in an interval of 10 seconds

Exec XXTEST_PROCEDURE;

• Check once the execution of the procedure gets completed.

Select S_No, To_Char(Dateandtime,'DD-MON-RRRR HH24:MI:SS') Ace From   Xxsleep_table;

Locked Session in Oracle

Select L.Session_Id||','||V.Serial# Sid_Serial,
       L.Oracle_Username Ora_User,
       O.Object_Name,
       O.Object_Type,
       Decode(L.Locked_Mode,
          0, 'None',
          1, 'Null',
          2, 'Row-S (SS)',
          3, 'Row-X (SX)',
          4, 'Share',
          5, 'S/Row-X (SSX)',
          6, 'Exclusive',
          To_Char(L.Locked_Mode)
       ) Lock_Mode,
       O.Status,
       To_Char(O.Last_Ddl_Time,'dd.mm.yy') Last_DDL
From Dba_Objects O, Gv$Locked_Object L, V$Session V
Where O.Object_Id = L.Object_Id
      And L.Session_Id=V.Sid
Order By 2,3;

------------------------

ALTER SYSTEM KILL SESSION  'SID,SERIAL'; ( '633,857' );

Differences in the Table Suffix

_ALL - Multi org tables. Show data for all orgs. 
_V - Views. Mostly show data specific to the orgs user has logged in. 
_TL - Translation table. Store name, description etc. in mutliple languages. 
_VL - View which selects only one row from _TL table based on the user session's language and org_id. Uses USERENV ('LANG') to fetch data from join of _V and _TL 
_B - Base table. Mostly used for non-org specific data. 

Base CRM Tables

OKC_K_PARTY_ROLES_B
OKC_K_HEADERS_B
OKC_K_LINES_B
OKC_LINE_STYLES_B
OKC_K_LINES_TL
OKC_K_ITEMS
OKC_RULE_GROUPS_B
OKC_REACT_INTERVALS
OKC_TIMEVALUES_B
OKC_COVER_TIMES
OKC_RULES_B
OKS_BUS_PROCESSES_V
OKS_LEVEL_ELEMENTS
OKX_INCIDENT_SEVERITS_V
CSI_ITEM_INSTANCES
HZ_PARTIES
MTL_SYSTEM_ITEMS_B

Replace Function in Oracle SQL

Select Replace(Replace(Description,Chr(10),' '),Chr(13),' ') Desc_Line_Format From Table_Name;

Legal Entity Oracle Apps

Form Compilation Steps in Oracle Apps

Version R12

Step 1: userid / password
Step 2: cd/oracle/apps/apps_st/appl
Step 3: ls *.env
Step 4: cd/oracle/apps/apps_st/appl/au/12.0.0/forms/US
Step 5: frmcmp_batch module=filename.fmb userid=apps/apps model_type=form output_file=/oracle/apps/apps_st/appl/po/12.0.0/forms/US/filename.fmx compile_all=YES

Version 11i

f60gen module=XX_FORM.fmb userid=apps/apps output_file=$TOP/forms/US/SAMPLE.fmx

Oracle PL/SQL : Get Quantity On hand, Reservable Quantity On hand, Quantity Reserved,Quantity Suggested, Quantity Available to Transact, Quantity Available to Reserve

apps.inv_quantity_tree_pub.query_quantities
(p_api_version_number => 1.0,
p_init_msg_lst => apps.fnd_api.g_false,
x_return_status => l_api_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_organization_id => i.organization_id, --Input
p_inventory_item_id => i.inventory_item_id, --Input
p_tree_mode => 1, --apps.inv_quantity_tree_pub.g_transaction_mode,
p_onhand_source => 3,
p_is_revision_control => FALSE,
p_is_lot_control => FALSE,
p_is_serial_control => FALSE,
p_revision => NULL,
p_lot_number => NULL,
p_subinventory_code => NULL,
p_locator_id => NULL,
x_qoh => l_qty_oh,
x_rqoh => l_qty_res_oh,
x_qr => l_qty_res,
x_qs => l_qty_sug,
x_att => l_qty_att,
x_atr => l_qty_atr);

DBMS_OUTPUT.put_line ('Quantity on hand => '|| TO_CHAR (l_qty_oh));
DBMS_OUTPUT.put_line ('Reservable quantity on hand ===============> '|| TO_CHAR (l_qty_res_oh));
DBMS_OUTPUT.put_line ('Quantity reserved =====================> '|| TO_CHAR (l_qty_res));
DBMS_OUTPUT.put_line ('Quantity suggested ====================> '|| TO_CHAR (l_qty_sug));
DBMS_OUTPUT.put_line ('Quantity Available To Transact => '|| TO_CHAR (l_qty_att));
DBMS_OUTPUT.put_line ('Quantity Available To Reserve => '|| TO_CHAR (l_qty_atr));

R11 to R12 PO And RCV 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  --- MLOG$_PO_VENDOR_SITES_ALL
21 MLOG$_PO_VENDORS  --- 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 --- 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 421 PO_HEADERS_ALL
65 PO_HEADERS_ALL_EBS --- PO_HEADERS_ALL_EBS
66 PO_HEADERS_ARCHIVE_ALL 403 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  --- 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  --- PO_VENDOR_SITES_ALL
146 PO_VENDOR_SITES_ALL_EBS --- PO_VENDOR_SITES_ALL_EBS
147 PO_VENDORS  --- 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