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.WMS_RULE_PVT dependencies on WMS_TRANSACTIONS_TEMP_S

Line 885: , secondary_quantity wms_transactions_temp.secondary_quantity%TYPE

881: , uom_code VARCHAR2(3)
882: , lpn_id NUMBER
883: , serial_number VARCHAR2(30)
884: , quantity wms_transactions_temp.primary_quantity%TYPE
885: , secondary_quantity wms_transactions_temp.secondary_quantity%TYPE
886: , grade_code wms_transactions_temp.grade_code%TYPE
887: , secondary_uom_code VARCHAR2(3)
888: , consist_string VARCHAR2(1000)
889: , order_by_string VARCHAR2(1000)

Line 6333: VALUES ( wms_transactions_temp_s.NEXTVAL

6329: , from_cost_group_id
6330: , to_cost_group_id
6331: , lpn_id
6332: )
6333: VALUES ( wms_transactions_temp_s.NEXTVAL
6334: , p_transaction_temp_id
6335: , p_type_code
6336: , 2 -- line type code is output
6337: , l_possible_trx_qty

Line 6410: VALUES ( wms_transactions_temp_s.NEXTVAL

6406: , from_cost_group_id
6407: , to_cost_group_id
6408: , lpn_id
6409: )
6410: VALUES ( wms_transactions_temp_s.NEXTVAL
6411: , p_transaction_temp_id
6412: , p_type_code
6413: , 2 -- line type code is output
6414: , l_possible_trx_qty

Line 7068: wms_transactions_temp_s.NEXTVAL

7064: , to_cost_group_id
7065: , lpn_id
7066: )
7067: VALUES (
7068: wms_transactions_temp_s.NEXTVAL
7069: , p_transaction_temp_id
7070: , p_type_code
7071: , 2 -- line type code is output
7072: , l_possible_trx_qty

Line 8531: l_initial_sec_quantity wms_transactions_temp.secondary_quantity%TYPE;

8527: l_to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
8528: l_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE;
8529: l_lpn_id wms_transactions_temp.lpn_id%TYPE;
8530: l_initial_pri_quantity wms_transactions_temp.primary_quantity%TYPE;
8531: l_initial_sec_quantity wms_transactions_temp.secondary_quantity%TYPE;
8532: -- rule dynamic SQL output variables
8533: l_orevision wms_transactions_temp.revision%TYPE;
8534: l_olot_number wms_transactions_temp.lot_number%TYPE;
8535: l_olot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE;

Line 8544: l_sec_possible_quantity wms_transactions_temp.secondary_quantity%TYPE;

8540: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
8541: l_olpn_id wms_transactions_temp.lpn_id%TYPE;
8542: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;
8543: l_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;
8544: l_sec_possible_quantity wms_transactions_temp.secondary_quantity%TYPE;
8545: l_reservation_id wms_transactions_temp.reservation_id%TYPE;
8546: -- variables needed for qty tree
8547: l_qoh NUMBER;
8548: l_rqoh NUMBER;

Line 13043: wms_transactions_temp_s.NEXTVAL

13039: , to_cost_group_id
13040: , lpn_id
13041: )
13042: VALUES (
13043: wms_transactions_temp_s.NEXTVAL
13044: , p_transaction_temp_id
13045: , p_type_code
13046: , 2 -- line type code is output
13047: , l_possible_trx_qty

Line 14624: ( wms_transactions_temp_s.NEXTVAL

14620: ,FROM_COST_GROUP_ID
14621: ,TO_COST_GROUP_ID
14622: ,LPN_ID
14623: ) VALUES
14624: ( wms_transactions_temp_s.NEXTVAL
14625: ,p_transaction_temp_id
14626: ,1 -- p_type_code
14627: ,2 -- line type code is output
14628: ,l_possible_trx_qty