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 3606: FROM pa_expenditures_all exp,

3602: stage := 200;
3603:
3604: SELECT incurred_by_organization_id
3605: INTO organization_id
3606: FROM pa_expenditures_all exp,
3607: pa_expenditure_items_all exp_item
3608: WHERE exp_item.expenditure_item_id = exp_item_id
3609: AND exp_item.expenditure_id = exp.expenditure_id
3610: AND ( (exp_item.org_id is null) or (exp_item.org_id = exp.org_id));

Line 4357: FROM pa_expenditures_all exp

4353: /*3055700 :Added this exist clause for bug# 3016281 :to mark selectively if explicit multipliers
4354: are defined for an org for all the cost codes */
4355: /* 4527736
4356: AND exists (SELECT NULL
4357: FROM pa_expenditures_all exp
4358: ,pa_ind_compiled_sets ics
4359: WHERE exp.expenditure_id = ITEM.expenditure_id
4360: AND ((ics.ind_compiled_set_id = ITEM.cost_ind_compiled_set_id)
4361: or (ics.ind_compiled_set_id = ITEM.tp_ind_compiled_set_id))

Line 4369: FROM PA_EXPENDITURES_ALL EXP

4365: 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))
4366: ,pa_cost_plus.check_for_explicit_multiplier(rate_sch_rev_id,ics.organization_id ))=0 -- Bug# 3134445 and Bug 3938479
4367: ) */
4368: AND EXISTS ((SELECT /*+ PUSH_SUBQ NO_UNNEST */ 1
4369: FROM PA_EXPENDITURES_ALL EXP
4370: ,PA_IND_COMPILED_SETS ICS
4371: WHERE EXP.EXPENDITURE_ID = ITEM.EXPENDITURE_ID
4372: AND (ICS.IND_COMPILED_SET_ID = ITEM.COST_IND_COMPILED_SET_ID)
4373: AND NVL(ITEM.OVERRIDE_TO_ORGANIZATION_ID, EXP.INCURRED_BY_ORGANIZATION_ID) =ICS.ORGANIZATION_ID

Line 4381: FROM PA_EXPENDITURES_ALL EXP

4377: , PA_COST_PLUS.CHECK_FOR_EXPLICIT_MULTIPLIER(rate_sch_rev_id ,ICS.ORGANIZATION_ID))
4378: , PA_COST_PLUS.CHECK_FOR_EXPLICIT_MULTIPLIER(rate_sch_rev_id ,ICS.ORGANIZATION_ID ))=0
4379: )
4380: UNION ALL (SELECT /*+ PUSH_SUBQ NO_UNNEST */ 1
4381: FROM PA_EXPENDITURES_ALL EXP
4382: ,PA_IND_COMPILED_SETS ICS
4383: WHERE EXP.EXPENDITURE_ID = ITEM.EXPENDITURE_ID
4384: AND (ICS.IND_COMPILED_SET_ID = ITEM.TP_IND_COMPILED_SET_ID)
4385: AND NVL(ITEM.OVERRIDE_TO_ORGANIZATION_ID, EXP.INCURRED_BY_ORGANIZATION_ID) =ICS.ORGANIZATION_ID

Line 4569: FROM pa_expenditures_all exp

4565: AND cbet.expenditure_type = ITEM.expenditure_type
4566: )
4567: /*Bug# 3055700 ::Added this exist clause back for bug# 3016281*/
4568: AND exists (SELECT NULL
4569: FROM pa_expenditures_all exp
4570: ,pa_ind_compiled_sets ics
4571: WHERE exp.expenditure_id = ITEM.expenditure_id
4572: AND ((ics.ind_compiled_set_id = ITEM.cost_ind_compiled_set_id)
4573: or (ics.ind_compiled_set_id = ITEM.tp_ind_compiled_set_id))

Line 4659: FROM pa_expenditures_all exp

4655: and cbet.expenditure_type = ITEM.expenditure_type
4656: )
4657: /*Bug# 3055700 : Added this exist clause back for bug# 3016281*/
4658: AND EXISTS (SELECT /*+ index(ics PA_IND_COMPILED_SETS_N6) */ NULL /*Added index hint for Bug 5683523 */
4659: FROM pa_expenditures_all exp
4660: ,pa_ind_compiled_sets ics
4661: WHERE exp.expenditure_id = ITEM.expenditure_id
4662: AND ((ics.ind_compiled_set_id = ITEM.rev_ind_compiled_set_id)
4663: or (ics.ind_compiled_set_id = ITEM.inv_ind_compiled_set_id))