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_INVOICES

Line 952: FROM pa_draft_invoices i

948:
949: SELECT 'T' INTO x_exist_flag
950: FROM DUAL
951: WHERE EXISTS ( SELECT NULL
952: FROM pa_draft_invoices i
953: WHERE i.project_id = p_project_id
954: and i.released_by_person_id IS NULL);
955:
956: x_exist_flag := 'T';

Line 2520: pa_draft_invoices di

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'
2524: AND dii.project_id = di.project_id

Line 2557: pa_draft_invoices di

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'
2561: AND dii.project_id = di.project_id

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 3300: pa_draft_invoices di

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
3304: AND dii.draft_invoice_num = di.draft_invoice_num

Line 3334: pa_draft_invoices di

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
3338: AND dii.draft_invoice_num = di.draft_invoice_num

Line 3377: pa_draft_invoices di

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
3381: AND dii.draft_invoice_num = di.draft_invoice_num

Line 3414: pa_draft_invoices di

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
3418: AND dii.draft_invoice_num = di.draft_invoice_num

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 3584: pa_draft_invoices di

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
3588: AND dii.draft_invoice_num = di.draft_invoice_num

Line 3619: pa_draft_invoices di

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
3623: AND NVL(dii.task_id,0) <> 0

Line 3670: pa_draft_invoices di

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
3674: AND dii.draft_invoice_num = di.draft_invoice_num

Line 3704: pa_draft_invoices di

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
3708: AND NVL(dii.task_id,0) <> 0

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 6148: pa_draft_invoices DI

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
6152: AND DI.draft_invoice_num = DII.draft_invoice_num

Line 6201: pa_draft_invoices DI

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
6205: AND DI.draft_invoice_num = DII.draft_invoice_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 7055: pa_draft_invoices di

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
7059: AND dii.draft_invoice_num = di.draft_invoice_num

Line 7078: pa_draft_invoices di

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
7082: AND dii.draft_invoice_num = di.draft_invoice_num

Line 7093: pa_draft_invoices di,

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
7097: AND dii.project_id = di.project_id

Line 7126: pa_draft_invoices di

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
7130: AND dii.draft_invoice_num = di.draft_invoice_num

Line 7150: pa_draft_invoices di

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
7154: AND dii.draft_invoice_num = di.draft_invoice_num

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