DBA Data[Home] [Help]

APPS.OE_BULK_TAX_UTIL dependencies on RA_CUST_TRX_TYPES_ALL

Line 462: l_cust_trx_type_id ra_cust_trx_types_all.cust_Trx_type_id%type;

458: l_currency_code VARCHAR2(30);
459: l_inventory_org_id NUMBER;
460: l_header_org_id NUMBER;
461: l_conversion_rate NUMBER;
462: l_cust_trx_type_id ra_cust_trx_types_all.cust_Trx_type_id%type;
463: l_legal_entity_id NUMBER(15);
464: l_ship_party_id NUMBER(15);
465: l_ship_party_site_id NUMBER(15);
466: l_ship_location_id NUMBER(15);

Line 708: from ra_cust_trx_types_all cust_type,

704: begin
705:
706: select /* MOAC_SQL_CHANGE */ nvl(cust_type.subsequent_trx_type_id, cust_type.cust_trx_type_id)
707: into l_cust_trx_type_id
708: from ra_cust_trx_types_all cust_type,
709: ra_customer_trx cust_trx
710: where
711: cust_type.cust_trx_type_id = cust_trx.cust_trx_type_id
712: and cust_type.org_id = cust_trx.org_id