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 409: FROM wip_discrete_jobs wdj,

405: wdj.task_id task_id,
406: pjm_project.all_task_idtonum(wdj.task_id) task_number,
407: wdj.bom_revision bom_revision,
408: p_default_scrap_acct_id scrap_acct_id
409: FROM wip_discrete_jobs wdj,
410: wip_operations wo1,
411: wip_operations wo2,
412: mtl_system_items_kfv msik,
413: bom_standard_operations bso1,

Line 1022: wip_discrete_jobs wdj

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

Line 1601: from wip_discrete_jobs wdj

1597:
1598: --Fix bug 13336388, determine whether is serialized job
1599: select nvl(wdj.serialization_start_op, -1)
1600: into l_is_serialized
1601: from wip_discrete_jobs wdj
1602: where wdj.wip_entity_id = p_wip_entity_id
1603: and wdj.organization_id = p_org_id;
1604:
1605: ELSE -- Express move from search serial page, quantity can be splitted.

Line 1611: wip_discrete_jobs wdj

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