eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JMF_SHIKYU_ALLOCATION_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 169: --| promised_date from the PO_LINE_LOCATIONS_ALL |

165: --| condition was used to check for an empty table |
166: --| before. Should check to see if |
167: --| x_deleted_allocations_tbl.FIRST is NULL or not |
168: --| Also modified various queries to get the |
169: --| promised_date from the PO_LINE_LOCATIONS_ALL |
170: --| table if need_by_date is NULL. |
171: --| 25-MAY-2006 rajkrish Added the NOT EXISTS caluse in the |
172: --| INSERT into JMF table in partial_reconcile |
173: --| 13-JUN-2006 vchu Bug fix for 5291292: |

Line 524: (SELECT 1 FROM po_line_locations_all poll

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);
527:
528: SELECT segment1

Line 1271: po_line_locations_all plla,

1267: pla.line_num,
1268: plla.shipment_num
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

Line 1495: l_new_replen_po_shipment_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;

1491: l_primary_uom_price JMF_SHIKYU_COMPONENTS.primary_uom_price%TYPE;
1492: l_oem_organization_id JMF_SUBCONTRACT_ORDERS.oem_organization_id%TYPE;
1493: l_tp_organization_id JMF_SUBCONTRACT_ORDERS.tp_organization_id%TYPE;
1494: l_new_replen_so_line_id OE_ORDER_LINES_ALL.line_id%TYPE;
1495: l_new_replen_po_shipment_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
1496: l_new_replen_qty NUMBER;
1497:
1498: g_process_replen_po_exc EXCEPTION;
1499: g_process_replen_so_exc EXCEPTION;

Line 2363: (SELECT 1 FROM po_line_locations_all poll

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);
2366:
2367: SELECT segment1

Line 3338: , po_shipment_need_by_date PO_LINE_LOCATIONS_ALL.NEED_BY_DATE%TYPE

3334: , replenishment_so_line_id NUMBER
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: );

Line 3341: , po_shipment_num PO_LINE_LOCATIONS_ALL.SHIPMENT_NUM%TYPE

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:
3344: TYPE l_allocation_detail_tbl_type IS TABLE OF l_allocation_detail_rec_type INDEX BY BINARY_INTEGER;
3345:

Line 3380: PO_LINE_LOCATIONS_ALL plla,

3376: pha.segment1,
3377: pla.line_num,
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

Line 4562: l_replen_po_header_id PO_LINE_LOCATIONS_ALL.po_header_id%TYPE;

4558: l_org_id OE_ORDER_LINES_ALL.org_id%TYPE;
4559:
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:

Line 4563: l_replen_po_line_id PO_LINE_LOCATIONS_ALL.po_line_id%TYPE;

4559:
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;

Line 4591: FROM PO_LINE_LOCATIONS_ALL plla

4587: SELECT plla.po_header_id,
4588: plla.po_line_id
4589: INTO l_replen_po_header_id,
4590: l_replen_po_line_id
4591: FROM PO_LINE_LOCATIONS_ALL plla
4592: WHERE plla.line_location_id = p_replen_po_shipment_id;
4593:
4594: IF (g_fnd_debug = 'Y' AND
4595: FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE)