APPS.WMS_RULE_PVT dependencies on WMS_TRANSACTIONS_TEMP_S

Line 850: , secondary_quantity wms_transactions_temp.secondary_quantity%TYPE

846: , uom_code VARCHAR2(3)
847: , lpn_id NUMBER
848: , serial_number VARCHAR2(30)
849: , quantity wms_transactions_temp.primary_quantity%TYPE
850: , secondary_quantity wms_transactions_temp.secondary_quantity%TYPE
851: , grade_code wms_transactions_temp.grade_code%TYPE
852: , secondary_uom_code VARCHAR2(3)
853: , consist_string VARCHAR2(1000)
854: , order_by_string VARCHAR2(1000)

Line 4765: wms_transactions_temp_s.NEXTVAL

4761: , to_cost_group_id
4762: , lpn_id
4763: )
4764: VALUES (
4765: wms_transactions_temp_s.NEXTVAL
4766: , p_transaction_temp_id
4767: , p_type_code
4768: , 2 -- line type code is output
4769: , l_possible_trx_qty

Line 5337: wms_transactions_temp_s.NEXTVAL

5333: , to_cost_group_id
5334: , lpn_id
5335: )
5336: VALUES (
5337: wms_transactions_temp_s.NEXTVAL
5338: , p_transaction_temp_id
5339: , p_type_code
5340: , 2 -- line type code is output
5341: , l_possible_trx_qty

Line 6579: l_sec_possible_quantity wms_transactions_temp.secondary_quantity%TYPE;

6575: l_ocost_group_id wms_transactions_temp.from_cost_group_id%TYPE;
6576: l_olpn_id wms_transactions_temp.lpn_id%TYPE;
6577: l_possible_quantity wms_transactions_temp.primary_quantity%TYPE;
6578: l_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;
6579: l_sec_possible_quantity wms_transactions_temp.secondary_quantity%TYPE;
6580: l_sec_possible_trx_qty wms_transactions_temp.transaction_quantity%TYPE;
6581: l_reservation_id wms_transactions_temp.reservation_id%TYPE;
6582: -- variables needed for qty tree
6583: l_qoh NUMBER;

Line 10535: wms_transactions_temp_s.NEXTVAL

10531: , to_cost_group_id
10532: , lpn_id
10533: )
10534: VALUES (
10535: wms_transactions_temp_s.NEXTVAL
10536: , p_transaction_temp_id
10537: , p_type_code
10538: , 2 -- line type code is output
10539: , l_possible_trx_qty

Line 12023: ( wms_transactions_temp_s.NEXTVAL

12019: ,FROM_COST_GROUP_ID
12020: ,TO_COST_GROUP_ID
12021: ,LPN_ID
12022: ) VALUES
12023: ( wms_transactions_temp_s.NEXTVAL
12024: ,p_transaction_temp_id
12025: ,1 -- p_type_code
12026: ,2 -- line type code is output
12027: ,l_possible_trx_qty