DBA Data[Home] [Help]

APPS.WIP_MOVPROC_PRIV dependencies on DUAL

Line 7911: FROM DUAL)

7907: date_completed
7908: ) =
7909: (SELECT WIP_CONSTANTS.COMP_CHRG, -- status_type
7910: SYSDATE -- date_completed
7911: FROM DUAL)
7912: WHERE wdj.rowid IN
7913: (SELECT wdj2.rowid
7914: FROM wip_discrete_jobs wdj2,
7915: wip_move_txn_interface wmti

Line 8015: FROM DUAL;

8011: IF(p_gib.mtl_header_id IS NULL OR
8012: p_gib.mtl_header_id = -1) THEN
8013: SELECT mtl_material_transactions_s.nextval
8014: INTO p_gib.mtl_header_id
8015: FROM DUAL;
8016: END IF;
8017:
8018: -- initialize transaction mode
8019: IF(p_gib.move_mode = WIP_CONSTANTS.ONLINE AND

Line 8480: FROM DUAL;

8476: IF(p_gib.mtl_header_id IS NULL OR
8477: p_gib.mtl_header_id = -1) THEN
8478: SELECT mtl_material_transactions_s.nextval
8479: INTO p_gib.mtl_header_id
8480: FROM DUAL;
8481: END IF;
8482:
8483: IF(p_gib.assy_header_id IS NULL OR
8484: p_gib.assy_header_id = -1) THEN

Line 8489: FROM DUAL;

8485: -- Generate new header ID for assembly records because we want inventory
8486: -- to process assembly records, but not component records.
8487: SELECT mtl_material_transactions_s.nextval
8488: INTO p_gib.assy_header_id
8489: FROM DUAL;
8490: END IF;
8491:
8492: /* set transaction type */
8493: IF (p_txn_type = WIP_CONSTANTS.RET_TXN) THEN

Line 10094: FROM DUAL;

10090: IF(l_gib.mtl_header_id IS NULL OR
10091: l_gib.mtl_header_id = -1) THEN
10092: SELECT mtl_material_transactions_s.nextval
10093: INTO l_gib.mtl_header_id
10094: FROM DUAL;
10095: END IF;
10096:
10097: -- backflush operation pull, and assembly pull for scrap.
10098: OPEN c_backflush(p_txn_date => l_gib.txn_date);