APPS.JMF_SHIKYU_RPT_CFR_PVT dependencies on JMF_SUBCONTRACT_ORDERS

Line 2157: ,jmf_subcontract_orders sub_po

2153: ,sub_po.oem_organization_id
2154: ,sub_po.tp_organization_id
2155: ,comp.shikyu_component_id
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

Line 2340: ,jmf_subcontract_orders jso

2336: ,alloc.shikyu_component_id
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

Line 3281: ,jmf_subcontract_orders sub

3277: ,pra_s.release_num SubPO_release_Num
3278: ,plla_s.line_location_id SubPO_shipment_id
3279: ,plla_s.shipment_num SubPO_shipment_num
3280: FROM jmf_shikyu_cfr_mid_temp cfr_mid
3281: ,jmf_subcontract_orders sub
3282: ,po_line_locations_all poloc
3283: ,rcv_transactions rcv
3284: ,mtl_parameters mp_oem
3285: ,mtl_parameters mp_tp

Line 3740: FROM jmf_subcontract_orders jso

3736: ,msibk.concatenated_segments
3737: ,msibk.description
3738: ,wro.required_quantity
3739: ,wro.quantity_issued
3740: FROM jmf_subcontract_orders jso
3741: ,jmf_shikyu_components jsc
3742: ,(select DISTINCT cfr_mid_temp.oem_inv_org_id oem_inv_org_id
3743: ,cfr_mid_temp.supplier_id supplier_id
3744: ,cfr_mid_temp.site_id site_id

Line 4549: ,jmf_subcontract_orders jso

4545: ,msibk.description
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