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.OKL_BPD_ADV_MON_RPT_PVT dependencies on OKL_TXL_RCPT_APPS_B

Line 29: FROM okl_ext_csh_rcpts_b,okl_xtl_csh_apps_b,okl_txl_rcpt_apps_b,

25: okc_k_headers_b.Contract_Number Contract_number ,
26: okl_xtl_csh_apps_b.invoice_number invoice_number,
27: okl_xtl_csh_apps_b.TRX_DATE TRX_DATE,
28: okl_xtl_csh_apps_b.amount_applied amount_applied
29: FROM okl_ext_csh_rcpts_b,okl_xtl_csh_apps_b,okl_txl_rcpt_apps_b,
30: okx_customer_accounts_v,okc_k_headers_b, okl_trx_csh_receipt_b
31: WHERE okl_ext_csh_rcpts_b.ID = okl_xtl_csh_apps_b.XCR_ID_DETAILS
32: AND okl_trx_csh_receipt_b.id = okl_txl_rcpt_apps_b.RCT_ID_DETAILS
33: AND okl_txl_rcpt_apps_b.ILE_ID = okx_customer_accounts_v.ID1

Line 32: AND okl_trx_csh_receipt_b.id = okl_txl_rcpt_apps_b.RCT_ID_DETAILS

28: okl_xtl_csh_apps_b.amount_applied amount_applied
29: FROM okl_ext_csh_rcpts_b,okl_xtl_csh_apps_b,okl_txl_rcpt_apps_b,
30: okx_customer_accounts_v,okc_k_headers_b, okl_trx_csh_receipt_b
31: WHERE okl_ext_csh_rcpts_b.ID = okl_xtl_csh_apps_b.XCR_ID_DETAILS
32: AND okl_trx_csh_receipt_b.id = okl_txl_rcpt_apps_b.RCT_ID_DETAILS
33: AND okl_txl_rcpt_apps_b.ILE_ID = okx_customer_accounts_v.ID1
34: AND okc_k_headers_b.id(+) = okl_txl_rcpt_apps_b.khr_id
35: AND okl_trx_csh_receipt_b.receipt_type = 'ADV'
36: AND okl_ext_csh_rcpts_b.RCT_ID = okl_trx_csh_receipt_b.id

Line 33: AND okl_txl_rcpt_apps_b.ILE_ID = okx_customer_accounts_v.ID1

29: FROM okl_ext_csh_rcpts_b,okl_xtl_csh_apps_b,okl_txl_rcpt_apps_b,
30: okx_customer_accounts_v,okc_k_headers_b, okl_trx_csh_receipt_b
31: WHERE okl_ext_csh_rcpts_b.ID = okl_xtl_csh_apps_b.XCR_ID_DETAILS
32: AND okl_trx_csh_receipt_b.id = okl_txl_rcpt_apps_b.RCT_ID_DETAILS
33: AND okl_txl_rcpt_apps_b.ILE_ID = okx_customer_accounts_v.ID1
34: AND okc_k_headers_b.id(+) = okl_txl_rcpt_apps_b.khr_id
35: AND okl_trx_csh_receipt_b.receipt_type = 'ADV'
36: AND okl_ext_csh_rcpts_b.RCT_ID = okl_trx_csh_receipt_b.id
37: AND okl_ext_csh_rcpts_b.Receipt_date >= NVL(lap_from_date,okl_ext_csh_rcpts_b.Receipt_date)

Line 34: AND okc_k_headers_b.id(+) = okl_txl_rcpt_apps_b.khr_id

30: okx_customer_accounts_v,okc_k_headers_b, okl_trx_csh_receipt_b
31: WHERE okl_ext_csh_rcpts_b.ID = okl_xtl_csh_apps_b.XCR_ID_DETAILS
32: AND okl_trx_csh_receipt_b.id = okl_txl_rcpt_apps_b.RCT_ID_DETAILS
33: AND okl_txl_rcpt_apps_b.ILE_ID = okx_customer_accounts_v.ID1
34: AND okc_k_headers_b.id(+) = okl_txl_rcpt_apps_b.khr_id
35: AND okl_trx_csh_receipt_b.receipt_type = 'ADV'
36: AND okl_ext_csh_rcpts_b.RCT_ID = okl_trx_csh_receipt_b.id
37: AND okl_ext_csh_rcpts_b.Receipt_date >= NVL(lap_from_date,okl_ext_csh_rcpts_b.Receipt_date)
38: AND okl_ext_csh_rcpts_b.Receipt_date <= NVL(lap_to_Date,okl_ext_csh_rcpts_b.Receipt_date)

Line 85: FROM okl_ext_csh_rcpts_b,okl_txl_rcpt_apps_b,okx_customer_accounts_v,okc_k_headers_b, okl_trx_csh_receipt_b

81: FROM AR_RECEIVABLE_APPLICATIONS_ALL
82: WHERE status = 'ACC'
83: AND cash_Receipt_id = okl_ext_csh_rcpts_b.icr_id)Amount,
84: okc_k_headers_b.Contract_Number Contract_number
85: FROM okl_ext_csh_rcpts_b,okl_txl_rcpt_apps_b,okx_customer_accounts_v,okc_k_headers_b, okl_trx_csh_receipt_b
86: WHERE okl_trx_csh_receipt_b.id = okl_txl_rcpt_apps_b.RCT_ID_DETAILS
87: AND okl_txl_rcpt_apps_b.ILE_ID = okx_customer_accounts_v.ID1
88: AND okc_k_headers_b.id (+) = okl_txl_rcpt_apps_b.khr_id
89: AND okl_trx_csh_receipt_b.receipt_type = 'ADV'

Line 86: WHERE okl_trx_csh_receipt_b.id = okl_txl_rcpt_apps_b.RCT_ID_DETAILS

82: WHERE status = 'ACC'
83: AND cash_Receipt_id = okl_ext_csh_rcpts_b.icr_id)Amount,
84: okc_k_headers_b.Contract_Number Contract_number
85: FROM okl_ext_csh_rcpts_b,okl_txl_rcpt_apps_b,okx_customer_accounts_v,okc_k_headers_b, okl_trx_csh_receipt_b
86: WHERE okl_trx_csh_receipt_b.id = okl_txl_rcpt_apps_b.RCT_ID_DETAILS
87: AND okl_txl_rcpt_apps_b.ILE_ID = okx_customer_accounts_v.ID1
88: AND okc_k_headers_b.id (+) = okl_txl_rcpt_apps_b.khr_id
89: AND okl_trx_csh_receipt_b.receipt_type = 'ADV'
90: AND okl_ext_csh_rcpts_b.RCT_ID = okl_trx_csh_receipt_b.id

Line 87: AND okl_txl_rcpt_apps_b.ILE_ID = okx_customer_accounts_v.ID1

83: AND cash_Receipt_id = okl_ext_csh_rcpts_b.icr_id)Amount,
84: okc_k_headers_b.Contract_Number Contract_number
85: FROM okl_ext_csh_rcpts_b,okl_txl_rcpt_apps_b,okx_customer_accounts_v,okc_k_headers_b, okl_trx_csh_receipt_b
86: WHERE okl_trx_csh_receipt_b.id = okl_txl_rcpt_apps_b.RCT_ID_DETAILS
87: AND okl_txl_rcpt_apps_b.ILE_ID = okx_customer_accounts_v.ID1
88: AND okc_k_headers_b.id (+) = okl_txl_rcpt_apps_b.khr_id
89: AND okl_trx_csh_receipt_b.receipt_type = 'ADV'
90: AND okl_ext_csh_rcpts_b.RCT_ID = okl_trx_csh_receipt_b.id
91: AND okl_ext_csh_rcpts_b.Receipt_date >= NVL(lup_From_date,okl_ext_csh_rcpts_b.Receipt_date)

Line 88: AND okc_k_headers_b.id (+) = okl_txl_rcpt_apps_b.khr_id

84: okc_k_headers_b.Contract_Number Contract_number
85: FROM okl_ext_csh_rcpts_b,okl_txl_rcpt_apps_b,okx_customer_accounts_v,okc_k_headers_b, okl_trx_csh_receipt_b
86: WHERE okl_trx_csh_receipt_b.id = okl_txl_rcpt_apps_b.RCT_ID_DETAILS
87: AND okl_txl_rcpt_apps_b.ILE_ID = okx_customer_accounts_v.ID1
88: AND okc_k_headers_b.id (+) = okl_txl_rcpt_apps_b.khr_id
89: AND okl_trx_csh_receipt_b.receipt_type = 'ADV'
90: AND okl_ext_csh_rcpts_b.RCT_ID = okl_trx_csh_receipt_b.id
91: AND okl_ext_csh_rcpts_b.Receipt_date >= NVL(lup_From_date,okl_ext_csh_rcpts_b.Receipt_date)
92: AND okl_ext_csh_rcpts_b.Receipt_date <= NVL(lup_To_date,okl_ext_csh_rcpts_b.Receipt_date)

Line 117: AND NOT EXISTS (select id from okl_txl_rcpt_apps_b where rct_id_details = e.id)

113: AND a.contract_number(+) = c.contract_number
114: AND e.receipt_type = 'ADV'
115: AND b.Receipt_date >= NVL(null,b.Receipt_date)
116: AND b.Receipt_date <= NVL(null,b.Receipt_date)
117: AND NOT EXISTS (select id from okl_txl_rcpt_apps_b where rct_id_details = e.id)
118: ORDER BY Check_number;
119:
120: CURSOR org_csr (l_org_id IN NUMBER) IS
121: SELECT name