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_COST_PLUS dependencies on PA_EXPENDITURES_ALL

Line 3576: FROM pa_expenditures_all exp,

3572: stage := 200;
3573:
3574: SELECT incurred_by_organization_id
3575: INTO organization_id
3576: FROM pa_expenditures_all exp,
3577: pa_expenditure_items_all exp_item
3578: WHERE exp_item.expenditure_item_id = exp_item_id
3579: AND exp_item.expenditure_id = exp.expenditure_id
3580: AND ( (exp_item.org_id is null) or (exp_item.org_id = exp.org_id));

Line 4327: FROM pa_expenditures_all exp

4323: /*3055700 :Added this exist clause for bug# 3016281 :to mark selectively if explicit multipliers
4324: are defined for an org for all the cost codes */
4325: /* 4527736
4326: AND exists (SELECT NULL
4327: FROM pa_expenditures_all exp
4328: ,pa_ind_compiled_sets ics
4329: WHERE exp.expenditure_id = ITEM.expenditure_id
4330: AND ((ics.ind_compiled_set_id = ITEM.cost_ind_compiled_set_id)
4331: or (ics.ind_compiled_set_id = ITEM.tp_ind_compiled_set_id))

Line 4339: FROM PA_EXPENDITURES_ALL EXP

4335: AND decode(rate_sch_rev_id,g_rate_sch_rev_id,decode(ics.organization_id,g_org_id,g_org_override,pa_cost_plus.check_for_explicit_multiplier(rate_sch_rev_id,ics.organization_id))
4336: ,pa_cost_plus.check_for_explicit_multiplier(rate_sch_rev_id,ics.organization_id ))=0 -- Bug# 3134445 and Bug 3938479
4337: ) */
4338: AND EXISTS ((SELECT NULL
4339: FROM PA_EXPENDITURES_ALL EXP
4340: ,PA_IND_COMPILED_SETS ICS
4341: WHERE EXP.EXPENDITURE_ID = ITEM.EXPENDITURE_ID
4342: AND (ICS.IND_COMPILED_SET_ID = ITEM.COST_IND_COMPILED_SET_ID)
4343: AND NVL(ITEM.OVERRIDE_TO_ORGANIZATION_ID, EXP.INCURRED_BY_ORGANIZATION_ID) =ICS.ORGANIZATION_ID

Line 4351: FROM PA_EXPENDITURES_ALL EXP

4347: , PA_COST_PLUS.CHECK_FOR_EXPLICIT_MULTIPLIER(rate_sch_rev_id ,ICS.ORGANIZATION_ID))
4348: , PA_COST_PLUS.CHECK_FOR_EXPLICIT_MULTIPLIER(rate_sch_rev_id ,ICS.ORGANIZATION_ID ))=0
4349: )
4350: UNION ALL (SELECT NULL
4351: FROM PA_EXPENDITURES_ALL EXP
4352: ,PA_IND_COMPILED_SETS ICS
4353: WHERE EXP.EXPENDITURE_ID = ITEM.EXPENDITURE_ID
4354: AND (ICS.IND_COMPILED_SET_ID = ITEM.TP_IND_COMPILED_SET_ID)
4355: AND NVL(ITEM.OVERRIDE_TO_ORGANIZATION_ID, EXP.INCURRED_BY_ORGANIZATION_ID) =ICS.ORGANIZATION_ID

Line 4539: FROM pa_expenditures_all exp

4535: AND cbet.expenditure_type = ITEM.expenditure_type
4536: )
4537: /*Bug# 3055700 ::Added this exist clause back for bug# 3016281*/
4538: AND exists (SELECT NULL
4539: FROM pa_expenditures_all exp
4540: ,pa_ind_compiled_sets ics
4541: WHERE exp.expenditure_id = ITEM.expenditure_id
4542: AND ((ics.ind_compiled_set_id = ITEM.cost_ind_compiled_set_id)
4543: or (ics.ind_compiled_set_id = ITEM.tp_ind_compiled_set_id))

Line 4629: FROM pa_expenditures_all exp

4625: and cbet.expenditure_type = ITEM.expenditure_type
4626: )
4627: /*Bug# 3055700 : Added this exist clause back for bug# 3016281*/
4628: AND EXISTS (SELECT /*+ index(ics PA_IND_COMPILED_SETS_N6) */ NULL /*Added index hint for Bug 5683523 */
4629: FROM pa_expenditures_all exp
4630: ,pa_ind_compiled_sets ics
4631: WHERE exp.expenditure_id = ITEM.expenditure_id
4632: AND ((ics.ind_compiled_set_id = ITEM.rev_ind_compiled_set_id)
4633: or (ics.ind_compiled_set_id = ITEM.inv_ind_compiled_set_id))