DBA Data[Home] [Help]

APPS.JL_ZZ_TAX_INTEGRATION_PKG dependencies on OE_ORDER_TYPES_V

Line 166: FROM OE_ORDER_TYPES_V ORD_TYPE,

162: SELECT INV_TYPE.CUST_TRX_TYPE_ID,
163: INV_TYPE.TAX_CALCULATION_FLAG
164: INTO l_cust_trx_type_id,
165: l_tax_calculation_flag
166: FROM OE_ORDER_TYPES_V ORD_TYPE,
167: OE_ORDER_HEADERS ORD_HEADER,
168: RA_CUST_TRX_TYPES INV_TYPE
169: WHERE ORD_TYPE.ORDER_TYPE_ID = ORD_HEADER.ORDER_TYPE_ID
170: AND ORD_HEADER.HEADER_ID = p_header_id

Line 182: FROM OE_ORDER_TYPES_V ORD_TYPE,

178: SELECT INV_TYPE.CUST_TRX_TYPE_ID,
179: INV_TYPE.TAX_CALCULATION_FLAG
180: INTO l_cust_trx_type_id,
181: l_tax_calculation_flag
182: FROM OE_ORDER_TYPES_V ORD_TYPE,
183: RA_CUST_TRX_TYPES INV_TYPE
184: WHERE ORD_TYPE.ORDER_TYPE_ID = p_line_type_id
185: AND ORD_TYPE.CUST_TRX_TYPE_ID = INV_TYPE.CUST_TRX_TYPE_ID;
186: