APPS.GMF_MEMO_INTERFACE dependencies on RA_CUST_TRX_TYPES_ALL

Line 33: t_trx_type1 ra_cust_trx_types_all.type%type;

29: t_trx_type OUT NOCOPY VARCHAR2,
30: error_status OUT NOCOPY NUMBER
31: ) IS
32: t_customer_trx_id1 ra_customer_trx_all.customer_trx_id%type;
33: t_trx_type1 ra_cust_trx_types_all.type%type;
34: t_interface_date DATE; /* Bug 2403594 */
35: BEGIN
36: error_status := 0;
37: IF t_init_flag <> 0

Line 55: ra_cust_trx_types_all rctt

51: (
52: SELECT
53: distinct rct.customer_trx_id,'N', NULL
54: FROM ra_customer_trx_all rct,
55: ra_cust_trx_types_all rctt
56: WHERE
57: rct.cust_trx_type_id = rctt.cust_trx_type_id
58: AND rctt.TYPE IN ('CM', 'DM')
59: AND UPPER(rct.complete_flag) = 'Y'

Line 83: ra_cust_trx_types_all rctt,

79: FROM (
80: SELECT rct.customer_trx_id,
81: rctt.type
82: FROM ra_customer_trx_all rct,
83: ra_cust_trx_types_all rctt,
84: gl_memo_sta ams
85: WHERE rct.customer_trx_id = ams.customer_trx_id
86: AND rct.customer_trx_id > last_trx_id
87: AND rct.cust_trx_type_id = rctt.cust_trx_type_id

Line 146: FROM ra_cust_trx_types_all rctt,

142: t_rctl_attribute15 IN VARCHAR2
143: ) IS
144: CURSOR tran_type_cur(t_customer_trx_id IN NUMBER) IS
145: SELECT NVL(rctt.attribute10, ' ')
146: FROM ra_cust_trx_types_all rctt,
147: ra_customer_trx_all rct
148: WHERE rct.customer_trx_id = t_customer_trx_id
149: AND rct.cust_trx_type_id = rctt.cust_trx_type_id;
150: t_rctt_attribute10 ra_cust_trx_types_all.attribute10%type;

Line 150: t_rctt_attribute10 ra_cust_trx_types_all.attribute10%type;

146: FROM ra_cust_trx_types_all rctt,
147: ra_customer_trx_all rct
148: WHERE rct.customer_trx_id = t_customer_trx_id
149: AND rct.cust_trx_type_id = rctt.cust_trx_type_id;
150: t_rctt_attribute10 ra_cust_trx_types_all.attribute10%type;
151:
152: CURSOR get_item_no(t_item_id in NUMBER) IS
153: SELECT msi.segment1
154: FROM mtl_system_items msi