APPS.JMF_SHIKYU_ONT_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 100: --| promised_date from PO_LINE_LOCATIONS_ALL |

96: --| c_project_cur cursor to get Project ID and |
97: --| Task ID from the Replenishment PO instead |
98: --| of the Subcontracting PO. |
99: --| 05/11/2006 vchu Modified various queries to get the |
100: --| promised_date from PO_LINE_LOCATIONS_ALL |
101: --| if need_by_date is NULL. |
102: --| 08/24/2006 vchu Fixed bug 5485115: Remove the dependency on |
103: --| OE_PRICE_LIST_LINES in by querying the base |
104: --| table QP_LIST_LINES to get the unit_code |

Line 197: po_line_locations_all plla

193: l_need_by_date
194: , l_osa_item_id
195: FROM
196: jmf_subcontract_orders jso,
197: po_line_locations_all plla
198: WHERE subcontract_po_shipment_id = p_subcontract_po_shipment_id
199: AND plla.line_location_id = jso.subcontract_po_shipment_id;
200:
201: JMF_SHIKYU_WIP_PVT.Compute_Start_Date

Line 433: FROM po_line_locations_all

429: IF l_org_id is NULL
430: THEN
431: SELECT org_id
432: INTO l_org_id
433: FROM po_line_locations_all
434: WHERE line_location_id = p_replen_po_shipment_id;
435: END IF;
436:
437: IF g_log_enabled AND

Line 442: , '>> ' || l_program ||': Org ID selected from PO_LINE_LOCATIONS_ALL = '

438: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
439: THEN
440: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
441: , G_PKG_NAME
442: , '>> ' || l_program ||': Org ID selected from PO_LINE_LOCATIONS_ALL = '
443: || l_org_id
444: );
445: END IF;
446:

Line 619: FROM po_line_locations_all

615: IF p_replen_po_shipment_id IS NOT NULL
616: THEN
617: SELECT NVL(need_by_date, promised_date)
618: INTO l_replen_po_need_by_date
619: FROM po_line_locations_all
620: WHERE line_location_id = p_replen_po_shipment_id;
621:
622: IF g_log_enabled AND
623: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

Line 734: FROM po_line_locations_all plla,

730: SELECT muomvl.uom_code,
731: plla.quantity
732: INTO l_price_list_uom,
733: l_quantity
734: FROM po_line_locations_all plla,
735: mtl_units_of_measure_vl muomvl
736: WHERE plla.line_location_id = p_replen_po_shipment_id
737: AND plla.unit_meas_lookup_code = muomvl.unit_of_measure;
738:

Line 829: (SELECT 1 FROM po_line_locations_all poll

825: SELECT segment1
826: INTO l_order_number
827: FROM po_headers_all poh
828: WHERE EXISTS
829: (SELECT 1 FROM po_line_locations_all poll
830: WHERE poll.line_location_id = p_subcontract_po_shipment_id
831: AND poll.po_header_id = poh.po_header_id);
832:
833: SELECT segment1