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 1275: po_line_locations_all plla,

1271: pla.line_num,
1272: plla.shipment_num
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

Line 1501: l_new_replen_po_shipment_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;

1497: l_primary_uom_price JMF_SHIKYU_COMPONENTS.primary_uom_price%TYPE;
1498: l_oem_organization_id JMF_SUBCONTRACT_ORDERS.oem_organization_id%TYPE;
1499: l_tp_organization_id JMF_SUBCONTRACT_ORDERS.tp_organization_id%TYPE;
1500: l_new_replen_so_line_id OE_ORDER_LINES_ALL.line_id%TYPE;
1501: l_new_replen_po_shipment_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
1502: l_new_replen_qty NUMBER;
1503:
1504: g_process_replen_po_exc EXCEPTION;
1505: g_process_replen_so_exc EXCEPTION;

Line 2369: (SELECT 1 FROM po_line_locations_all poll

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);
2372:
2373: SELECT segment1

Line 3492: , po_shipment_need_by_date PO_LINE_LOCATIONS_ALL.NEED_BY_DATE%TYPE

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

Line 3495: , po_shipment_num PO_LINE_LOCATIONS_ALL.SHIPMENT_NUM%TYPE

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

Line 3534: PO_LINE_LOCATIONS_ALL plla,

3530: pha.segment1,
3531: pla.line_num,
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

Line 5006: l_replen_po_header_id PO_LINE_LOCATIONS_ALL.po_header_id%TYPE;

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

Line 5007: l_replen_po_line_id PO_LINE_LOCATIONS_ALL.po_line_id%TYPE;

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

Line 5035: FROM PO_LINE_LOCATIONS_ALL plla

5031: SELECT plla.po_header_id,
5032: plla.po_line_id
5033: INTO l_replen_po_header_id,
5034: l_replen_po_line_id
5035: FROM PO_LINE_LOCATIONS_ALL plla
5036: WHERE plla.line_location_id = p_replen_po_shipment_id;
5037:
5038: IF (g_fnd_debug = 'Y' AND
5039: FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE)