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

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

Line 2555: pa_draft_invoices di

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

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

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

Line 3331: pa_draft_invoices di

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

Line 3373: pa_draft_invoices di

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

Line 3410: pa_draft_invoices di

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

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

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

Line 3614: pa_draft_invoices di

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

Line 3664: pa_draft_invoices di

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

Line 3698: pa_draft_invoices di

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

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

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

Line 7057: pa_draft_invoices di

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

Line 7072: pa_draft_invoices di,

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

Line 7105: pa_draft_invoices di

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

Line 7128: pa_draft_invoices di

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

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