APPS.WIP_PICKING_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 938: from wip_requirement_operations wro, mtl_system_items_b msi, wip_operations wo,wip_discrete_jobs wdj /*Bug 14050050 */

934: wro.wip_supply_type,
935: wro.date_required,
936: msi.revision_qty_control_code
937:
938: from wip_requirement_operations wro, mtl_system_items_b msi, wip_operations wo,wip_discrete_jobs wdj /*Bug 14050050 */
939: where wro.wip_entity_id = v_wip_entity_id
940: and ((p_start_date is NULL) OR (wro.date_required >= p_start_date)) /* Enh#2824753 */
941: and ((p_cutoff_date is NULL) OR (wro.date_required <= p_cutoff_date))
942: and (

Line 987: from wip_requirement_operations wro, mtl_system_items_b msi, wip_operations wo

983: wro.wip_supply_type,
984: wro.date_required,
985: msi.revision_qty_control_code
986:
987: from wip_requirement_operations wro, mtl_system_items_b msi, wip_operations wo
988: where wro.wip_entity_id = v_wip_entity_id
989: and ((p_start_date is NULL) OR (wro.date_required >= p_start_date)) /* Enh#2824753 */
990: and ((p_cutoff_date is NULL) OR (wro.date_required <= p_cutoff_date))
991: /*Bug 5255566 (FP Bug 5504661) : Changed below condition to show only components having open quantity greater then

Line 1027: from wip_requirement_operations wro, wip_operations wo, mtl_system_items_b msi

1023: wro.wip_supply_type,
1024: wro.date_required,
1025: msi.revision_qty_control_code
1026:
1027: from wip_requirement_operations wro, wip_operations wo, mtl_system_items_b msi
1028: where wro.wip_entity_id = v_wip_entity_id
1029: and wro.wip_entity_id = wo.wip_entity_id
1030: and wro.operation_seq_num = wo.operation_seq_num
1031: and ((p_start_date is NULL) OR (wro.date_required >= p_start_date)) /* Enh#2824753 */

Line 1076: mtl_system_items_b msi,

1072: msi.revision_qty_control_code
1073:
1074: from wip_requirement_operations wro,
1075: wip_repetitive_schedules wrs,
1076: mtl_system_items_b msi,
1077: wip_operations wo
1078: where wro.repetitive_schedule_id = v_rep_sched_id
1079: and wrs.repetitive_schedule_id = v_rep_sched_id
1080: and ((p_start_date is NULL) OR (wro.date_required >= p_start_date)) /* Enh#2824753 */

Line 1892: from wip_requirement_operations wro, mtl_system_items_b msi, wip_operations wo

1888: l_supplyType,
1889: l_reqDate,
1890: l_revControlCode
1891:
1892: from wip_requirement_operations wro, mtl_system_items_b msi, wip_operations wo
1893: where wro.wip_entity_id = p_alloc_comp_tbl(i).wip_entity_id
1894: and ((p_cutoff_date is NULL) OR (wro.date_required < p_cutoff_date))
1895: and (
1896: ( 'Y' = (select allocate_backflush_components

Line 1936: from wip_requirement_operations wro, mtl_system_items_b msi, wip_operations wo

1932: l_supplyType,
1933: l_reqDate,
1934: l_revControlCode
1935:
1936: from wip_requirement_operations wro, mtl_system_items_b msi, wip_operations wo
1937: where wro.wip_entity_id = p_alloc_comp_tbl(i).wip_entity_id
1938: and ((p_cutoff_date is NULL) OR (wro.date_required < p_cutoff_date))
1939: and wro.required_quantity > (wro.quantity_issued +
1940: nvl(wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,

Line 1972: from wip_requirement_operations wro, wip_operations wo, mtl_system_items_b msi

1968: l_supplyType,
1969: l_reqDate,
1970: l_revControlCode
1971:
1972: from wip_requirement_operations wro, wip_operations wo, mtl_system_items_b msi
1973: where wro.wip_entity_id = p_alloc_comp_tbl(i).wip_entity_id
1974: and wro.wip_entity_id = wo.wip_entity_id
1975: and wro.operation_seq_num = p_alloc_comp_tbl(i).operation_seq_num
1976: and wro.operation_seq_num = wo.operation_seq_num

Line 2020: mtl_system_items_b msi,

2016: l_revControlCode
2017:
2018: from wip_requirement_operations wro,
2019: wip_repetitive_schedules wrs,
2020: mtl_system_items_b msi,
2021: wip_operations wo
2022: where wro.repetitive_schedule_id = p_alloc_comp_tbl(i).repetitive_schedule_id
2023: and wrs.repetitive_schedule_id = p_alloc_comp_tbl(i).repetitive_schedule_id
2024: and ((p_cutoff_date is null) OR (wro.date_required < p_cutoff_date))