DBA Data[Home] [Help]

APPS.WIP_MOVPROC_PRIV dependencies on DUAL

Line 8114: FROM DUAL)

8110: date_completed
8111: ) =
8112: (SELECT WIP_CONSTANTS.COMP_CHRG, -- status_type
8113: SYSDATE -- date_completed
8114: FROM DUAL)
8115: WHERE wdj.rowid IN
8116: (SELECT wdj2.rowid
8117: FROM wip_discrete_jobs wdj2,
8118: wip_move_txn_interface wmti

Line 8226: FROM DUAL;

8222: IF(p_gib.mtl_header_id IS NULL OR
8223: p_gib.mtl_header_id = -1) THEN
8224: SELECT mtl_material_transactions_s.nextval
8225: INTO p_gib.mtl_header_id
8226: FROM DUAL;
8227: END IF;
8228:
8229: -- initialize transaction mode
8230: IF(p_gib.move_mode = WIP_CONSTANTS.ONLINE AND

Line 8723: FROM DUAL;

8719: IF(p_gib.mtl_header_id IS NULL OR
8720: p_gib.mtl_header_id = -1) THEN
8721: SELECT mtl_material_transactions_s.nextval
8722: INTO p_gib.mtl_header_id
8723: FROM DUAL;
8724: END IF;
8725:
8726: IF(p_gib.assy_header_id IS NULL OR
8727: p_gib.assy_header_id = -1) THEN

Line 8732: FROM DUAL;

8728: -- Generate new header ID for assembly records because we want inventory
8729: -- to process assembly records, but not component records.
8730: SELECT mtl_material_transactions_s.nextval
8731: INTO p_gib.assy_header_id
8732: FROM DUAL;
8733: END IF;
8734:
8735: /* set transaction type */
8736: IF (p_txn_type = WIP_CONSTANTS.RET_TXN) THEN

Line 10447: FROM DUAL;

10443: IF(l_gib.mtl_header_id IS NULL OR
10444: l_gib.mtl_header_id = -1) THEN
10445: SELECT mtl_material_transactions_s.nextval
10446: INTO l_gib.mtl_header_id
10447: FROM DUAL;
10448: END IF;
10449:
10450: -- backflush operation pull, and assembly pull for scrap.
10451: OPEN c_backflush(p_txn_date => l_gib.txn_date);