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 2519: FROM pa_draft_invoice_items dii,

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

Line 2556: FROM pa_draft_invoice_items dii,

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

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

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

Line 3299: FROM pa_draft_invoice_items dii,

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

Line 3333: FROM pa_draft_invoice_items dii,

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

Line 3376: FROM pa_draft_invoice_items dii,

3372: 0 retn_amount,
3373: 0 projfunc_retn_amount,
3374: 0 funding_retn_amount,
3375: 0 inv_retn_amount
3376: FROM pa_draft_invoice_items dii,
3377: pa_draft_invoices di
3378: WHERE di.project_id = p_project_id
3379: AND di.agreement_id = p_agreement_id
3380: AND dii.project_id = di.project_id

Line 3413: FROM pa_draft_invoice_items dii,

3409: 0 retn_amount,
3410: 0 projfunc_retn_amount,
3411: 0 funding_retn_amount,
3412: 0 inv_retn_amount
3413: FROM pa_draft_invoice_items dii,
3414: pa_draft_invoices di
3415: WHERE di.project_id = p_project_id
3416: AND di.agreement_id = p_agreement_id
3417: AND dii.project_id = di.project_id

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

3445: 0 retn_amount,
3446: 0 projfunc_retn_amount,
3447: 0 funding_retn_amount,
3448: 0 inv_retn_amount
3449: FROM pa_mc_draft_inv_items dii_mc, pa_draft_invoice_items dii, pa_draft_invoices di,
3450: gl_alc_ledger_rships_v rep, pa_implementations imp
3451: WHERE di.project_id = p_project_id
3452: AND di.agreement_id = p_agreement_id
3453: AND dii.project_id = di.project_id

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

3490: 0 retn_amount,
3491: 0 projfunc_retn_amount,
3492: 0 funding_retn_amount,
3493: 0 inv_retn_amount
3494: FROM pa_mc_draft_inv_items dii_mc, pa_draft_invoice_items dii, pa_draft_invoices di,
3495: gl_alc_ledger_rships_v rep, pa_implementations imp
3496: WHERE di.project_id = p_project_id
3497: AND di.agreement_id = p_agreement_id
3498: AND dii.project_id = di.project_id

Line 3583: FROM pa_draft_invoice_items dii,

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

Line 3618: FROM pa_draft_invoice_items dii,

3614: 0 retn_amount,
3615: 0 projfunc_retn_amount,
3616: 0 funding_retn_amount,
3617: 0 inv_retn_amount
3618: FROM pa_draft_invoice_items dii,
3619: pa_draft_invoices di
3620: WHERE di.project_id = p_project_id
3621: AND di.agreement_id = p_agreement_id
3622: AND dii.project_id = di.project_id

Line 3669: FROM pa_draft_invoice_items dii,

3665: sum(decode(dii.invoice_line_type,'RETENTION',
3666: dii.funding_bill_amount,0)) funding_retn_amount,
3667: sum(decode(dii.invoice_line_type,'RETENTION',
3668: dii.inv_amount,0)) inv_retn_amount
3669: FROM pa_draft_invoice_items dii,
3670: pa_draft_invoices di
3671: WHERE di.project_id = p_project_id
3672: AND di.agreement_id = p_agreement_id
3673: AND dii.project_id = di.project_id

Line 3703: FROM pa_draft_invoice_items dii,

3699: 0 retn_amount,
3700: 0 projfunc_retn_amount,
3701: 0 funding_retn_amount,
3702: 0 inv_retn_amount
3703: FROM pa_draft_invoice_items dii,
3704: pa_draft_invoices di
3705: WHERE di.project_id = p_project_id
3706: AND di.agreement_id = p_agreement_id
3707: AND dii.project_id = di.project_id

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

3743: sum(decode(dii.invoice_line_type,'RETENTION',
3744: dii.funding_bill_amount,0)) funding_retn_amount,
3745: sum(decode(dii.invoice_line_type,'RETENTION',
3746: dii.inv_amount,0)) inv_retn_amount
3747: FROM pa_mc_draft_inv_items dii_mc, pa_draft_invoice_items dii, pa_draft_invoices di,
3748: gl_alc_ledger_rships_v rep, pa_implementations imp
3749: WHERE di.project_id = p_project_id
3750: AND di.agreement_id = p_agreement_id
3751: AND dii.project_id = di.project_id

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

3788: 0 retn_amount,
3789: 0 projfunc_retn_amount,
3790: 0 funding_retn_amount,
3791: 0 inv_retn_amount
3792: FROM pa_mc_draft_inv_items dii_mc, pa_draft_invoice_items dii, pa_draft_invoices di,
3793: gl_alc_ledger_rships_v rep, pa_implementations imp
3794: WHERE di.project_id = p_project_id
3795: AND di.agreement_id = p_agreement_id
3796: AND dii.project_id = di.project_id

Line 5887: FROM pa_draft_invoice_items dii,pa_draft_invoices di

5883: sum(dii.amount) amount,
5884: sum(dii.projfunc_bill_amount) projfunc_bill_amount,
5885: sum(dii.funding_bill_amount) funding_bill_amount,
5886: sum(dii.inv_amount) inv_amount
5887: FROM pa_draft_invoice_items dii,pa_draft_invoices di
5888: WHERE dii.project_id = p_project_id
5889: AND dii.project_id = di.project_id
5890: AND dii.draft_invoice_num = p_draft_inv_num
5891: AND di.draft_invoice_num = dii.draft_invoice_num

Line 5908: FROM pa_draft_invoice_items dii

5904: sum(dii.amount) amount,
5905: sum(dii.projfunc_bill_amount) projfunc_bill_amount,
5906: sum(dii.funding_bill_amount) funding_bill_amount,
5907: sum(dii.inv_amount) inv_amount
5908: FROM pa_draft_invoice_items dii
5909: WHERE dii.project_id = p_project_id
5910: AND dii.draft_invoice_num = p_draft_inv_num
5911: --AND dii.invoice_line_type <> 'RETENTION'
5912: UNION

Line 5918: FROM pa_mc_draft_inv_items dii_mc, pa_draft_invoice_items dii,

5914: sum(dii.amount) amount,
5915: sum(dii_mc.amount) projfunc_bill_amount,
5916: sum(dii.funding_bill_amount) funding_bill_amount,
5917: sum(dii.inv_amount) inv_amount
5918: FROM pa_mc_draft_inv_items dii_mc, pa_draft_invoice_items dii,
5919: gl_alc_ledger_rships_v rep, pa_implementations imp
5920: WHERE dii.project_id = p_project_id
5921: AND dii.draft_invoice_num = p_draft_inv_num
5922: -- AND dii.invoice_line_type <> 'RETENTION'

Line 6147: FROM pa_cust_rev_dist_lines RDL, pa_draft_invoice_items DII,

6143: CURSOR rdl_amount IS
6144: SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
6145: SUM((rdl.retained_amount/rdl.bill_amount) * rdl.projfunc_bill_amount) retained_amt_pfc,
6146: SUM((rdl.retained_amount/rdl.bill_amount) * rdl.funding_bill_amount) retained_amt_fc
6147: FROM pa_cust_rev_dist_lines RDL, pa_draft_invoice_items DII,
6148: pa_draft_invoices DI
6149: WHERE DII.project_id = p_project_id
6150: AND DI.project_id = DII.project_id
6151: AND DII.draft_invoice_num = p_draft_inv_num

Line 6166: FROM pa_cust_rev_dist_lines RDL, pa_draft_invoice_items DII

6162: /* mrc migration to SLA bug 4571438 CURSOR rdl_amount_all IS
6163: (SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
6164: SUM((rdl.retained_amount/rdl.bill_amount) * rdl.projfunc_bill_amount) retained_amt_pfc,
6165: SUM((rdl.retained_amount/rdl.bill_amount) * rdl.funding_bill_amount) retained_amt_fc
6166: FROM pa_cust_rev_dist_lines RDL, pa_draft_invoice_items DII
6167: WHERE DII.project_id = p_project_id
6168: AND DII.draft_invoice_num = p_draft_inv_num
6169: AND NVL(DII.task_id,0) = p_task_id
6170: AND RDL.project_id = DII.project_id

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

6173: UNION
6174: SELECT RDL_MC.set_of_books_id,
6175: SUM((rdl.retained_amount/rdl.bill_amount) * rdl_mc.amount) retained_amt_pfc,
6176: SUM((rdl.retained_amount/rdl.bill_amount) * rdl.funding_bill_amount) retained_amt_fc
6177: FROM pa_cust_rev_dist_lines RDL, pa_draft_invoice_items DII, pa_mc_cust_rdl_all RDL_MC,
6178: gl_alc_ledger_rships_v rep, pa_implementations imp
6179: WHERE DII.project_id = p_project_id
6180: AND DII.draft_invoice_num = p_draft_inv_num
6181: AND NVL(DII.task_id,0) = p_task_id

Line 6200: FROM pa_cust_event_rdl_all ERDL, pa_draft_invoice_items DII,

6196: CURSOR erdl_amount IS
6197: SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
6198: SUM((erdl.retained_amount/erdl.amount) * erdl.projfunc_bill_amount) retained_amt_pfc,
6199: SUM((erdl.retained_amount/erdl.amount) * erdl.funding_bill_amount) retained_amt_fc
6200: FROM pa_cust_event_rdl_all ERDL, pa_draft_invoice_items DII,
6201: pa_draft_invoices DI
6202: WHERE DII.project_id = p_project_id
6203: AND DI.project_id = DII.project_id
6204: AND DII.draft_invoice_num = p_draft_inv_num

Line 6220: FROM pa_cust_event_rdl_all ERDL, pa_draft_invoice_items DII

6216: /* mrc migration to SLA bug 4571438 CURSOR erdl_amount_all IS
6217: (SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
6218: SUM((erdl.retained_amount/erdl.amount) * erdl.projfunc_bill_amount) retained_amt_pfc,
6219: SUM((erdl.retained_amount/erdl.amount) * erdl.funding_bill_amount) retained_amt_fc
6220: FROM pa_cust_event_rdl_all ERDL, pa_draft_invoice_items DII
6221: WHERE DII.project_id = p_project_id
6222: AND DII.draft_invoice_num = p_draft_inv_num
6223: AND NVL(DII.task_id,0) = p_task_id
6224: AND ERDL.project_id = DII.project_id

Line 6231: FROM pa_cust_event_rdl_all ERDL, pa_draft_invoice_items DII,

6227: UNION
6228: SELECT ERDL_MC.set_of_books_id,
6229: SUM((erdl.retained_amount/erdl.amount) * ERDL_MC.amount) retained_amt_pfc,
6230: SUM((erdl.retained_amount/erdl.amount) * erdl.funding_bill_amount) retained_amt_fc
6231: FROM pa_cust_event_rdl_all ERDL, pa_draft_invoice_items DII,
6232: pa_mc_cust_event_rdl_all ERDL_MC,
6233: gl_alc_ledger_rships_v rep, pa_implementations imp
6234: WHERE DII.project_id = p_project_id
6235: AND DII.draft_invoice_num = p_draft_inv_num

Line 6257: FROM pa_draft_invoice_items DII,pa_draft_invoices DI

6253: CURSOR dii_amount IS
6254: SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
6255: SUM((DII.retained_amount/DII.amount) * DII.projfunc_bill_amount) retained_amt_pfc,
6256: SUM((DII.retained_amount/DII.amount) * DII.funding_bill_amount) retained_amt_fc
6257: FROM pa_draft_invoice_items DII,pa_draft_invoices DI
6258: WHERE DII.project_id = p_project_id
6259: AND DI.project_id = DII.project_id
6260: AND DII.draft_invoice_num = p_draft_inv_num
6261: AND DI.draft_invoice_num = DII.draft_invoice_num

Line 6273: FROM pa_draft_invoice_items DII

6269: /* mrc migration to SLA bug 4571438 CURSOR dii_amount_all IS
6270: (SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
6271: SUM((DII.retained_amount/DII.amount) * DII.projfunc_bill_amount) retained_amt_pfc,
6272: SUM((DII.retained_amount/DII.amount) * DII.funding_bill_amount) retained_amt_fc
6273: FROM pa_draft_invoice_items DII
6274: WHERE DII.project_id = p_project_id
6275: AND DII.draft_invoice_num = p_draft_inv_num
6276: AND DII.event_num is not null
6277: AND DII.task_id = p_task_id

Line 6282: FROM pa_draft_invoice_items DII, pa_mc_draft_inv_items DII_MC,

6278: UNION
6279: SELECT DII_MC.set_of_books_id,
6280: SUM((DII.retained_amount/DII.amount) * DII_MC.amount) retained_amt_pfc,
6281: SUM((DII.retained_amount/DII.amount) * DII.funding_bill_amount) retained_amt_fc
6282: FROM pa_draft_invoice_items DII, pa_mc_draft_inv_items DII_MC,
6283: gl_alc_ledger_rships_v rep, pa_implementations imp
6284: WHERE DII.project_id = p_project_id
6285: AND DII.draft_invoice_num = p_draft_inv_num
6286: AND DII.task_id = p_task_id

Line 6348: FROM pa_draft_invoice_items dii

6344:
6345: SELECT 'T' INTO l_RetnExistFlag
6346: FROM DUAL
6347: WHERE EXISTS (SELECT NULL
6348: FROM pa_draft_invoice_items dii
6349: WHERE dii.project_id = p_project_id
6350: AND dii.draft_invoice_num = p_draft_inv_num
6351: AND dii.invoice_line_type = 'RETENTION');
6352:

Line 7054: FROM pa_draft_invoice_items dii,

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

Line 7077: FROM pa_draft_invoice_items dii,

7073: 0 task_id,
7074: sum(dii.amount) amount,
7075: sum(dii.projfunc_bill_amount) projfunc_bill_amount,
7076: sum(dii.funding_bill_amount) funding_bill_amount
7077: FROM pa_draft_invoice_items dii,
7078: pa_draft_invoices di
7079: WHERE di.project_id = p_project_id
7080: AND di.agreement_id = p_agreement_id
7081: AND dii.project_id = di.project_id

Line 7092: FROM pa_mc_draft_inv_items dii_mc, pa_draft_invoice_items dii,

7088: 0 task_id,
7089: sum(dii.amount) amount,
7090: sum(dii_mc.amount) projfunc_bill_amount,
7091: sum(dii.funding_bill_amount) funding_bill_amount
7092: FROM pa_mc_draft_inv_items dii_mc, pa_draft_invoice_items dii,
7093: pa_draft_invoices di,
7094: gl_alc_ledger_rships_v rep, pa_implementations imp
7095: WHERE di.project_id = p_project_id
7096: AND di.agreement_id = p_agreement_id

Line 7125: FROM pa_draft_invoice_items dii,

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

Line 7149: FROM pa_draft_invoice_items dii,

7145: dii.task_id,
7146: sum(dii.amount) amount,
7147: sum(dii.projfunc_bill_amount) projfunc_bill_amount,
7148: sum(dii.funding_bill_amount) funding_bill_amount
7149: FROM pa_draft_invoice_items dii,
7150: pa_draft_invoices di
7151: WHERE di.project_id = p_project_id
7152: AND di.agreement_id = p_agreement_id
7153: AND dii.project_id = di.project_id

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

7161: dii.task_id,
7162: sum(dii.amount) amount,
7163: sum(dii_mc.amount) projfunc_bill_amount,
7164: sum(dii.funding_bill_amount) funding_bill_amount
7165: FROM pa_mc_draft_inv_items dii_mc, pa_draft_invoice_items dii, pa_draft_invoices di,
7166: gl_alc_ledger_rships_v rep, pa_implementations imp
7167: WHERE di.project_id = p_project_id
7168: AND di.agreement_id = p_agreement_id
7169: AND dii.project_id = di.project_id