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 3762: ,wip_requirement_operations wro

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

Line 4553: ,wip_requirement_operations wro

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