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.OE_CREDIT_CHECK_UTIL dependencies on AR_RECEIVABLE_APPLICATIONS

Line 5983: ar_receivable_applications rap

5979: (
5980: SELECT
5981: 'X'
5982: FROM
5983: ar_receivable_applications rap
5984: WHERE
5985: rap.cash_receipt_id = cr.cash_receipt_id
5986: AND rap.applied_payment_schedule_id = -2
5987: AND rap.display = 'Y'

Line 6019: ar_receivable_applications rap

6015: (
6016: SELECT
6017: 'X'
6018: FROM
6019: ar_receivable_applications rap
6020: WHERE
6021: rap.cash_receipt_id = cr.cash_receipt_id
6022: AND rap.applied_payment_schedule_id = -2
6023: AND rap.display = 'Y' );

Line 6992: ar_receivable_applications rap

6988: (
6989: SELECT
6990: 'X'
6991: FROM
6992: ar_receivable_applications rap
6993: WHERE
6994: rap.cash_receipt_id = cr.cash_receipt_id
6995: AND rap.applied_payment_schedule_id = -2
6996: AND rap.display = 'Y'

Line 7030: ar_receivable_applications rap

7026: (
7027: SELECT
7028: 'X'
7029: FROM
7030: ar_receivable_applications rap
7031: WHERE
7032: rap.cash_receipt_id = cr.cash_receipt_id
7033: AND rap.applied_payment_schedule_id = -2
7034: AND rap.display = 'Y'

Line 7887: ar_receivable_applications_ALL rap

7883: (
7884: SELECT
7885: 'X'
7886: FROM
7887: ar_receivable_applications_ALL rap
7888: WHERE
7889: rap.cash_receipt_id = cr.cash_receipt_id
7890: AND rap.applied_payment_schedule_id = -2
7891: AND rap.display = 'Y'

Line 7925: ar_receivable_applications_ALL rap

7921: (
7922: SELECT
7923: 'X'
7924: FROM
7925: ar_receivable_applications_ALL rap
7926: WHERE
7927: rap.cash_receipt_id = cr.cash_receipt_id
7928: AND rap.applied_payment_schedule_id = -2
7929: AND rap.display = 'Y'

Line 7954: ar_receivable_applications_ALL rap

7950: (
7951: SELECT
7952: 'X'
7953: FROM
7954: ar_receivable_applications_ALL rap
7955: WHERE
7956: rap.cash_receipt_id = cr.cash_receipt_id
7957: AND rap.applied_payment_schedule_id = -2
7958: AND rap.display = 'Y'

Line 8006: ar_receivable_applications_ALL rap

8002: (
8003: SELECT
8004: 'X'
8005: FROM
8006: ar_receivable_applications_ALL rap
8007: WHERE
8008: rap.cash_receipt_id = cr.cash_receipt_id
8009: AND rap.applied_payment_schedule_id = -2
8010: AND rap.display = 'Y');