APPS.ARP_ETAX_UTIL dependencies on RA_CUST_TRX_TYPES

Line 564: l_ttype ra_cust_trx_types_all.type%type;

560: l_default_country VARCHAR2(50);
561: l_legal_entity_id NUMBER;
562: l_sync_trx_rec ZX_API_PUB.sync_trx_rec_type;
563: l_sync_trx_lines_t ZX_API_PUB.sync_trx_lines_tbl_type%type;
564: l_ttype ra_cust_trx_types_all.type%type;
565:
566: CURSOR c_req(p_request_id NUMBER) IS
567: SELECT
568: DECODE(TT.type, 'INV', 'INVOICE',

Line 589: RA_CUST_TRX_TYPES TT,

585: T.printing_original_date printing_original_date,
586: T.term_due_date term_due_date,
587: T.bill_to_site_use_id bill_to_site_use_id
588: FROM RA_CUSTOMER_TRX T,
589: RA_CUST_TRX_TYPES TT,
590: RA_BATCH_SOURCES TB,
591: FND_DOCUMENT_SEQUENCES SEQ
592: WHERE T.request_id = p_request_id
593: AND T.cust_trx_type_id = TT.cust_trx_type_id

Line 622: RA_CUST_TRX_TYPES TT,

618: T.printing_original_date printing_original_date,
619: T.term_due_date term_due_date,
620: TT.type type
621: FROM RA_CUSTOMER_TRX T,
622: RA_CUST_TRX_TYPES TT,
623: RA_BATCH_SOURCES TB,
624: FND_DOCUMENT_SEQUENCES SEQ
625: WHERE T.customer_trx_id = trx_id
626: AND T.cust_trx_type_id = TT.cust_trx_type_id

Line 656: RA_CUST_TRX_TYPES TT,

652: NULL asset_number
653: FROM
654: RA_CUSTOMER_TRX T,
655: RA_CUSTOMER_TRX_LINES TL,
656: RA_CUST_TRX_TYPES TT,
657: RA_CUST_TRX_LINE_GL_DIST REC
658: WHERE T.customer_trx_id = trx_id
659: AND T.cust_trx_type_id = TT.cust_trx_type_id
660: AND T.org_id = TT.org_id

Line 992: ra_cust_trx_types tt

988: 'DM', 'DEBIT_MEMO',
989: 'CM', 'CREDIT_MEMO') event_class,
990: tt.type event_prefix
991: FROM ra_customer_trx t,
992: ra_cust_trx_types tt
993: WHERE t.request_id = p_request_id
994: AND t.cust_trx_type_id = tt.cust_trx_type_id;
995:
996: BEGIN

Line 1023: ra_cust_trx_types tt

1019: INTO l_trx_rec.trx_id,
1020: l_trx_rec.event_class_code,
1021: l_trx_rec.event_type_code
1022: FROM ra_customer_trx t,
1023: ra_cust_trx_types tt
1024: WHERE t.customer_trx_id = p_customer_trx_id
1025: AND t.cust_trx_type_id = tt.cust_trx_type_id;
1026:
1027: zx_global_document_update(l_trx_rec);

Line 1256: l_trx_class RA_CUST_TRX_TYPES.TYPE%TYPE;

1252: p_event_class_code OUT NOCOPY VARCHAR2,
1253: p_event_type_code OUT NOCOPY VARCHAR2)
1254: RETURN BOOLEAN IS
1255:
1256: l_trx_class RA_CUST_TRX_TYPES.TYPE%TYPE;
1257: l_return_var BOOLEAN := TRUE;
1258:
1259: BEGIN
1260:

Line 1270: ra_cust_trx_types type

1266:
1267: Select type.type
1268: into l_trx_class
1269: from ra_customer_trx trx,
1270: ra_cust_trx_types type
1271: where trx.customer_trx_id = p_customer_trx_id
1272: and trx.cust_trx_type_id = type.cust_Trx_type_id;
1273:
1274:

Line 2184: RA_CUST_TRX_TYPES TT,

2180: SR_PER.organization_id poo_party_id,
2181: SR_HRL.location_id poo_location_id
2182: FROM
2183: RA_CUSTOMER_TRX TRX,
2184: RA_CUST_TRX_TYPES TT,
2185: RA_CUSTOMER_TRX_LINES LINES,
2186: AR_SYSTEM_PARAMETERS AR,
2187: FND_CURRENCIES CUR,
2188: HZ_CUST_ACCOUNTS BILL_CUST,

Line 3778: FROM ra_customer_trx trx, ra_cust_trx_types t

3774: AND entity_code = 'TRANSACTIONS'
3775: AND (trx_id, event_class_code) IN
3776: (SELECT trx.customer_trx_id, decode(t.type, 'INV', 'INVOICE',
3777: 'CM', 'CREDIT_MEMO', 'DM','DEBIT_MEMO')
3778: FROM ra_customer_trx trx, ra_cust_trx_types t
3779: WHERE trx.request_id = p_request_id
3780: AND trx.complete_flag = 'N'
3781: AND trx.cust_trx_type_id = t.cust_trx_type_id
3782: AND trx.org_id = t.org_id);