APPS.ARP_ETAX_UTIL dependencies on RA_CUST_TRX_TYPES

Line 563: RA_CUST_TRX_TYPES TT,

559: T.printing_original_date printing_original_date,
560: T.term_due_date term_due_date,
561: T.bill_to_site_use_id bill_to_site_use_id
562: FROM RA_CUSTOMER_TRX T,
563: RA_CUST_TRX_TYPES TT,
564: RA_BATCH_SOURCES TB,
565: FND_DOCUMENT_SEQUENCES SEQ
566: WHERE T.request_id = p_request_id
567: AND T.cust_trx_type_id = TT.cust_trx_type_id

Line 595: RA_CUST_TRX_TYPES TT,

591: TT.description trx_type_description,
592: T.printing_original_date printing_original_date,
593: T.term_due_date term_due_date
594: FROM RA_CUSTOMER_TRX T,
595: RA_CUST_TRX_TYPES TT,
596: RA_BATCH_SOURCES TB,
597: FND_DOCUMENT_SEQUENCES SEQ
598: WHERE T.customer_trx_id = trx_id
599: AND T.cust_trx_type_id = TT.cust_trx_type_id

Line 629: RA_CUST_TRX_TYPES TT,

625: NULL asset_number
626: FROM
627: RA_CUSTOMER_TRX T,
628: RA_CUSTOMER_TRX_LINES TL,
629: RA_CUST_TRX_TYPES TT,
630: RA_CUST_TRX_LINE_GL_DIST REC
631: WHERE T.customer_trx_id = trx_id
632: AND T.cust_trx_type_id = TT.cust_trx_type_id
633: AND T.org_id = TT.org_id

Line 951: ra_cust_trx_types tt

947: 'DM', 'DEBIT_MEMO',
948: 'CM', 'CREDIT_MEMO') event_class,
949: tt.type event_prefix
950: FROM ra_customer_trx t,
951: ra_cust_trx_types tt
952: WHERE t.request_id = p_request_id
953: AND t.cust_trx_type_id = tt.cust_trx_type_id;
954:
955: BEGIN

Line 982: ra_cust_trx_types tt

978: INTO l_trx_rec.trx_id,
979: l_trx_rec.event_class_code,
980: l_trx_rec.event_type_code
981: FROM ra_customer_trx t,
982: ra_cust_trx_types tt
983: WHERE t.customer_trx_id = p_customer_trx_id
984: AND t.cust_trx_type_id = tt.cust_trx_type_id;
985:
986: zx_global_document_update(l_trx_rec);

Line 1165: ra_cust_trx_types tt,

1161: tl.customer_trx_line_id,
1162: nvl(tl.tax_classification_code, zx.output_tax_classification_code)
1163: from ra_customer_trx t,
1164: ra_customer_trx_lines tl,
1165: ra_cust_trx_types tt,
1166: zx_lines_det_factors zx
1167: where t.request_id = p_request_id
1168: and t.cust_trx_type_id = tt.cust_trx_type_id
1169: and t.org_id = tt.org_id

Line 1217: l_trx_class RA_CUST_TRX_TYPES.TYPE%TYPE;

1213: p_event_class_code OUT NOCOPY VARCHAR2,
1214: p_event_type_code OUT NOCOPY VARCHAR2)
1215: RETURN BOOLEAN IS
1216:
1217: l_trx_class RA_CUST_TRX_TYPES.TYPE%TYPE;
1218: l_return_var BOOLEAN := TRUE;
1219:
1220: BEGIN
1221: arp_standard.debug('arp_etax_util.get_event_information()+)');

Line 1226: ra_cust_trx_types type

1222:
1223: Select type.type
1224: into l_trx_class
1225: from ra_customer_trx trx,
1226: ra_cust_trx_types type
1227: where trx.customer_trx_id = p_customer_trx_id
1228: and trx.cust_trx_type_id = type.cust_Trx_type_id;
1229:
1230: IF (l_trx_class = 'INV') THEN

Line 2115: RA_CUST_TRX_TYPES TT,

2111: SR_PER.organization_id poo_party_id,
2112: SR_HRL.location_id poo_location_id
2113: FROM
2114: RA_CUSTOMER_TRX TRX,
2115: RA_CUST_TRX_TYPES TT,
2116: RA_CUSTOMER_TRX_LINES LINES,
2117: AR_SYSTEM_PARAMETERS AR,
2118: FND_CURRENCIES CUR,
2119: HZ_CUST_ACCOUNTS BILL_CUST,

Line 3716: FROM ra_customer_trx trx, ra_cust_trx_types t

3712: AND entity_code = 'TRANSACTIONS'
3713: AND (trx_id, event_class_code) IN
3714: (SELECT trx.customer_trx_id, decode(t.type, 'INV', 'INVOICE',
3715: 'CM', 'CREDIT_MEMO', 'DM','DEBIT_MEMO')
3716: FROM ra_customer_trx trx, ra_cust_trx_types t
3717: WHERE trx.request_id = p_request_id
3718: AND trx.complete_flag = 'N'
3719: AND trx.cust_trx_type_id = t.cust_trx_type_id
3720: AND trx.org_id = t.org_id);