DBA Data[Home] [Help]

APPS.JA_JAINDTBR_XMLP_PKG dependencies on GL_CODE_COMBINATIONS

Line 127: GL_CODE_COMBINATIONS E

123: FROM
124: AR_ADJUSTMENTS_ALL B,
125: RA_CUSTOMER_TRX_ALL C,
126: AR_PAYMENT_SCHEDULES_ALL D,
127: GL_CODE_COMBINATIONS E
128: WHERE B.CUSTOMER_TRX_ID = C.CUSTOMER_TRX_ID
129: AND C.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
130: AND B.GL_DATE <= TRUNC(P_START_DATE)
131: AND E.CODE_COMBINATION_ID = B.CODE_COMBINATION_ID

Line 423: gl_code_combinations e

419: sum(b.amount * NVL(c.exchange_rate,1.00)) sum_amount_exchange
420: FROM ar_adjustments_all b,
421: ra_customer_trx_all c,
422: ar_payment_schedules_all d,
423: gl_code_combinations e
424: WHERE
425: b.customer_trx_id = c.customer_trx_id
426: and c.bill_to_customer_id = P_CUSTOMER_ID
427: and b.gl_date <= trunc( p_start_date)