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.PO_OTM_INTEGRATION_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 304: po_line_locations_all pll

300: ELSIF (p_doc_type = 'RELEASE' AND p_line_loc_id IS NOT NULL) THEN
301: SELECT pol.order_type_lookup_code
302: INTO l_line_value_basis
303: FROM po_lines_all pol,
304: po_line_locations_all pll
305: WHERE pll.line_location_id = p_line_loc_id
306: AND pll.po_line_id = pol.po_line_id;
307: END IF;
308: --Return and do not raise event if the action was on a non-quantity based line.

Line 2754: po_line_locations_all PLL,

2750: PLL.shipment_num,
2751: NVL(PLL.cancel_flag, 'N'),
2752: NVL(PLL.closed_code, 'OPEN')
2753: FROM po_lines_all POL,
2754: po_line_locations_all PLL,
2755: mtl_system_items MSI
2756: WHERE POL.po_header_id = p_doc_id
2757: AND PLL.po_line_id = POL.po_line_id
2758: AND POL.order_type_lookup_code = 'QUANTITY'

Line 2767: l_shipment_cancel_flag PO_LINE_LOCATIONS_ALL.cancel_flag%TYPE;

2763: l_inv_org_id NUMBER;
2764: l_header_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE;
2765: l_header_closed_code PO_HEADERS_ALL.closed_code%TYPE;
2766: l_header_user_hold_flag PO_HEADERS_ALL.user_hold_flag%TYPE;
2767: l_shipment_cancel_flag PO_LINE_LOCATIONS_ALL.cancel_flag%TYPE;
2768: l_shipment_closed_code PO_LINE_LOCATIONS_ALL.closed_code%TYPE;
2769:
2770: l_otm_schedule_line PO_OTM_SCHEDULE_LINE_TYPE;
2771:

Line 2768: l_shipment_closed_code PO_LINE_LOCATIONS_ALL.closed_code%TYPE;

2764: l_header_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE;
2765: l_header_closed_code PO_HEADERS_ALL.closed_code%TYPE;
2766: l_header_user_hold_flag PO_HEADERS_ALL.user_hold_flag%TYPE;
2767: l_shipment_cancel_flag PO_LINE_LOCATIONS_ALL.cancel_flag%TYPE;
2768: l_shipment_closed_code PO_LINE_LOCATIONS_ALL.closed_code%TYPE;
2769:
2770: l_otm_schedule_line PO_OTM_SCHEDULE_LINE_TYPE;
2771:
2772: l_count NUMBER := 0;

Line 2910: po_line_locations_all PLL,

2906: NVL(PLL.cancel_flag, 'N'),
2907: NVL(PLL.closed_code, 'OPEN')
2908: FROM po_releases_all POR,
2909: po_lines_all POL,
2910: po_line_locations_all PLL,
2911: mtl_system_items MSI
2912: WHERE POR.po_release_id = p_doc_id
2913: AND POL.po_header_id = POR.po_header_id
2914: AND PLL.po_release_id = POR.po_release_id

Line 2925: l_shipment_cancel_flag PO_LINE_LOCATIONS_ALL.cancel_flag%TYPE;

2921: l_inv_org_id NUMBER;
2922: l_header_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE;
2923: l_header_closed_code PO_HEADERS_ALL.closed_code%TYPE;
2924: l_header_user_hold_flag PO_HEADERS_ALL.user_hold_flag%TYPE;
2925: l_shipment_cancel_flag PO_LINE_LOCATIONS_ALL.cancel_flag%TYPE;
2926: l_shipment_closed_code PO_LINE_LOCATIONS_ALL.closed_code%TYPE;
2927:
2928: l_otm_schedule_line PO_OTM_SCHEDULE_LINE_TYPE;
2929:

Line 2926: l_shipment_closed_code PO_LINE_LOCATIONS_ALL.closed_code%TYPE;

2922: l_header_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE;
2923: l_header_closed_code PO_HEADERS_ALL.closed_code%TYPE;
2924: l_header_user_hold_flag PO_HEADERS_ALL.user_hold_flag%TYPE;
2925: l_shipment_cancel_flag PO_LINE_LOCATIONS_ALL.cancel_flag%TYPE;
2926: l_shipment_closed_code PO_LINE_LOCATIONS_ALL.closed_code%TYPE;
2927:
2928: l_otm_schedule_line PO_OTM_SCHEDULE_LINE_TYPE;
2929:
2930: l_count NUMBER := 0;