DBA Data[Home] [Help]

APPS.JL_ZZ_TAX_INTEGRATION_PKG dependencies on OE_ORDER_TYPES_V

Line 167: FROM OE_ORDER_TYPES_V ORD_TYPE,

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

Line 183: FROM OE_ORDER_TYPES_V ORD_TYPE,

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