eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CE_AUTO_BANK_MATCH dependencies on AR_RECEIVABLES_TRX

Line 701: -- bug 5722367 removed the reference to ar_receivables_trx_all table to ar_receivables_trx

697: CE_AUTO_BANK_REC.G_receivables_trx_id);
698:
699: cep_standard.debug( 'x_receivables_trx_id= '|| x_receivables_trx_id);
700:
701: -- bug 5722367 removed the reference to ar_receivables_trx_all table to ar_receivables_trx
702: if (x_receivables_trx_id is not null) THEN
703:
704: -- Bug 16568960 Introduced EXCEPTION block to handle NO_DATA_FOUND
705: begin

Line 708: from AR_RECEIVABLES_TRX

704: -- Bug 16568960 Introduced EXCEPTION block to handle NO_DATA_FOUND
705: begin
706: select org_id
707: into X_ORG_ID
708: from AR_RECEIVABLES_TRX
709: where RECEIVABLES_TRX_ID = x_receivables_trx_id;
710: exception
711: when no_data_found then
712: cep_standard.debug( 'NO_DATA_FOUND in AR_RECEIVABLES_TRX, picking up org_id from AR_RECEIVABLES_TRX_ALL..');

Line 712: cep_standard.debug( 'NO_DATA_FOUND in AR_RECEIVABLES_TRX, picking up org_id from AR_RECEIVABLES_TRX_ALL..');

708: from AR_RECEIVABLES_TRX
709: where RECEIVABLES_TRX_ID = x_receivables_trx_id;
710: exception
711: when no_data_found then
712: cep_standard.debug( 'NO_DATA_FOUND in AR_RECEIVABLES_TRX, picking up org_id from AR_RECEIVABLES_TRX_ALL..');
713: select org_id
714: into X_ORG_ID
715: from AR_RECEIVABLES_TRX_ALL
716: where RECEIVABLES_TRX_ID = x_receivables_trx_id;

Line 715: from AR_RECEIVABLES_TRX_ALL

711: when no_data_found then
712: cep_standard.debug( 'NO_DATA_FOUND in AR_RECEIVABLES_TRX, picking up org_id from AR_RECEIVABLES_TRX_ALL..');
713: select org_id
714: into X_ORG_ID
715: from AR_RECEIVABLES_TRX_ALL
716: where RECEIVABLES_TRX_ID = x_receivables_trx_id;
717: end;
718: -- Bug 16568960 End.
719:

Line 7466: y_dr_vat_tax_code AR_RECEIVABLES_TRX.liability_tax_code%type;

7462: l_vat_tax_id OUT NOCOPY NUMBER,
7463: X_tax_rate OUT NOCOPY NUMBER) IS
7464:
7465: -- l_vat_tax_id NUMBER;
7466: y_dr_vat_tax_code AR_RECEIVABLES_TRX.liability_tax_code%type;
7467: y_cr_vat_tax_code AR_RECEIVABLES_TRX.asset_tax_code%type;
7468:
7469: -- bug 5733971
7470: l_return_status VARCHAR2(50);

Line 7467: y_cr_vat_tax_code AR_RECEIVABLES_TRX.asset_tax_code%type;

7463: X_tax_rate OUT NOCOPY NUMBER) IS
7464:
7465: -- l_vat_tax_id NUMBER;
7466: y_dr_vat_tax_code AR_RECEIVABLES_TRX.liability_tax_code%type;
7467: y_cr_vat_tax_code AR_RECEIVABLES_TRX.asset_tax_code%type;
7468:
7469: -- bug 5733971
7470: l_return_status VARCHAR2(50);
7471: l_msg_count NUMBER;

Line 7505: FROM ar_receivables_trx ar

7501:
7502: /* bug 10069324
7503: SELECT ar.liability_tax_code, ar.asset_tax_code
7504: INTO y_dr_vat_tax_code, y_cr_vat_tax_code
7505: FROM ar_receivables_trx ar
7506: WHERE ar.receivables_trx_id = CE_AUTO_BANK_MATCH.csl_receivables_trx_id
7507: AND ar.org_id = nvl(CE_AUTO_BANK_MATCH.trx_org_id,CE_AUTO_BANK_REC.G_org_id) ; --CE_AUTO_BANK_MATCH.bau_org_id;
7508: */
7509: SELECT nvl(

Line 7506: WHERE ar.receivables_trx_id = CE_AUTO_BANK_MATCH.csl_receivables_trx_id

7502: /* bug 10069324
7503: SELECT ar.liability_tax_code, ar.asset_tax_code
7504: INTO y_dr_vat_tax_code, y_cr_vat_tax_code
7505: FROM ar_receivables_trx ar
7506: WHERE ar.receivables_trx_id = CE_AUTO_BANK_MATCH.csl_receivables_trx_id
7507: AND ar.org_id = nvl(CE_AUTO_BANK_MATCH.trx_org_id,CE_AUTO_BANK_REC.G_org_id) ; --CE_AUTO_BANK_MATCH.bau_org_id;
7508: */
7509: SELECT nvl(
7510: (

Line 7513: where rtld.receivables_trx_id(+)=ar.receivables_trx_id

7509: SELECT nvl(
7510: (
7511: select rtld.asset_tax_code
7512: from ar_rec_trx_le_details rtld
7513: where rtld.receivables_trx_id(+)=ar.receivables_trx_id
7514: and l_le_id = rtld.legal_entity_id
7515: ),ar.asset_tax_code) asset_tax_code,
7516: nvl(
7517: (

Line 7520: where rtld.receivables_trx_id(+)=ar.receivables_trx_id

7516: nvl(
7517: (
7518: select rtld.liability_tax_code
7519: from ar_rec_trx_le_details rtld
7520: where rtld.receivables_trx_id(+)=ar.receivables_trx_id
7521: and l_le_id = rtld.legal_entity_id
7522: ),ar.liability_tax_code) liability_tax_code
7523: INTO y_cr_vat_tax_code, y_dr_vat_tax_code
7524: FROM ar_receivables_trx ar

Line 7524: FROM ar_receivables_trx ar

7520: where rtld.receivables_trx_id(+)=ar.receivables_trx_id
7521: and l_le_id = rtld.legal_entity_id
7522: ),ar.liability_tax_code) liability_tax_code
7523: INTO y_cr_vat_tax_code, y_dr_vat_tax_code
7524: FROM ar_receivables_trx ar
7525: WHERE ar.receivables_trx_id = CE_AUTO_BANK_MATCH.csl_receivables_trx_id
7526: AND ar.org_id = nvl(CE_AUTO_BANK_MATCH.trx_org_id,CE_AUTO_BANK_REC.G_org_id) ;
7527: else
7528: y_dr_vat_tax_code := CE_AUTO_BANK_REC.G_dr_vat_tax_code;

Line 7525: WHERE ar.receivables_trx_id = CE_AUTO_BANK_MATCH.csl_receivables_trx_id

7521: and l_le_id = rtld.legal_entity_id
7522: ),ar.liability_tax_code) liability_tax_code
7523: INTO y_cr_vat_tax_code, y_dr_vat_tax_code
7524: FROM ar_receivables_trx ar
7525: WHERE ar.receivables_trx_id = CE_AUTO_BANK_MATCH.csl_receivables_trx_id
7526: AND ar.org_id = nvl(CE_AUTO_BANK_MATCH.trx_org_id,CE_AUTO_BANK_REC.G_org_id) ;
7527: else
7528: y_dr_vat_tax_code := CE_AUTO_BANK_REC.G_dr_vat_tax_code;
7529: y_cr_vat_tax_code := CE_AUTO_BANK_REC.G_cr_vat_tax_code;