APPS.WIP_PICKING_PVT dependencies on MTL_SYSTEM_ITEMS_B

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

912: wro.wip_supply_type,
913: wro.date_required,
914: msi.revision_qty_control_code
915:
916: from wip_requirement_operations wro, mtl_system_items_b msi, wip_operations wo
917: where wro.wip_entity_id = v_wip_entity_id
918: and ((p_start_date is NULL) OR (wro.date_required >= p_start_date)) /* Enh#2824753 */
919: and ((p_cutoff_date is NULL) OR (wro.date_required <= p_cutoff_date))
920: and (

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

958: wro.wip_supply_type,
959: wro.date_required,
960: msi.revision_qty_control_code
961:
962: from wip_requirement_operations wro, mtl_system_items_b msi, wip_operations wo
963: where wro.wip_entity_id = v_wip_entity_id
964: and ((p_start_date is NULL) OR (wro.date_required >= p_start_date)) /* Enh#2824753 */
965: and ((p_cutoff_date is NULL) OR (wro.date_required <= p_cutoff_date))
966: /*Bug 5255566 (FP Bug 5504661) : Changed below condition to show only components having open quantity greater then

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

998: wro.wip_supply_type,
999: wro.date_required,
1000: msi.revision_qty_control_code
1001:
1002: from wip_requirement_operations wro, wip_operations wo, mtl_system_items_b msi
1003: where wro.wip_entity_id = v_wip_entity_id
1004: and wro.wip_entity_id = wo.wip_entity_id
1005: and wro.operation_seq_num = wo.operation_seq_num
1006: and ((p_start_date is NULL) OR (wro.date_required >= p_start_date)) /* Enh#2824753 */

Line 1051: mtl_system_items_b msi,

1047: msi.revision_qty_control_code
1048:
1049: from wip_requirement_operations wro,
1050: wip_repetitive_schedules wrs,
1051: mtl_system_items_b msi,
1052: wip_operations wo
1053: where wro.repetitive_schedule_id = v_rep_sched_id
1054: and wrs.repetitive_schedule_id = v_rep_sched_id
1055: and ((p_start_date is NULL) OR (wro.date_required >= p_start_date)) /* Enh#2824753 */

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

1850: l_supplyType,
1851: l_reqDate,
1852: l_revControlCode
1853:
1854: from wip_requirement_operations wro, mtl_system_items_b msi, wip_operations wo
1855: where wro.wip_entity_id = p_alloc_comp_tbl(i).wip_entity_id
1856: and ((p_cutoff_date is NULL) OR (wro.date_required < p_cutoff_date))
1857: and (
1858: ( 'Y' = (select allocate_backflush_components

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

1894: l_supplyType,
1895: l_reqDate,
1896: l_revControlCode
1897:
1898: from wip_requirement_operations wro, mtl_system_items_b msi, wip_operations wo
1899: where wro.wip_entity_id = p_alloc_comp_tbl(i).wip_entity_id
1900: and ((p_cutoff_date is NULL) OR (wro.date_required < p_cutoff_date))
1901: and wro.required_quantity > (wro.quantity_issued +
1902: nvl(wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,

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

1930: l_supplyType,
1931: l_reqDate,
1932: l_revControlCode
1933:
1934: from wip_requirement_operations wro, wip_operations wo, mtl_system_items_b msi
1935: where wro.wip_entity_id = p_alloc_comp_tbl(i).wip_entity_id
1936: and wro.wip_entity_id = wo.wip_entity_id
1937: and wro.operation_seq_num = p_alloc_comp_tbl(i).operation_seq_num
1938: and wro.operation_seq_num = wo.operation_seq_num

Line 1982: mtl_system_items_b msi,

1978: l_revControlCode
1979:
1980: from wip_requirement_operations wro,
1981: wip_repetitive_schedules wrs,
1982: mtl_system_items_b msi,
1983: wip_operations wo
1984: where wro.repetitive_schedule_id = p_alloc_comp_tbl(i).repetitive_schedule_id
1985: and wrs.repetitive_schedule_id = p_alloc_comp_tbl(i).repetitive_schedule_id
1986: and ((p_cutoff_date is null) OR (wro.date_required < p_cutoff_date))