eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_VAL_DISTRIBUTIONS2 dependencies on PO_SESSION_GT

Line 447: l_key po_session_gt.key%TYPE;

443: d_mod CONSTANT VARCHAR2(100) := d_destination_type_code;
444: d_position NUMBER;
445:
446: -- key of temp table used to identify the derived result
447: l_key po_session_gt.key%TYPE;
448: l_num_list_tbl DBMS_SQL.NUMBER_TABLE;
449:
450: -- tables to store the derived result
451: l_index_tbl PO_TBL_NUMBER;

Line 525: INSERT INTO po_session_gt(key, num1, char1)

521:
522: d_position := 40;
523:
524: FORALL i IN 1..l_num_list_tbl.COUNT
525: INSERT INTO po_session_gt(key, num1, char1)
526: SELECT l_key,
527: l_num_list_tbl(i),
528: decode(msi.outside_operation_flag,'Y','O', decode(msi.stock_enabled_flag,'Y','E','D'))
529: FROM mtl_system_items msi

Line 536: DELETE FROM po_session_gt

532: AND msi.inventory_item_id = p_item_id_tbl(i);
533:
534: d_position := 50;
535:
536: DELETE FROM po_session_gt
537: WHERE key = l_key
538: RETURNING num1, char1
539: BULK COLLECT INTO l_index_tbl, l_result_tbl;
540: