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.PA_FUND_REVAL_PVT dependencies on PA_DRAFT_INVOICE_ITEMS

Line 2517: FROM pa_draft_invoice_items dii,

2513: decode(di.draft_invoice_num_credited, NULL, 'N', 'Y') credit_memo_flag,
2514: sum(dii.projfunc_bill_amount) projfunc_bill_amount,
2515: sum(dii.funding_bill_amount) funding_bill_amount,
2516: sum(dii.inv_amount) inv_amount
2517: FROM pa_draft_invoice_items dii,
2518: pa_draft_invoices di
2519: WHERE di.project_id = p_project_id
2520: AND di.agreement_id = p_agreement_id
2521: AND di.transfer_status_code = 'A'

Line 2554: FROM pa_draft_invoice_items dii,

2550: decode(di.draft_invoice_num_credited, NULL, 'N', 'Y') credit_memo_flag,
2551: sum(dii.projfunc_bill_amount) projfunc_bill_amount,
2552: sum(dii.funding_bill_amount) funding_bill_amount,
2553: sum(dii.inv_amount) inv_amount
2554: FROM pa_draft_invoice_items dii,
2555: pa_draft_invoices di
2556: WHERE di.project_id = p_project_id
2557: AND di.agreement_id = p_agreement_id
2558: AND di.transfer_status_code = 'A'

Line 2583: FROM pa_draft_invoice_items dii, pa_mc_draft_inv_items dii_mc, pa_draft_invoices di,

2579: decode(di.draft_invoice_num_credited, NULL, 'N', 'Y') credit_memo_flag,
2580: sum(dii_mc.amount) projfunc_bill_amount,
2581: sum(dii.funding_bill_amount) funding_bill_amount,
2582: sum(dii.inv_amount) inv_amount
2583: FROM pa_draft_invoice_items dii, pa_mc_draft_inv_items dii_mc, pa_draft_invoices di,
2584: gl_alc_ledger_rships_v rep, pa_implementations imp
2585: WHERE di.project_id = p_project_id
2586: AND di.agreement_id = p_agreement_id
2587: AND di.transfer_status_code = 'A'

Line 3297: FROM pa_draft_invoice_items dii,

3293: 0 retn_amount,
3294: 0 projfunc_retn_amount,
3295: 0 funding_retn_amount,
3296: 0 inv_retn_amount
3297: FROM pa_draft_invoice_items dii,
3298: pa_draft_invoices di
3299: WHERE di.project_id = p_project_id
3300: AND di.agreement_id = p_agreement_id
3301: AND dii.project_id = di.project_id

Line 3330: FROM pa_draft_invoice_items dii,

3326: 0 retn_amount,
3327: 0 projfunc_retn_amount,
3328: 0 funding_retn_amount,
3329: 0 inv_retn_amount
3330: FROM pa_draft_invoice_items dii,
3331: pa_draft_invoices di
3332: WHERE di.project_id = p_project_id
3333: AND di.agreement_id = p_agreement_id
3334: AND dii.project_id = di.project_id

Line 3372: FROM pa_draft_invoice_items dii,

3368: 0 retn_amount,
3369: 0 projfunc_retn_amount,
3370: 0 funding_retn_amount,
3371: 0 inv_retn_amount
3372: FROM pa_draft_invoice_items dii,
3373: pa_draft_invoices di
3374: WHERE di.project_id = p_project_id
3375: AND di.agreement_id = p_agreement_id
3376: AND dii.project_id = di.project_id

Line 3409: FROM pa_draft_invoice_items dii,

3405: 0 retn_amount,
3406: 0 projfunc_retn_amount,
3407: 0 funding_retn_amount,
3408: 0 inv_retn_amount
3409: FROM pa_draft_invoice_items dii,
3410: pa_draft_invoices di
3411: WHERE di.project_id = p_project_id
3412: AND di.agreement_id = p_agreement_id
3413: AND dii.project_id = di.project_id

Line 3445: FROM pa_mc_draft_inv_items dii_mc, pa_draft_invoice_items dii, pa_draft_invoices di,

3441: 0 retn_amount,
3442: 0 projfunc_retn_amount,
3443: 0 funding_retn_amount,
3444: 0 inv_retn_amount
3445: FROM pa_mc_draft_inv_items dii_mc, pa_draft_invoice_items dii, pa_draft_invoices di,
3446: gl_alc_ledger_rships_v rep, pa_implementations imp
3447: WHERE di.project_id = p_project_id
3448: AND di.agreement_id = p_agreement_id
3449: AND dii.project_id = di.project_id

Line 3490: FROM pa_mc_draft_inv_items dii_mc, pa_draft_invoice_items dii, pa_draft_invoices di,

3486: 0 retn_amount,
3487: 0 projfunc_retn_amount,
3488: 0 funding_retn_amount,
3489: 0 inv_retn_amount
3490: FROM pa_mc_draft_inv_items dii_mc, pa_draft_invoice_items dii, pa_draft_invoices di,
3491: gl_alc_ledger_rships_v rep, pa_implementations imp
3492: WHERE di.project_id = p_project_id
3493: AND di.agreement_id = p_agreement_id
3494: AND dii.project_id = di.project_id

Line 3579: FROM pa_draft_invoice_items dii,

3575: sum(decode(dii.invoice_line_type,'RETENTION',
3576: dii.funding_bill_amount,0)) funding_retn_amount,
3577: sum(decode(dii.invoice_line_type,'RETENTION',
3578: dii.inv_amount,0)) inv_retn_amount
3579: FROM pa_draft_invoice_items dii,
3580: pa_draft_invoices di
3581: WHERE di.project_id = p_project_id
3582: AND di.agreement_id = p_agreement_id
3583: AND dii.project_id = di.project_id

Line 3613: FROM pa_draft_invoice_items dii,

3609: 0 retn_amount,
3610: 0 projfunc_retn_amount,
3611: 0 funding_retn_amount,
3612: 0 inv_retn_amount
3613: FROM pa_draft_invoice_items dii,
3614: pa_draft_invoices di
3615: WHERE di.project_id = p_project_id
3616: AND di.agreement_id = p_agreement_id
3617: AND dii.project_id = di.project_id

Line 3663: FROM pa_draft_invoice_items dii,

3659: sum(decode(dii.invoice_line_type,'RETENTION',
3660: dii.funding_bill_amount,0)) funding_retn_amount,
3661: sum(decode(dii.invoice_line_type,'RETENTION',
3662: dii.inv_amount,0)) inv_retn_amount
3663: FROM pa_draft_invoice_items dii,
3664: pa_draft_invoices di
3665: WHERE di.project_id = p_project_id
3666: AND di.agreement_id = p_agreement_id
3667: AND dii.project_id = di.project_id

Line 3697: FROM pa_draft_invoice_items dii,

3693: 0 retn_amount,
3694: 0 projfunc_retn_amount,
3695: 0 funding_retn_amount,
3696: 0 inv_retn_amount
3697: FROM pa_draft_invoice_items dii,
3698: pa_draft_invoices di
3699: WHERE di.project_id = p_project_id
3700: AND di.agreement_id = p_agreement_id
3701: AND dii.project_id = di.project_id

Line 3741: FROM pa_mc_draft_inv_items dii_mc, pa_draft_invoice_items dii, pa_draft_invoices di,

3737: sum(decode(dii.invoice_line_type,'RETENTION',
3738: dii.funding_bill_amount,0)) funding_retn_amount,
3739: sum(decode(dii.invoice_line_type,'RETENTION',
3740: dii.inv_amount,0)) inv_retn_amount
3741: FROM pa_mc_draft_inv_items dii_mc, pa_draft_invoice_items dii, pa_draft_invoices di,
3742: gl_alc_ledger_rships_v rep, pa_implementations imp
3743: WHERE di.project_id = p_project_id
3744: AND di.agreement_id = p_agreement_id
3745: AND dii.project_id = di.project_id

Line 3786: FROM pa_mc_draft_inv_items dii_mc, pa_draft_invoice_items dii, pa_draft_invoices di,

3782: 0 retn_amount,
3783: 0 projfunc_retn_amount,
3784: 0 funding_retn_amount,
3785: 0 inv_retn_amount
3786: FROM pa_mc_draft_inv_items dii_mc, pa_draft_invoice_items dii, pa_draft_invoices di,
3787: gl_alc_ledger_rships_v rep, pa_implementations imp
3788: WHERE di.project_id = p_project_id
3789: AND di.agreement_id = p_agreement_id
3790: AND dii.project_id = di.project_id

Line 5881: FROM pa_draft_invoice_items dii

5877: sum(dii.amount) amount,
5878: sum(dii.projfunc_bill_amount) projfunc_bill_amount,
5879: sum(dii.funding_bill_amount) funding_bill_amount,
5880: sum(dii.inv_amount) inv_amount
5881: FROM pa_draft_invoice_items dii
5882: WHERE dii.project_id = p_project_id
5883: AND dii.draft_invoice_num = p_draft_inv_num;
5884: --AND dii.invoice_line_type <> 'RETENTION';
5885:

Line 5899: FROM pa_draft_invoice_items dii

5895: sum(dii.amount) amount,
5896: sum(dii.projfunc_bill_amount) projfunc_bill_amount,
5897: sum(dii.funding_bill_amount) funding_bill_amount,
5898: sum(dii.inv_amount) inv_amount
5899: FROM pa_draft_invoice_items dii
5900: WHERE dii.project_id = p_project_id
5901: AND dii.draft_invoice_num = p_draft_inv_num
5902: --AND dii.invoice_line_type <> 'RETENTION'
5903: UNION

Line 5909: FROM pa_mc_draft_inv_items dii_mc, pa_draft_invoice_items dii,

5905: sum(dii.amount) amount,
5906: sum(dii_mc.amount) projfunc_bill_amount,
5907: sum(dii.funding_bill_amount) funding_bill_amount,
5908: sum(dii.inv_amount) inv_amount
5909: FROM pa_mc_draft_inv_items dii_mc, pa_draft_invoice_items dii,
5910: gl_alc_ledger_rships_v rep, pa_implementations imp
5911: WHERE dii.project_id = p_project_id
5912: AND dii.draft_invoice_num = p_draft_inv_num
5913: -- AND dii.invoice_line_type <> 'RETENTION'

Line 6138: FROM pa_cust_rev_dist_lines RDL, pa_draft_invoice_items DII

6134: CURSOR rdl_amount IS
6135: SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
6136: SUM((rdl.retained_amount/rdl.bill_amount) * rdl.projfunc_bill_amount) retained_amt_pfc,
6137: SUM((rdl.retained_amount/rdl.bill_amount) * rdl.funding_bill_amount) retained_amt_fc
6138: FROM pa_cust_rev_dist_lines RDL, pa_draft_invoice_items DII
6139: WHERE DII.project_id = p_project_id
6140: AND DII.draft_invoice_num = p_draft_inv_num
6141: AND NVL(DII.task_id,0) = p_task_id
6142: AND RDL.project_id = DII.project_id

Line 6153: FROM pa_cust_rev_dist_lines RDL, pa_draft_invoice_items DII

6149: /* mrc migration to SLA bug 4571438 CURSOR rdl_amount_all IS
6150: (SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
6151: SUM((rdl.retained_amount/rdl.bill_amount) * rdl.projfunc_bill_amount) retained_amt_pfc,
6152: SUM((rdl.retained_amount/rdl.bill_amount) * rdl.funding_bill_amount) retained_amt_fc
6153: FROM pa_cust_rev_dist_lines RDL, pa_draft_invoice_items DII
6154: WHERE DII.project_id = p_project_id
6155: AND DII.draft_invoice_num = p_draft_inv_num
6156: AND NVL(DII.task_id,0) = p_task_id
6157: AND RDL.project_id = DII.project_id

Line 6164: FROM pa_cust_rev_dist_lines RDL, pa_draft_invoice_items DII, pa_mc_cust_rdl_all RDL_MC,

6160: UNION
6161: SELECT RDL_MC.set_of_books_id,
6162: SUM((rdl.retained_amount/rdl.bill_amount) * rdl_mc.amount) retained_amt_pfc,
6163: SUM((rdl.retained_amount/rdl.bill_amount) * rdl.funding_bill_amount) retained_amt_fc
6164: FROM pa_cust_rev_dist_lines RDL, pa_draft_invoice_items DII, pa_mc_cust_rdl_all RDL_MC,
6165: gl_alc_ledger_rships_v rep, pa_implementations imp
6166: WHERE DII.project_id = p_project_id
6167: AND DII.draft_invoice_num = p_draft_inv_num
6168: AND NVL(DII.task_id,0) = p_task_id

Line 6187: FROM pa_cust_event_rdl_all ERDL, pa_draft_invoice_items DII

6183: CURSOR erdl_amount IS
6184: SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
6185: SUM((erdl.retained_amount/erdl.amount) * erdl.projfunc_bill_amount) retained_amt_pfc,
6186: SUM((erdl.retained_amount/erdl.amount) * erdl.funding_bill_amount) retained_amt_fc
6187: FROM pa_cust_event_rdl_all ERDL, pa_draft_invoice_items DII
6188: WHERE DII.project_id = p_project_id
6189: AND DII.draft_invoice_num = p_draft_inv_num
6190: AND NVL(DII.task_id,0) = p_task_id
6191: AND ERDL.project_id = DII.project_id

Line 6203: FROM pa_cust_event_rdl_all ERDL, pa_draft_invoice_items DII

6199: /* mrc migration to SLA bug 4571438 CURSOR erdl_amount_all IS
6200: (SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
6201: SUM((erdl.retained_amount/erdl.amount) * erdl.projfunc_bill_amount) retained_amt_pfc,
6202: SUM((erdl.retained_amount/erdl.amount) * erdl.funding_bill_amount) retained_amt_fc
6203: FROM pa_cust_event_rdl_all ERDL, pa_draft_invoice_items DII
6204: WHERE DII.project_id = p_project_id
6205: AND DII.draft_invoice_num = p_draft_inv_num
6206: AND NVL(DII.task_id,0) = p_task_id
6207: AND ERDL.project_id = DII.project_id

Line 6214: FROM pa_cust_event_rdl_all ERDL, pa_draft_invoice_items DII,

6210: UNION
6211: SELECT ERDL_MC.set_of_books_id,
6212: SUM((erdl.retained_amount/erdl.amount) * ERDL_MC.amount) retained_amt_pfc,
6213: SUM((erdl.retained_amount/erdl.amount) * erdl.funding_bill_amount) retained_amt_fc
6214: FROM pa_cust_event_rdl_all ERDL, pa_draft_invoice_items DII,
6215: pa_mc_cust_event_rdl_all ERDL_MC,
6216: gl_alc_ledger_rships_v rep, pa_implementations imp
6217: WHERE DII.project_id = p_project_id
6218: AND DII.draft_invoice_num = p_draft_inv_num

Line 6240: FROM pa_draft_invoice_items DII

6236: CURSOR dii_amount IS
6237: SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
6238: SUM((DII.retained_amount/DII.amount) * DII.projfunc_bill_amount) retained_amt_pfc,
6239: SUM((DII.retained_amount/DII.amount) * DII.funding_bill_amount) retained_amt_fc
6240: FROM pa_draft_invoice_items DII
6241: WHERE DII.project_id = p_project_id
6242: AND DII.draft_invoice_num = p_draft_inv_num
6243: AND DII.task_id = p_task_id
6244: AND DII.event_num is not null;

Line 6253: FROM pa_draft_invoice_items DII

6249: /* mrc migration to SLA bug 4571438 CURSOR dii_amount_all IS
6250: (SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
6251: SUM((DII.retained_amount/DII.amount) * DII.projfunc_bill_amount) retained_amt_pfc,
6252: SUM((DII.retained_amount/DII.amount) * DII.funding_bill_amount) retained_amt_fc
6253: FROM pa_draft_invoice_items DII
6254: WHERE DII.project_id = p_project_id
6255: AND DII.draft_invoice_num = p_draft_inv_num
6256: AND DII.event_num is not null
6257: AND DII.task_id = p_task_id

Line 6262: FROM pa_draft_invoice_items DII, pa_mc_draft_inv_items DII_MC,

6258: UNION
6259: SELECT DII_MC.set_of_books_id,
6260: SUM((DII.retained_amount/DII.amount) * DII_MC.amount) retained_amt_pfc,
6261: SUM((DII.retained_amount/DII.amount) * DII.funding_bill_amount) retained_amt_fc
6262: FROM pa_draft_invoice_items DII, pa_mc_draft_inv_items DII_MC,
6263: gl_alc_ledger_rships_v rep, pa_implementations imp
6264: WHERE DII.project_id = p_project_id
6265: AND DII.draft_invoice_num = p_draft_inv_num
6266: AND DII.task_id = p_task_id

Line 6328: FROM pa_draft_invoice_items dii

6324:
6325: SELECT 'T' INTO l_RetnExistFlag
6326: FROM DUAL
6327: WHERE EXISTS (SELECT NULL
6328: FROM pa_draft_invoice_items dii
6329: WHERE dii.project_id = p_project_id
6330: AND dii.draft_invoice_num = p_draft_inv_num
6331: AND dii.invoice_line_type = 'RETENTION');
6332:

Line 7034: FROM pa_draft_invoice_items dii,

7030: 0 task_id,
7031: sum(dii.amount) amount,
7032: sum(dii.projfunc_bill_amount) projfunc_bill_amount,
7033: sum(dii.funding_bill_amount) funding_bill_amount
7034: FROM pa_draft_invoice_items dii,
7035: pa_draft_invoices di
7036: WHERE di.project_id = p_project_id
7037: AND di.agreement_id = p_agreement_id
7038: AND dii.project_id = di.project_id

Line 7056: FROM pa_draft_invoice_items dii,

7052: 0 task_id,
7053: sum(dii.amount) amount,
7054: sum(dii.projfunc_bill_amount) projfunc_bill_amount,
7055: sum(dii.funding_bill_amount) funding_bill_amount
7056: FROM pa_draft_invoice_items dii,
7057: pa_draft_invoices di
7058: WHERE di.project_id = p_project_id
7059: AND di.agreement_id = p_agreement_id
7060: AND dii.project_id = di.project_id

Line 7071: FROM pa_mc_draft_inv_items dii_mc, pa_draft_invoice_items dii,

7067: 0 task_id,
7068: sum(dii.amount) amount,
7069: sum(dii_mc.amount) projfunc_bill_amount,
7070: sum(dii.funding_bill_amount) funding_bill_amount
7071: FROM pa_mc_draft_inv_items dii_mc, pa_draft_invoice_items dii,
7072: pa_draft_invoices di,
7073: gl_alc_ledger_rships_v rep, pa_implementations imp
7074: WHERE di.project_id = p_project_id
7075: AND di.agreement_id = p_agreement_id

Line 7104: FROM pa_draft_invoice_items dii,

7100: dii.task_id,
7101: sum(dii.amount) amount,
7102: sum(dii.projfunc_bill_amount) projfunc_bill_amount,
7103: sum(dii.funding_bill_amount) funding_bill_amount
7104: FROM pa_draft_invoice_items dii,
7105: pa_draft_invoices di
7106: WHERE di.project_id = p_project_id
7107: AND di.agreement_id = p_agreement_id
7108: AND dii.project_id = di.project_id

Line 7127: FROM pa_draft_invoice_items dii,

7123: dii.task_id,
7124: sum(dii.amount) amount,
7125: sum(dii.projfunc_bill_amount) projfunc_bill_amount,
7126: sum(dii.funding_bill_amount) funding_bill_amount
7127: FROM pa_draft_invoice_items dii,
7128: pa_draft_invoices di
7129: WHERE di.project_id = p_project_id
7130: AND di.agreement_id = p_agreement_id
7131: AND dii.project_id = di.project_id

Line 7143: FROM pa_mc_draft_inv_items dii_mc, pa_draft_invoice_items dii, pa_draft_invoices di,

7139: dii.task_id,
7140: sum(dii.amount) amount,
7141: sum(dii_mc.amount) projfunc_bill_amount,
7142: sum(dii.funding_bill_amount) funding_bill_amount
7143: FROM pa_mc_draft_inv_items dii_mc, pa_draft_invoice_items dii, pa_draft_invoices di,
7144: gl_alc_ledger_rships_v rep, pa_implementations imp
7145: WHERE di.project_id = p_project_id
7146: AND di.agreement_id = p_agreement_id
7147: AND dii.project_id = di.project_id