DBA Data[Home] [Help]

APPS.WIP_BATCH_MOVE dependencies on MTL_SERIAL_NUMBERS

Line 910: mtl_serial_numbers msn,

906: wmti.program_application_id,
907: wmti.program_id,
908: wmti.program_update_date
909: FROM wip_move_txn_interface wmti,
910: mtl_serial_numbers msn,
911: wip_discrete_jobs wdj
912: WHERE wmti.transaction_id = l_txn_id
913: AND wmti.group_id = x_group_id
914: AND wmti.organization_id = wdj.organization_id

Line 1416: FROM mtl_serial_numbers msn,

1412: l_process_phase := '2.2';
1413: -- From_step is the current location of the serial.
1414: SELECT nvl(msn.intraoperation_step_type, WIP_CONSTANTS.QUEUE)
1415: INTO l_fm_step_type
1416: FROM mtl_serial_numbers msn,
1417: wip_discrete_jobs wdj
1418: WHERE wdj.organization_id = p_org_id
1419: AND wdj.wip_entity_id = p_wip_entity_id
1420: AND msn.inventory_item_id = wdj.primary_item_id