DBA Data[Home] [Help]

APPS.PO_OTM_INTEGRATION_PVT dependencies on PO_LINES_ALL

Line 249: l_line_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE; --

245: l_org_name HR_ALL_ORGANIZATION_UNITS.name%TYPE;
246: l_po_number PO_HEADERS_ALL.segment1%TYPE;
247: l_release_number PO_RELEASES_ALL.release_num%TYPE;
248: l_shipping_control PO_HEADERS_ALL.shipping_control%TYPE;
249: l_line_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE; --
250: l_approved_date PO_HEADERS_ALL.approved_date%TYPE; --7449918
251:
252: l_return_status VARCHAR2(1);
253:

Line 297: FROM po_lines_all pol

293: --level for the PO then we will still get the p_line_id.
294: IF (p_doc_type = 'PO' AND p_line_id IS NOT NULL) THEN
295: SELECT pol.order_type_lookup_code
296: INTO l_line_value_basis
297: FROM po_lines_all pol
298: WHERE pol.po_line_id = p_line_id;
299: --If the action is at the shipment level for a release we will not get the p_line_id
300: ELSIF (p_doc_type = 'RELEASE' AND p_line_loc_id IS NOT NULL) THEN
301: SELECT pol.order_type_lookup_code

Line 303: FROM po_lines_all pol,

299: --If the action is at the shipment level for a release we will not get the p_line_id
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;

Line 2753: FROM po_lines_all POL,

2749: POL.line_num,
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

Line 2909: po_lines_all POL,

2905: PLL.shipment_num,
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