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.JL_BR_AR_REMIT_COLL_OCCUR dependencies on JL_BR_AR_BANK_OCCURRENCES

Line 82: JL_BR_AR_BANK_OCCURRENCES jlbo

78: JL_BR_AR_SELECT_ACCOUNTS_ALL CSC,
79: JL_BR_AR_REC_MET_ACCTS_EXT_ALL JLBRRMA,
80: AP_BANK_ACCOUNTS_ALL apba,
81: AP_BANK_BRANCHES apbb,
82: JL_BR_AR_BANK_OCCURRENCES jlbo
83: where DC.PAYMENT_SCHEDULE_ID = PS.PAYMENT_SCHEDULE_ID
84: and PS.STATUS = 'OP'
85: and B.BORDERO_STATUS = 'SELECTED'
86: and DC.DOCUMENT_STATUS = 'SELECTED'

Line 148: JL_BR_AR_BANK_OCCURRENCES jlbo,

144: JL_BR_AR_BORDEROS B,
145: AR_RECEIPT_METHOD_ACCOUNTS_ALL RMA,
146: JL_BR_AR_SELECT_ACCOUNTS_ALL CSC,
147: JL_BR_AR_REC_MET_ACCTS_EXT_ALL JLBRRMA,
148: JL_BR_AR_BANK_OCCURRENCES jlbo,
149: CE_BANK_ACCOUNTS CeBankAccount,
150: CE_BANK_ACCT_USES_ALL CeBankAcctUse,
151: HZ_PARTIES HzPartyBank
152: Where b.bank_acct_use_id = CeBankAcctUse.bank_acct_use_id

Line 677: JL_BR_AR_BANK_OCCURRENCES BO

673: cursor OC is
674: select OD.OCCURRENCE_ID, BO.STD_OCCURRENCE_CODE, OD.DOCUMENT_ID
675: from JL_BR_AR_OCCURRENCE_DOCS_ALL OD,
676: JL_BR_AR_BORDEROS B,
677: JL_BR_AR_BANK_OCCURRENCES BO
678: where OD.OCCURRENCE_STATUS = 'SELECTED'
679: and B.BORDERO_STATUS = 'SELECTED'
680: and B.BORDERO_ID = OD.BORDERO_ID
681: and OD.BORDERO_ID = P_BORDERO_ID