APPS.JMF_SHIKYU_RPT_CFR_PVT dependencies on WIP_REQUIREMENT_OPERATIONS

Line 2160: ,wip_requirement_operations wip_req

2156: FROM po_line_locations_all pll
2157: ,jmf_subcontract_orders sub_po
2158: ,po_headers_all ph
2159: ,jmf_shikyu_components comp
2160: ,wip_requirement_operations wip_req
2161: WHERE pll.line_location_id = sub_po.subcontract_po_shipment_id
2162: AND pll.quantity > pll.quantity_received --this can be ignore if allow the allocated qty larger than ordered qty
2163: AND sub_po.oem_organization_id = p_oem_inv_org_id
2164: AND sub_po.tp_organization_id = p_tp_inv_org_id

Line 2341: ,wip_requirement_operations wro

2337: FROM jmf_shikyu_allocations alloc
2338: ,jmf_shikyu_replenishments jsr
2339: ,jmf_shikyu_cfr_mid_temp mid
2340: ,jmf_subcontract_orders jso
2341: ,wip_requirement_operations wro
2342: WHERE mid.row_type = p_sub_po_unconsumed_row_type
2343: AND NVL(mid.get_rep_flag
2344: ,'N') <> CFR_SUB_PO_GET_REP_FLAG
2345: AND mid.shikyu_id = alloc.subcontract_po_shipment_id

Line 3759: ,wip_requirement_operations wro

3755: ,po_line_locations_all plla_s
3756: ,po_headers_all pha_s
3757: ,po_lines_all pla_s
3758: ,po_releases_all pra_s
3759: ,wip_requirement_operations wro
3760: ,MTL_SYSTEM_ITEMS_B_KFV msibk
3761: ,rcv_transactions rt
3762: --Added to get task start
3763: ,pa_tasks task

Line 4550: ,wip_requirement_operations wro

4546: ,wro.required_quantity
4547: ,wro.quantity_issued
4548: FROM JMF_SHIKYU_CFR_RPT_TEMP temp
4549: ,jmf_subcontract_orders jso
4550: ,wip_requirement_operations wro
4551: ,MTL_SYSTEM_ITEMS_B_KFV msibk
4552: WHERE temp.rpt_DATA_TYPE = CFR_CRUDE_DATA
4553: AND temp.subpo_shipment_id = jso.subcontract_po_shipment_id
4554: AND jso.oem_organization_id = msibk.organization_id