APPS.JMF_SHIKYU_RPT_CFR_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 1023: ,po_line_locations_all pll

1019: ,pha.vendor_id --p_supplier_id
1020: ,pha.vendor_site_id --p_supplier_site_id
1021: --Added to fix bug 5509464 end
1022: FROM jmf_shikyu_cfr_mid_temp mid
1023: ,po_line_locations_all pll
1024: ,rcv_transactions rt
1025: --Added to fix bug 5509464 start
1026: ,po_headers_all pha
1027: --Added to fix bug 5509464 end

Line 1331: ,po_line_locations_all plla

1327: ,p_tp_inv_org_id
1328: ,p_item_id
1329: FROM po_headers_all pha
1330: ,po_lines_all pla
1331: ,po_line_locations_all plla
1332: ,MTL_UNITS_OF_MEASURE_TL uom_tl
1333: ,HR_ORGANIZATION_INFORMATION hoi -- Add this table to get information of oem
1334: WHERE pla.po_header_id = pha.po_header_id
1335: AND plla.po_line_id = pla.po_line_id

Line 1509: ,po_line_locations_all poloc

1505: -- if all parameters are valid then continue; otherwise raise an error message in log;
1506: SELECT cfr_mid.primary_unallocated_quantity
1507: INTO l_rep_po_unallocated_pri
1508: FROM jmf_shikyu_cfr_mid_temp cfr_mid
1509: ,po_line_locations_all poloc
1510: ,rcv_transactions rcv
1511: WHERE rcv.transaction_type = 'RECEIVE'
1512: AND poloc.line_location_id = rcv.po_line_location_id
1513: AND cfr_mid.shikyu_id = poloc.line_location_id

Line 2156: FROM po_line_locations_all pll

2152: ,ph.vendor_site_id
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

Line 3282: ,po_line_locations_all poloc

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
3286: ,po_vendors pv

Line 3299: ,po_line_locations_all plla_s

3295: ,jmf_shikyu_replenishments jsr
3296: ,oe_order_lines_all oola
3297: ,oe_order_headers_all ooha
3298: ,jmf_shikyu_allocations jsa
3299: ,po_line_locations_all plla_s
3300: ,po_headers_all pha_s
3301: ,po_lines_all pla_s
3302: ,po_releases_all pra_s
3303: ,cst_item_costs cic

Line 3755: ,po_line_locations_all plla_s

3751: ,jmf_shikyu_replenishments jsr
3752: ,jmf_shikyu_allocations jsa
3753: ,oe_order_lines_all oola
3754: ,oe_order_headers_all ooha
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

Line 3917: ,po_line_locations_all plla

3913: ,NVL(plla.need_by_date
3914: ,plla.promised_date) expected_rcv_date
3915: FROM oe_order_lines_all oola
3916: ,oe_order_headers_all ooha
3917: ,po_line_locations_all plla
3918: ,po_lines_all pla
3919: ,po_releases_all pra
3920: ,po_headers_all pha
3921: ,jmf_shikyu_replenishments jsr

Line 4089: ,po_line_locations_all plla

4085: ,NVL(plla.need_by_date
4086: ,plla.promised_date) expected_rcv_date
4087: FROM oe_order_lines_all oola
4088: ,oe_order_headers_all ooha
4089: ,po_line_locations_all plla
4090: ,po_lines_all pla
4091: ,po_releases_all pra
4092: ,po_headers_all pha
4093: ,jmf_shikyu_replenishments jsr