DBA Data[Home] [Help]

APPS.WIP_BATCH_MOVE dependencies on WIP_DISCRETE_JOBS

Line 124: FROM wip_discrete_jobs wdj,

120: pjm_project.all_proj_idtonum(wdj.project_id) project_number,
121: wdj.task_id task_id,
122: pjm_project.all_task_idtonum(wdj.task_id) task_number,
123: wdj.bom_revision bom_revision
124: FROM wip_discrete_jobs wdj,
125: wip_operations wo1,
126: wip_operations wo2,
127: mtl_system_items_kfv msik,
128: bom_standard_operations bso1,

Line 298: FROM wip_discrete_jobs wdj,

294: wdj.task_id task_id,
295: pjm_project.all_task_idtonum(wdj.task_id) task_number,
296: wdj.bom_revision bom_revision,
297: p_default_scrap_acct_id scrap_acct_id
298: FROM wip_discrete_jobs wdj,
299: wip_operations wo1,
300: wip_operations wo2,
301: mtl_system_items_kfv msik,
302: bom_standard_operations bso1,

Line 911: wip_discrete_jobs wdj

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
915: AND wmti.wip_entity_id = wdj.wip_entity_id

Line 1417: wip_discrete_jobs wdj

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
1421: AND msn.serial_number = p_assy_serial;