[Home] [Help]
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 (
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
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 */
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 */
1081: and ((p_cutoff_date is null) OR (wro.date_required <= p_cutoff_date))
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
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,
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
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))
2025: and (
2218: and we.organization_id = p_organization_id
2219: and exists(
2220: select 1
2221: from wip_requirement_operations wro,
2222: wip_operations wo
2223: where we.wip_entity_id = wro.wip_entity_id
2224: and we.organization_id = wro.organization_id
2225: and wro.wip_entity_id = wo.wip_entity_id(+)
2226: and wro.operation_seq_num = wo.operation_seq_num(+)
2241: from wip_entities we,
2242: wip_discrete_jobs wdj,
2243: wip_requirement_operations wro,
2244: wip_parameters wp,
2245: wip_operations wo
2246: where wo.wip_entity_id = we.wip_entity_id
2247: and wo.operation_seq_num = wro.operation_seq_num
2248: and we.wip_entity_id = wdj.wip_entity_id
2249: and we.entity_type = 5
2283: from wip_entities we,
2284: wip_discrete_jobs wdj,
2285: wip_parameters wp,
2286: wip_requirement_operations wro,
2287: wip_operations wo
2288: where we.wip_entity_id = wdj.wip_entity_id
2289: and we.organization_id = wdj.organization_id
2290: and wp.organization_id = wdj.organization_id
2291: and wp.organization_id = we.organization_id
2299: and we.organization_id = p_organization_id
2300: and exists(
2301: select 1
2302: from wip_requirement_operations wro,
2303: wip_operations wo
2304: where we.wip_entity_id = wro.wip_entity_id
2305: and we.organization_id = wro.organization_id
2306: and wro.wip_entity_id = wo.wip_entity_id(+)
2307: and wro.operation_seq_num = wo.operation_seq_num(+)
2328: wip_repetitive_items wri,
2329: wip_requirement_operations wro,
2330: wip_parameters wp,
2331: wip_lines wl,
2332: wip_operations wo
2333: where we.wip_entity_id = wrs.wip_entity_id
2334: and wrs.repetitive_schedule_id = wro.repetitive_schedule_id
2335: and we.wip_entity_id = wri.wip_entity_id
2336: and we.primary_item_id = msik.inventory_item_id