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 1273: po_headers_all pha,

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

Line 2233: l_order_number PO_HEADERS_ALL.SEGMENT1%TYPE;

2229: l_available_replen_tbl g_replen_so_qty_tbl_type;
2230: l_remaining_qty NUMBER;
2231: l_qty_allocated NUMBER;
2232: l_sub_comp MTL_SYSTEM_ITEMS_B.segment1%TYPE;
2233: l_order_number PO_HEADERS_ALL.SEGMENT1%TYPE;
2234: l_message VARCHAR(2000);
2235: l_status_flag BOOLEAN;
2236: l_tp_organization_id MTL_PARAMETERS.ORGANIZATION_ID%type;
2237:

Line 2361: FROM po_headers_all poh

2357: IF l_qty_allocated = 0 THEN
2358: BEGIN
2359: SELECT segment1
2360: INTO l_order_number
2361: FROM po_headers_all poh
2362: WHERE EXISTS
2363: (SELECT 1 FROM po_line_locations_all poll
2364: WHERE poll.line_location_id = p_subcontract_po_shipment_id
2365: AND poll.po_header_id = poh.po_header_id);

Line 3339: , po_header_num PO_HEADERS_ALL.SEGMENT1%TYPE

3335: , component_id NUMBER
3336: , qty NUMBER
3337: , qty_uom VARCHAR2(3)
3338: , po_shipment_need_by_date PO_LINE_LOCATIONS_ALL.NEED_BY_DATE%TYPE
3339: , po_header_num PO_HEADERS_ALL.SEGMENT1%TYPE
3340: , po_line_num PO_LINES_ALL.LINE_NUM%TYPE
3341: , po_shipment_num PO_LINE_LOCATIONS_ALL.SHIPMENT_NUM%TYPE
3342: );
3343:

Line 3382: PO_HEADERS_ALL pha

3378: plla.shipment_num
3379: FROM JMF_SHIKYU_ALLOCATIONS jsa,
3380: PO_LINE_LOCATIONS_ALL plla,
3381: PO_LINES_ALL pla,
3382: PO_HEADERS_ALL pha
3383: WHERE jsa.replenishment_so_line_id = p_replen_order_line_id
3384: AND jsa.shikyu_component_id = l_component_id
3385: AND jsa.subcontract_po_shipment_id = plla.line_location_id
3386: AND plla.po_line_id = pla.po_line_id

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

4560: -- Information from Replenishment PO Shipment
4561:
4562: l_replen_po_header_id PO_LINE_LOCATIONS_ALL.po_header_id%TYPE;
4563: l_replen_po_line_id PO_LINE_LOCATIONS_ALL.po_line_id%TYPE;
4564: --l_supplier_id PO_HEADERS_ALL.vendor_id%TYPE;
4565: --l_supplier_site_id PO_HEADERS_ALL.vendor_site_id%TYPE;
4566:
4567: l_tp_supplier_id JMF_SHIKYU_REPLENISHMENTS.tp_supplier_id%TYPE;
4568: l_tp_supplier_site_id JMF_SHIKYU_REPLENISHMENTS.tp_supplier_site_id%TYPE;

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

4561:
4562: l_replen_po_header_id PO_LINE_LOCATIONS_ALL.po_header_id%TYPE;
4563: l_replen_po_line_id PO_LINE_LOCATIONS_ALL.po_line_id%TYPE;
4564: --l_supplier_id PO_HEADERS_ALL.vendor_id%TYPE;
4565: --l_supplier_site_id PO_HEADERS_ALL.vendor_site_id%TYPE;
4566:
4567: l_tp_supplier_id JMF_SHIKYU_REPLENISHMENTS.tp_supplier_id%TYPE;
4568: l_tp_supplier_site_id JMF_SHIKYU_REPLENISHMENTS.tp_supplier_site_id%TYPE;
4569: