APPS.JMF_SHIKYU_ALLOCATION_PVT dependencies on PO_HEADERS_ALL

Line 370: l_order_number PO_HEADERS_ALL.SEGMENT1%TYPE;

366: l_allocated_uom JMF_SHIKYU_ALLOCATIONS.uom%TYPE;
367: l_allocation_qty JMF_SHIKYU_ALLOCATIONS.allocated_quantity%TYPE;
368: l_replen_so_header_id OE_ORDER_LINES_ALL.header_id%TYPE := NULL;
369: l_sub_comp MTL_SYSTEM_ITEMS_B.segment1%TYPE;
370: l_order_number PO_HEADERS_ALL.SEGMENT1%TYPE;
371: l_message VARCHAR(2000);
372: l_status_flag BOOLEAN;
373:
374:

Line 522: FROM po_headers_all poh

518: IF x_qty_allocated = 0 THEN
519: BEGIN
520: SELECT segment1
521: INTO l_order_number
522: FROM po_headers_all poh
523: WHERE EXISTS
524: (SELECT 1 FROM po_line_locations_all poll
525: WHERE poll.line_location_id = p_subcontract_po_shipment_id
526: AND poll.po_header_id = poh.po_header_id);

Line 1277: po_headers_all pha,

1273: FROM jmf_subcontract_orders jso,
1274: hr_organization_information hoi,
1275: po_line_locations_all plla,
1276: po_lines_all pla,
1277: po_headers_all pha,
1278: mtl_units_of_measure_vl muomv
1279: WHERE jso.subcontract_po_shipment_id = p_subcontract_po_shipment_id
1280: AND hoi.organization_id = jso.oem_organization_id
1281: AND hoi.org_information_context = 'Customer/Supplier Association'

Line 2239: l_order_number PO_HEADERS_ALL.SEGMENT1%TYPE;

2235: l_available_replen_tbl g_replen_so_qty_tbl_type;
2236: l_remaining_qty NUMBER;
2237: l_qty_allocated NUMBER;
2238: l_sub_comp MTL_SYSTEM_ITEMS_B.segment1%TYPE;
2239: l_order_number PO_HEADERS_ALL.SEGMENT1%TYPE;
2240: l_message VARCHAR(2000);
2241: l_status_flag BOOLEAN;
2242: l_tp_organization_id MTL_PARAMETERS.ORGANIZATION_ID%type;
2243:

Line 2367: FROM po_headers_all poh

2363: IF l_qty_allocated = 0 THEN
2364: BEGIN
2365: SELECT segment1
2366: INTO l_order_number
2367: FROM po_headers_all poh
2368: WHERE EXISTS
2369: (SELECT 1 FROM po_line_locations_all poll
2370: WHERE poll.line_location_id = p_subcontract_po_shipment_id
2371: AND poll.po_header_id = poh.po_header_id);

Line 3493: , po_header_num PO_HEADERS_ALL.SEGMENT1%TYPE

3489: , component_id NUMBER
3490: , qty NUMBER
3491: , qty_uom VARCHAR2(3)
3492: , po_shipment_need_by_date PO_LINE_LOCATIONS_ALL.NEED_BY_DATE%TYPE
3493: , po_header_num PO_HEADERS_ALL.SEGMENT1%TYPE
3494: , po_line_num PO_LINES_ALL.LINE_NUM%TYPE
3495: , po_shipment_num PO_LINE_LOCATIONS_ALL.SHIPMENT_NUM%TYPE
3496: );
3497:

Line 3536: PO_HEADERS_ALL pha

3532: plla.shipment_num
3533: FROM JMF_SHIKYU_ALLOCATIONS jsa,
3534: PO_LINE_LOCATIONS_ALL plla,
3535: PO_LINES_ALL pla,
3536: PO_HEADERS_ALL pha
3537: WHERE jsa.replenishment_so_line_id = p_replen_order_line_id
3538: AND jsa.shikyu_component_id = l_component_id
3539: AND jsa.subcontract_po_shipment_id = plla.line_location_id
3540: AND plla.po_line_id = pla.po_line_id

Line 5008: --l_supplier_id PO_HEADERS_ALL.vendor_id%TYPE;

5004: -- Information from Replenishment PO Shipment
5005:
5006: l_replen_po_header_id PO_LINE_LOCATIONS_ALL.po_header_id%TYPE;
5007: l_replen_po_line_id PO_LINE_LOCATIONS_ALL.po_line_id%TYPE;
5008: --l_supplier_id PO_HEADERS_ALL.vendor_id%TYPE;
5009: --l_supplier_site_id PO_HEADERS_ALL.vendor_site_id%TYPE;
5010:
5011: l_tp_supplier_id JMF_SHIKYU_REPLENISHMENTS.tp_supplier_id%TYPE;
5012: l_tp_supplier_site_id JMF_SHIKYU_REPLENISHMENTS.tp_supplier_site_id%TYPE;

Line 5009: --l_supplier_site_id PO_HEADERS_ALL.vendor_site_id%TYPE;

5005:
5006: l_replen_po_header_id PO_LINE_LOCATIONS_ALL.po_header_id%TYPE;
5007: l_replen_po_line_id PO_LINE_LOCATIONS_ALL.po_line_id%TYPE;
5008: --l_supplier_id PO_HEADERS_ALL.vendor_id%TYPE;
5009: --l_supplier_site_id PO_HEADERS_ALL.vendor_site_id%TYPE;
5010:
5011: l_tp_supplier_id JMF_SHIKYU_REPLENISHMENTS.tp_supplier_id%TYPE;
5012: l_tp_supplier_site_id JMF_SHIKYU_REPLENISHMENTS.tp_supplier_site_id%TYPE;
5013: