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 445: FROM po_line_locations_all

441: IF l_org_id is NULL
442: THEN
443: SELECT org_id
444: INTO l_org_id
445: FROM po_line_locations_all
446: WHERE line_location_id = p_replen_po_shipment_id;
447: END IF;
448:
449: IF g_log_enabled AND

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

450: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
451: THEN
452: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
453: , G_PKG_NAME
454: , '>> ' || l_program ||': Org ID selected from PO_LINE_LOCATIONS_ALL = '
455: || l_org_id
456: );
457: END IF;
458:

Line 655: FROM po_line_locations_all

651: lStmtNo := 90;
652:
653: SELECT NVL(need_by_date, promised_date)
654: INTO l_replen_po_need_by_date
655: FROM po_line_locations_all
656: WHERE line_location_id = p_replen_po_shipment_id;
657:
658: IF g_log_enabled AND
659: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

Line 776: FROM po_line_locations_all plla,

772: SELECT muomvl.uom_code,
773: plla.quantity
774: INTO l_price_list_uom,
775: l_quantity
776: FROM po_line_locations_all plla,
777: mtl_units_of_measure_vl muomvl
778: WHERE plla.line_location_id = p_replen_po_shipment_id
779: AND plla.unit_meas_lookup_code = muomvl.unit_of_measure;
780:

Line 971: (SELECT 1 FROM po_line_locations_all poll

967: SELECT segment1
968: INTO l_order_number
969: FROM po_headers_all poh
970: WHERE EXISTS
971: (SELECT 1 FROM po_line_locations_all poll
972: WHERE poll.line_location_id = p_subcontract_po_shipment_id
973: AND poll.po_header_id = poh.po_header_id);
974:
975: lStmtNo := 150;