APPS.OZF_UTILITY_PVT dependencies on OZF_FUNDS_UTILIZED_ALL_B

Line 3338: FROM ozf_funds_utilized_all_b uti, ozf_act_budgets act

3334: /*
3335: SELECT SUM(AMOUNT)
3336: FROM(
3337: SELECT uti.plan_curr_amount amount
3338: FROM ozf_funds_utilized_all_b uti, ozf_act_budgets act
3339: WHERE uti.utilization_type ='REQUEST'
3340: AND component_type = 'OFFR'
3341: AND component_id = list_header_id
3342: AND act.activity_budget_id = uti.ams_activity_budget_id

Line 3346: FROM ozf_funds_utilized_all_b uti, ozf_act_budgets act

3342: AND act.activity_budget_id = uti.ams_activity_budget_id
3343: AND act.recal_flag is NULL
3344: UNION ALL
3345: SELECT 0-uti.plan_curr_amount amount
3346: FROM ozf_funds_utilized_all_b uti, ozf_act_budgets act
3347: WHERE uti.utilization_type ='TRANSFER'
3348: AND plan_type = 'OFFR'
3349: AND plan_id = list_header_id
3350: AND act.activity_budget_id = uti.ams_activity_budget_id

Line 3389: FROM ozf_funds_utilized_all_b uti

3385: /*
3386: SELECT SUM(AMOUNT)
3387: FROM(
3388: SELECT uti.plan_curr_amount amount
3389: FROM ozf_funds_utilized_all_b uti
3390: WHERE uti.utilization_type ='REQUEST'
3391: AND component_type = 'OFFR'
3392: AND component_id = list_header_id
3393: UNION ALL

Line 3395: FROM ozf_funds_utilized_all_b uti

3391: AND component_type = 'OFFR'
3392: AND component_id = list_header_id
3393: UNION ALL
3394: SELECT 0-uti.plan_curr_amount amount
3395: FROM ozf_funds_utilized_all_b uti
3396: WHERE uti.utilization_type ='TRANSFER'
3397: AND plan_type = 'OFFR'
3398: AND plan_id = list_header_id);
3399: */

Line 3509: FROM ozf_funds_utilized_all_b util

3505: /*
3506:
3507: SELECT SUM(AMOUNT) FROM
3508: (SELECT SUM(plan_curr_amount - NVL(plan_curr_amount_remaining,0)) amount
3509: FROM ozf_funds_utilized_all_b util
3510: WHERE utilization_type = 'UTILIZED'
3511: AND NVL(util.gl_posted_flag,'Y') = 'Y'
3512: AND plan_type = 'OFFR'
3513: AND plan_id = list_header_id

Line 3516: FROM ozf_funds_utilized_all_b util,

3512: AND plan_type = 'OFFR'
3513: AND plan_id = list_header_id
3514: UNION AlL
3515: SELECT cuti.plan_curr_amount amount
3516: FROM ozf_funds_utilized_all_b util,
3517: ozf_claim_lines_util_all cuti,
3518: ozf_claim_lines_all cln,
3519: ozf_claims_all cla
3520: WHERE util.utilization_id(+) = cuti.utilization_id

Line 3625: FROM ozf_funds_utilized_all_b fu ,

3621: AND org_id = p_org_id;
3622:
3623: CURSOR get_revenue_acct_csr1 IS
3624: SELECT cgl.code_combination_id
3625: FROM ozf_funds_utilized_all_b fu ,
3626: oe_price_adjustments pa ,
3627: oe_order_lines_all ol ,
3628: oe_order_headers_all oh ,
3629: ra_customer_trx_lines_all ctl ,

Line 3644: FROM ozf_funds_utilized_all_b fu ,

3640: AND fu.order_line_id = ctl.interface_line_attribute6;
3641:
3642: CURSOR get_revenue_acct_csr2 IS
3643: SELECT cgl.code_combination_id
3644: FROM ozf_funds_utilized_all_b fu ,
3645: oe_price_adjustments pa ,
3646: oe_order_lines_all ol ,
3647: oe_order_headers_all oh ,
3648: ra_customer_trx_lines_all ctl ,