DBA Data[Home] [Help]

APPS.JAI_AR_TCS_REP_PKG dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 745: p_ractl IN RA_CUSTOMER_TRX_LINES_ALL%ROWTYPE DEFAULT NULL ,

741:
742: /*Bug 12543504 - End*/
743:
744: PROCEDURE ar_accounting ( p_ract IN RA_CUSTOMER_TRX_ALL%ROWTYPE DEFAULT NULL ,
745: p_ractl IN RA_CUSTOMER_TRX_LINES_ALL%ROWTYPE DEFAULT NULL ,
746: p_process_flag OUT NOCOPY VARCHAR2 ,
747: p_process_message OUT NOCOPY VARCHAR2
748: )
749:

Line 753: cp_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE DEFAULT NULL

749:
750: IS
751: ln_reg_id NUMBER;
752: CURSOR cur_get_inv_det ( cp_customer_trx_id RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE ,
753: cp_customer_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE DEFAULT NULL
754: )
755: IS
756: SELECT
757: jrcttl.* ,

Line 1359: ra_customer_trx_lines_all rctla --Added by JMEENA to filter discount line. for bug#8241099

1355: SELECT
1356: 1
1357: FROM
1358: JAI_AR_TRX_LINES jrctl,
1359: ra_customer_trx_lines_all rctla --Added by JMEENA to filter discount line. for bug#8241099
1360: WHERE
1361: jrctl.customer_trx_id = cp_customer_trx_id
1362: AND jrctl.customer_trx_id = rctla.customer_trx_id
1363: AND jrctl.customer_trx_line_id = rctla.customer_trx_line_id

Line 1787: FROM ra_customer_trx_lines_all

1783: -------------------------------------------------------------------
1784:
1785: SELECT COUNT(CUSTOMER_TRX_ID)
1786: INTO ln_open_interface
1787: FROM ra_customer_trx_lines_all
1788: WHERE CUSTOMER_TRX_ID = p_ract.customer_trx_id
1789: AND global_attribute_category like '%OFI TAX IMPORT%';
1790:
1791: if( nvl(ln_open_interface,0) > 0 )then

Line 2592: ra_customer_trx_lines_all rctla

2588: rctla.extended_amount line_amount ,
2589: rctla.inventory_item_id
2590: FROM
2591: JAI_AR_TRXS jrct ,
2592: ra_customer_trx_lines_all rctla
2593: WHERE
2594: jrct.customer_trx_id = rctla.customer_trx_id
2595: AND jrct.customer_trx_id = p_ract.customer_trx_id
2596: AND rctla.customer_trx_id = rctla.customer_trx_id

Line 4348: Solution -In Table RA_CUSTOMER_TRX_LINES_ALL , Org_id column was null

4344:
4345: Problem - In Auto Invoice master program , Transaction number created for TCS Type of receipt method was
4346: not coming
4347:
4348: Solution -In Table RA_CUSTOMER_TRX_LINES_ALL , Org_id column was null
4349: 4. 10-Sep-2007 CSahoo for bug#6401388, File Version120.4.12000000.7
4350: commented the code related to jai_cmn_debug_context_pkg package.
4351: removed all the debug messages meant for debugging.
4352: