DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 3765: SELECT mtl_material_transactions_s.NEXTVAL

3761: IF (l_debug =1) THEN
3762: mydebug('RCV LPN: Always generate new txn header id');
3763: END IF;
3764:
3765: SELECT mtl_material_transactions_s.NEXTVAL
3766: INTO l_txn_header_id
3767: FROM DUAL;
3768: ELSE
3769: IF (l_debug =1) THEN

Line 4026: SELECT mtl_material_transactions_s.NEXTVAL

4022: )
4023: )
4024: ) THEN
4025: -- Need to get the next value for serial temp id
4026: SELECT mtl_material_transactions_s.NEXTVAL
4027: INTO l_ser_seq
4028: FROM DUAL;
4029:
4030: IF (l_debug = 1) THEN

Line 8295: SELECT mtl_material_transactions_s.NEXTVAL

8291: mydebug('Cost Group ID: ======> ' || v_mo_line.to_cost_group_id);
8292: END IF;
8293:
8294: -- Get a new transaction header id from the sequence
8295: SELECT mtl_material_transactions_s.NEXTVAL
8296: INTO l_txn_header_id
8297: FROM DUAL;
8298:
8299: IF (l_debug = 1) THEN