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 3758: ,po_line_locations_all plla_s

3754: ,jmf_shikyu_replenishments jsr
3755: ,jmf_shikyu_allocations jsa
3756: ,oe_order_lines_all oola
3757: ,oe_order_headers_all ooha
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

Line 3920: ,po_line_locations_all plla

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

Line 4092: ,po_line_locations_all plla

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