DBA Data[Home] [Help]

APPS.WIP_BATCH_MOVE dependencies on MTL_SERIAL_NUMBERS

Line 1021: mtl_serial_numbers msn,

1017: wmti.program_application_id,
1018: wmti.program_id,
1019: wmti.program_update_date
1020: FROM wip_move_txn_interface wmti,
1021: mtl_serial_numbers msn,
1022: wip_discrete_jobs wdj
1023: WHERE wmti.transaction_id = l_txn_id
1024: AND wmti.group_id = x_group_id
1025: AND wmti.organization_id = wdj.organization_id

Line 1522: from mtl_serial_numbers msn

1518: p_org_id NUMBER,
1519: p_op_seq NUMBER,
1520: p_op_step NUMBER) IS
1521: select msn.serial_number
1522: from mtl_serial_numbers msn
1523: where msn.wip_entity_id = p_wip_entity_id
1524: and msn.current_organization_id = p_org_id
1525: and (msn.operation_seq_num IS NULL OR
1526: msn.operation_seq_num = p_op_seq)

Line 1610: FROM mtl_serial_numbers msn,

1606: l_process_phase := '2.2';
1607: -- From_step is the current location of the serial.
1608: SELECT nvl(msn.intraoperation_step_type, WIP_CONSTANTS.QUEUE)
1609: INTO l_fm_step_type
1610: FROM mtl_serial_numbers msn,
1611: wip_discrete_jobs wdj
1612: WHERE wdj.organization_id = p_org_id
1613: AND wdj.wip_entity_id = p_wip_entity_id
1614: AND msn.inventory_item_id = wdj.primary_item_id