DBA Data[Home] [Help]

APPS.PO_AUTO_DIST_PROCESS_PVT dependencies on PO_HEADERS_ALL

Line 48: l_currency_conversion_rate PO_HEADERS_ALL.rate%TYPE := 1;

44: x_po_uom VARCHAR2(25):=NULL;
45: x_conversion_rate NUMBER := 1;
46: x_gl_date_option VARCHAR2(25);
47: l_uom_conversion_rate MTL_UOM_CONVERSIONS.conversion_rate%TYPE := 1;
48: l_currency_conversion_rate PO_HEADERS_ALL.rate%TYPE := 1;
49: l_drop_ship_flag po_line_locations.drop_ship_flag%type;
50: l_from_type_lookup_code po_headers_all.TYPE_LOOKUP_CODE%type;
51: l_amount_ordered NUMBER;
52: l_rownum NUMBER;

Line 50: l_from_type_lookup_code po_headers_all.TYPE_LOOKUP_CODE%type;

46: x_gl_date_option VARCHAR2(25);
47: l_uom_conversion_rate MTL_UOM_CONVERSIONS.conversion_rate%TYPE := 1;
48: l_currency_conversion_rate PO_HEADERS_ALL.rate%TYPE := 1;
49: l_drop_ship_flag po_line_locations.drop_ship_flag%type;
50: l_from_type_lookup_code po_headers_all.TYPE_LOOKUP_CODE%type;
51: l_amount_ordered NUMBER;
52: l_rownum NUMBER;
53: l_charge_account_id NUMBER;
54: l_accrual_account_id NUMBER;

Line 287: FROM po_headers_all poh

283: BEGIN
284: --need to check ant interface.from_line_id and intreface.from_header_id
285: SELECT poh.type_lookup_code
286: INTO l_from_type_lookup_code
287: FROM po_headers_all poh
288: WHERE poh.po_header_id=p_lines.from_header_id_tbl(i) ;
289:
290: EXCEPTION
291: WHEN OTHERS THEN