DBA Data[Home] [Help]

APPS.OM_TAX_UTIL dependencies on RA_CUST_TRX_TYPES_ALL

Line 194: l_cust_trx_type_id ra_cust_trx_types_all.cust_Trx_type_id%type;

190: l_precision fnd_currencies.precision%type;
191: Is_fmt BOOLEAN; --8431420
192: l_AR_Sys_Param_Rec ar_system_parameters_all%ROWTYPE;
193: l_commitment_id oe_order_lines.commitment_id%type;
194: l_cust_trx_type_id ra_cust_trx_types_all.cust_Trx_type_id%type;
195: l_ship_to_org_id oe_order_lines.ship_to_org_id%type;
196: l_invoice_to_org_id oe_order_lines.invoice_to_org_id%type;
197: l_ship_to_site_use_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type;
198: l_ship_to_address_id NUMBER ;

Line 309: FROM ra_cust_trx_types_all cust_type,

305: SELECT
306: /* MOAC_SQL_CHANGE */
307: NVL(cust_type.subsequent_trx_type_id, cust_type.cust_trx_type_id)
308: INTO l_cust_trx_type_id
309: FROM ra_cust_trx_types_all cust_type,
310: ra_customer_trx cust_trx
311: WHERE cust_type.cust_trx_type_id = cust_trx.cust_trx_type_id
312: AND cust_type.org_id = cust_trx.org_id
313: AND cust_trx.customer_trx_id = l_commitment_id;