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_EXPENDITURE_ITEMS_ALL

Line 1647: quantity pa_expenditure_items_all.quantity%TYPE;

1643: l_denom_currency_code VARCHAR2(15);
1644: l_acct_currency_code VARCHAR2(15);
1645: l_project_currency_code VARCHAR2(15);
1646: l_projfunc_currency_code VARCHAR2(15);
1647: quantity pa_expenditure_items_all.quantity%TYPE;
1648: burden_cost pa_expenditure_items_all.burden_cost%TYPE;
1649: burden_cost_denom pa_expenditure_items_all.denom_burdened_cost%TYPE;
1650: burden_cost_acct pa_expenditure_items_all.acct_burdened_cost%TYPE;
1651: burden_cost_project pa_expenditure_items_all.project_burdened_cost%TYPE; /* ProjCurr Changes */

Line 1648: burden_cost pa_expenditure_items_all.burden_cost%TYPE;

1644: l_acct_currency_code VARCHAR2(15);
1645: l_project_currency_code VARCHAR2(15);
1646: l_projfunc_currency_code VARCHAR2(15);
1647: quantity pa_expenditure_items_all.quantity%TYPE;
1648: burden_cost pa_expenditure_items_all.burden_cost%TYPE;
1649: burden_cost_denom pa_expenditure_items_all.denom_burdened_cost%TYPE;
1650: burden_cost_acct pa_expenditure_items_all.acct_burdened_cost%TYPE;
1651: burden_cost_project pa_expenditure_items_all.project_burdened_cost%TYPE; /* ProjCurr Changes */
1652: system_linkage pa_expenditure_items_all.system_linkage_function%TYPE;

Line 1649: burden_cost_denom pa_expenditure_items_all.denom_burdened_cost%TYPE;

1645: l_project_currency_code VARCHAR2(15);
1646: l_projfunc_currency_code VARCHAR2(15);
1647: quantity pa_expenditure_items_all.quantity%TYPE;
1648: burden_cost pa_expenditure_items_all.burden_cost%TYPE;
1649: burden_cost_denom pa_expenditure_items_all.denom_burdened_cost%TYPE;
1650: burden_cost_acct pa_expenditure_items_all.acct_burdened_cost%TYPE;
1651: burden_cost_project pa_expenditure_items_all.project_burdened_cost%TYPE; /* ProjCurr Changes */
1652: system_linkage pa_expenditure_items_all.system_linkage_function%TYPE;
1653: compiled_multiplier pa_compiled_multipliers.compiled_multiplier%TYPE;

Line 1650: burden_cost_acct pa_expenditure_items_all.acct_burdened_cost%TYPE;

1646: l_projfunc_currency_code VARCHAR2(15);
1647: quantity pa_expenditure_items_all.quantity%TYPE;
1648: burden_cost pa_expenditure_items_all.burden_cost%TYPE;
1649: burden_cost_denom pa_expenditure_items_all.denom_burdened_cost%TYPE;
1650: burden_cost_acct pa_expenditure_items_all.acct_burdened_cost%TYPE;
1651: burden_cost_project pa_expenditure_items_all.project_burdened_cost%TYPE; /* ProjCurr Changes */
1652: system_linkage pa_expenditure_items_all.system_linkage_function%TYPE;
1653: compiled_multiplier pa_compiled_multipliers.compiled_multiplier%TYPE;
1654:

Line 1651: burden_cost_project pa_expenditure_items_all.project_burdened_cost%TYPE; /* ProjCurr Changes */

1647: quantity pa_expenditure_items_all.quantity%TYPE;
1648: burden_cost pa_expenditure_items_all.burden_cost%TYPE;
1649: burden_cost_denom pa_expenditure_items_all.denom_burdened_cost%TYPE;
1650: burden_cost_acct pa_expenditure_items_all.acct_burdened_cost%TYPE;
1651: burden_cost_project pa_expenditure_items_all.project_burdened_cost%TYPE; /* ProjCurr Changes */
1652: system_linkage pa_expenditure_items_all.system_linkage_function%TYPE;
1653: compiled_multiplier pa_compiled_multipliers.compiled_multiplier%TYPE;
1654:
1655: BEGIN

Line 1652: system_linkage pa_expenditure_items_all.system_linkage_function%TYPE;

1648: burden_cost pa_expenditure_items_all.burden_cost%TYPE;
1649: burden_cost_denom pa_expenditure_items_all.denom_burdened_cost%TYPE;
1650: burden_cost_acct pa_expenditure_items_all.acct_burdened_cost%TYPE;
1651: burden_cost_project pa_expenditure_items_all.project_burdened_cost%TYPE; /* ProjCurr Changes */
1652: system_linkage pa_expenditure_items_all.system_linkage_function%TYPE;
1653: compiled_multiplier pa_compiled_multipliers.compiled_multiplier%TYPE;
1654:
1655: BEGIN
1656:

Line 1706: FROM pa_expenditure_items_all

1702: l_acct_currency_code,
1703: l_denom_currency_code,
1704: l_project_currency_code,
1705: system_linkage
1706: FROM pa_expenditure_items_all
1707: WHERE expenditure_item_id = exp_item_id;
1708:
1709: -- For Project Manufacturing, specifically BURDEN_TRANSACTIONS, raw_cost,
1710: -- quantity will be zero but burden_cost will not be zero

Line 2085: FROM pa_expenditure_items_all

2081: -1 * Denom_Burdened_Cost,
2082: -1 * Acct_Burdened_Cost ,
2083: -1 * Project_burdened_Cost,
2084: Burden_Cost_Rate
2085: FROM pa_expenditure_items_all
2086: WHERE expenditure_item_id = p_exp_item_id
2087: AND Denom_Raw_Cost = -1 * p_denom_raw_cost
2088: AND Denom_Burdened_Cost IS NOT NULL
2089: AND Acct_Burdened_Cost IS NOT NULL

Line 3405: FROM pa_expenditure_items_all

3401: SELECT task_id,
3402: expenditure_item_date
3403: INTO t_id,
3404: exp_item_date
3405: FROM pa_expenditure_items_all
3406: WHERE expenditure_item_id = exp_item_id;
3407:
3408: --
3409: -- Get the indirect rate schedule

Line 3565: FROM pa_expenditure_items_all

3561: -- oriented process, hence the uderlying select uses base table.
3562:
3563: SELECT override_to_organization_id
3564: INTO organization_id
3565: FROM pa_expenditure_items_all
3566: WHERE expenditure_item_id = exp_item_id;
3567:
3568: IF organization_id IS NULL THEN
3569: --

Line 3577: pa_expenditure_items_all exp_item

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));
3581:

Line 3798: -- pa_expenditure_items_all ITEM

3794:
3795: --S.O. /*Bug 4527736 */
3796: -- SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS
3797: -- (SELECT 1 FROM pa_ind_compiled_sets ICS, /* Removed Hint NO_INDEX(ITEM PA_EXPENDITURE_ITEMS_N13) */
3798: -- pa_expenditure_items_all ITEM
3799: -- WHERE
3800: -- ICS.ind_rate_sch_revision_id = rate_sch_rev_id
3801: -- AND ( (ICS.ind_compiled_set_id = ITEM.cost_ind_compiled_set_id)
3802: -- OR (ICS.ind_compiled_set_id = ITEM.rev_ind_compiled_set_id)

Line 3814: FROM PA_EXPENDITURE_ITEMS_ALL ITEM

3810: FROM PA_IND_COMPILED_SETS ICS
3811: WHERE ICS.IND_RATE_SCH_REVISION_ID = rate_sch_rev_id
3812: AND EXISTS
3813: (SELECT ITEM.COST_IND_COMPILED_SET_ID
3814: FROM PA_EXPENDITURE_ITEMS_ALL ITEM
3815: WHERE ICS.IND_COMPILED_SET_ID = ITEM.COST_IND_COMPILED_SET_ID
3816: UNION ALL
3817: SELECT ITEM.REV_IND_COMPILED_SET_ID
3818: FROM PA_EXPENDITURE_ITEMS_ALL ITEM

Line 3818: FROM PA_EXPENDITURE_ITEMS_ALL ITEM

3814: FROM PA_EXPENDITURE_ITEMS_ALL ITEM
3815: WHERE ICS.IND_COMPILED_SET_ID = ITEM.COST_IND_COMPILED_SET_ID
3816: UNION ALL
3817: SELECT ITEM.REV_IND_COMPILED_SET_ID
3818: FROM PA_EXPENDITURE_ITEMS_ALL ITEM
3819: WHERE ICS.IND_COMPILED_SET_ID = ITEM.REV_IND_COMPILED_SET_ID
3820: UNION ALL
3821: SELECT ITEM.TP_IND_COMPILED_SET_ID
3822: FROM PA_EXPENDITURE_ITEMS_ALL ITEM

Line 3822: FROM PA_EXPENDITURE_ITEMS_ALL ITEM

3818: FROM PA_EXPENDITURE_ITEMS_ALL ITEM
3819: WHERE ICS.IND_COMPILED_SET_ID = ITEM.REV_IND_COMPILED_SET_ID
3820: UNION ALL
3821: SELECT ITEM.TP_IND_COMPILED_SET_ID
3822: FROM PA_EXPENDITURE_ITEMS_ALL ITEM
3823: WHERE ICS.IND_COMPILED_SET_ID = ITEM.TP_IND_COMPILED_SET_ID
3824: UNION ALL
3825: SELECT ITEM.INV_IND_COMPILED_SET_ID
3826: FROM PA_EXPENDITURE_ITEMS_ALL ITEM

Line 3826: FROM PA_EXPENDITURE_ITEMS_ALL ITEM

3822: FROM PA_EXPENDITURE_ITEMS_ALL ITEM
3823: WHERE ICS.IND_COMPILED_SET_ID = ITEM.TP_IND_COMPILED_SET_ID
3824: UNION ALL
3825: SELECT ITEM.INV_IND_COMPILED_SET_ID
3826: FROM PA_EXPENDITURE_ITEMS_ALL ITEM
3827: WHERE ICS.IND_COMPILED_SET_ID = ITEM.INV_IND_COMPILED_SET_ID
3828: )
3829: );
3830: --E.N. /*Bug 4527736 */

Line 4219: UPDATE pa_expenditure_items_all ITEM

4215: G_EXPENDITURE_ITEM_ID_TAB.DELETE; /*4456789*/
4216: G_ADJ_TYPE_TAB.DELETE; /*4456789*/
4217:
4218: stage := 100;
4219: UPDATE pa_expenditure_items_all ITEM
4220: SET ITEM.cost_distributed_flag =
4221: DECODE(ITEM.cost_distributed_flag, 'Y',
4222: decode(ITEM.cost_ind_compiled_set_id, cs1_row.ind_compiled_set_id,
4223: 'N',ITEM.cost_distributed_flag), ITEM.cost_distributed_flag),

Line 4418: UPDATE pa_expenditure_items_all ITEM

4414:
4415: G_EXPENDITURE_ITEM_ID_TAB.DELETE; /*4527736*/
4416: G_ADJ_TYPE_TAB.DELETE; /*4527736*/
4417:
4418: UPDATE pa_expenditure_items_all ITEM
4419: SET ITEM.last_update_date = SYSDATE,
4420: ITEM.last_updated_by = x_last_updated_by,
4421: ITEM.last_update_login = x_last_update_login,
4422: ITEM.request_id = x_request_id,

Line 4605: UPDATE pa_expenditure_items_all ITEM

4601:
4602: G_EXPENDITURE_ITEM_ID_TAB.DELETE; /*4527736*/
4603: G_ADJ_TYPE_TAB.DELETE; /*4527736*/
4604:
4605: UPDATE pa_expenditure_items_all ITEM
4606: SET ITEM.revenue_distributed_flag = 'N',
4607: ITEM.last_update_date = SYSDATE,
4608: ITEM.last_updated_by = x_last_updated_by,
4609: ITEM.last_update_login = x_last_update_login,

Line 4811: -- PA_EXPENDITURE_ITEMS_ALL instead of PA_EXPENDITURE_ITEMS to support

4807:
4808: -- Cursor definition
4809:
4810: -- The following cursor definitions were changed to select from
4811: -- PA_EXPENDITURE_ITEMS_ALL instead of PA_EXPENDITURE_ITEMS to support
4812: -- a multi-org implementation where expenditure items may span across
4813: -- operating units.
4814:
4815: -- Modifying the statement to exclude closed project items as well as

Line 4824: FROM pa_expenditure_items_all ei

4820: --
4821: CURSOR ei1_cursor
4822: IS
4823: SELECT expenditure_item_id
4824: FROM pa_expenditure_items_all ei
4825: WHERE cost_ind_compiled_set_id = compiled_set_id
4826: AND EXISTS
4827: (SELECT task_id
4828: FROM pa_tasks task

Line 4846: FROM pa_expenditure_items_all ei

4842:
4843: CURSOR ei2_cursor
4844: IS
4845: SELECT expenditure_item_id
4846: FROM pa_expenditure_items_all ei
4847: WHERE rev_ind_compiled_set_id = compiled_set_id
4848: AND EXISTS
4849: (SELECT task_id
4850: FROM pa_tasks task

Line 4868: FROM pa_expenditure_items_all ei

4864:
4865: CURSOR ei3_cursor
4866: IS
4867: SELECT expenditure_item_id
4868: FROM pa_expenditure_items_all ei
4869: WHERE inv_ind_compiled_set_id = compiled_set_id
4870: AND EXISTS
4871: (SELECT task_id
4872: FROM pa_tasks task

Line 4891: FROM pa_expenditure_items_all ei

4887:
4888: CURSOR ei4_cursor
4889: IS
4890: SELECT expenditure_item_id
4891: FROM pa_expenditure_items_all ei
4892: WHERE cost_ind_compiled_set_id = compiled_set_id
4893: AND expenditure_item_date BETWEEN --Bug 5917245 Removed TRUNC
4894: l_start_date AND
4895: NVL(l_end_date, expenditure_item_date)

Line 4915: FROM pa_expenditure_items_all ei

4911:
4912: CURSOR ei5_cursor
4913: IS
4914: SELECT expenditure_item_id
4915: FROM pa_expenditure_items_all ei
4916: WHERE rev_ind_compiled_set_id = compiled_set_id
4917: AND expenditure_item_date BETWEEN --Bug 5917245 Removed TRUNC
4918: l_start_date AND
4919: NVL(l_end_date, expenditure_item_date)

Line 4939: FROM pa_expenditure_items_all ei

4935:
4936: CURSOR ei6_cursor
4937: IS
4938: SELECT expenditure_item_id
4939: FROM pa_expenditure_items_all ei
4940: WHERE inv_ind_compiled_set_id = compiled_set_id
4941: AND expenditure_item_date BETWEEN --Bug 5917245 Removed TRUNC
4942: l_start_date AND
4943: NVL(l_end_date, expenditure_item_date)

Line 4963: FROM pa_expenditure_items_all ei

4959:
4960: CURSOR ei7_cursor
4961: IS
4962: SELECT expenditure_item_id
4963: FROM pa_expenditure_items_all ei
4964: WHERE cost_ind_compiled_set_id = compiled_set_id
4965: AND expenditure_item_date BETWEEN --Bug 5917245 removed TRUNC
4966: l_start_date AND NVL(l_end_date, expenditure_item_date)
4967: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'

Line 4980: FROM pa_expenditure_items_all ei

4976:
4977: CURSOR ei8_cursor
4978: IS
4979: SELECT expenditure_item_id
4980: FROM pa_expenditure_items_all ei
4981: WHERE rev_ind_compiled_set_id = compiled_set_id
4982: AND expenditure_item_date BETWEEN --Bug 5917245 Removed TRUNC
4983: l_start_date AND
4984: NVL(l_end_date, expenditure_item_date)

Line 4998: FROM pa_expenditure_items_all ei

4994:
4995: CURSOR ei9_cursor
4996: IS
4997: SELECT expenditure_item_id
4998: FROM pa_expenditure_items_all ei
4999: WHERE inv_ind_compiled_set_id = compiled_set_id
5000: AND expenditure_item_date BETWEEN --Bug 5917245 Removed TRUNC
5001: l_start_date AND
5002: NVL(l_end_date, expenditure_item_date)

Line 5016: FROM pa_expenditure_items_all ei

5012:
5013: CURSOR ei10_cursor
5014: IS
5015: SELECT expenditure_item_id
5016: FROM pa_expenditure_items_all ei
5017: WHERE cost_ind_compiled_set_id = compiled_set_id
5018: AND EXISTS
5019: (SELECT t1.task_id
5020: FROM pa_project_types_all pt,

Line 5046: FROM pa_expenditure_items_all ei

5042:
5043: CURSOR ei11_cursor
5044: IS
5045: SELECT expenditure_item_id
5046: FROM pa_expenditure_items_all ei
5047: WHERE cost_ind_compiled_set_id = compiled_set_id
5048: AND expenditure_item_date BETWEEN --Bug 5917245 Removed TRUNC
5049: l_start_date AND
5050: NVL(l_end_date, expenditure_item_date)

Line 5077: FROM pa_expenditure_items_all ei

5073:
5074: CURSOR ei12_cursor
5075: IS
5076: SELECT expenditure_item_id
5077: FROM pa_expenditure_items_all ei
5078: WHERE cost_ind_compiled_set_id = compiled_set_id
5079: AND expenditure_item_date BETWEEN --Bug 5917245 Removed TRUNC
5080: l_start_date AND
5081: NVL(l_end_date, expenditure_item_date)

Line 5117: FROM pa_expenditure_items_all ei,

5113: /*
5114: CURSOR ei13_cursor
5115: IS
5116: SELECT expenditure_item_id
5117: FROM pa_expenditure_items_all ei,
5118: pa_system_linkages syslink,
5119: pa_tasks task,
5120: pa_projects_all proj
5121: WHERE ei.tp_ind_compiled_set_id = compiled_set_id

Line 5145: FROM PA_EXPENDITURE_ITEMS_ALL EI

5141: /*Bug# 2164590:Changed ei13_cursor for performance*/
5142: CURSOR ei13_cursor
5143: IS
5144: SELECT EXPENDITURE_ITEM_ID
5145: FROM PA_EXPENDITURE_ITEMS_ALL EI
5146: WHERE tp_ind_compiled_set_id = compiled_set_id
5147: AND EXISTS
5148: (SELECT task_id
5149: FROM pa_tasks task, pa_system_linkages syslink /*2933915 : ,pa_projects_all proj :Join with pa_projects is not required here */

Line 5170: FROM pa_expenditure_items_all ei

5166:
5167: CURSOR ei14_cursor
5168: IS
5169: SELECT expenditure_item_id
5170: FROM pa_expenditure_items_all ei
5171: /* pa_tasks task -- Commented for Bug#3585192 */
5172: /* pa_projects_all proj :2933915 :Redundant join and hence can be removed */
5173: WHERE tp_ind_compiled_set_id = compiled_set_id
5174: AND ei.expenditure_item_date BETWEEN --Bug 5917245 Removed TRUNC

Line 5260: UPDATE pa_expenditure_items_all ei

5256: /***Bug 2933915 : Added the exists clause in this update to indicate that except profile ='Y' and display_method ='D' -for all
5257: cases we will be marking ei for cost reprocessing */
5258: /*If Burdening is on same ei then update adjustment_type as BURDEN_COMPILE else update it as BURDEN_RESUMMARIZE .*/
5259:
5260: UPDATE pa_expenditure_items_all ei
5261: SET cost_distributed_flag = 'N',
5262: adjustment_type ='BURDEN_RECOMPILE', /*2933915*/
5263: cost_burden_distributed_flag = 'N',
5264: last_update_date = SYSDATE,

Line 5353: UPDATE pa_expenditure_items_all ei

5349: -- (09/17/98)
5350: --
5351: -- Added Nvl for net_zero_adjustment_flag (896190)
5352: --
5353: UPDATE pa_expenditure_items_all ei
5354: SET revenue_distributed_flag = 'N',
5355: last_update_date = SYSDATE,
5356: last_updated_by = x_last_updated_by,
5357: last_update_login = x_last_update_login,

Line 5421: UPDATE pa_expenditure_items_all ei

5417: --
5418: -- Added Nvl for net_zero_adjustment_flag (896190)
5419: --
5420:
5421: UPDATE pa_expenditure_items_all ei
5422: SET revenue_distributed_flag = 'N',
5423: last_update_date = SYSDATE,
5424: last_updated_by = x_last_updated_by,
5425: last_update_login = x_last_update_login,

Line 5487: UPDATE pa_expenditure_items_all ei

5483: -- Section For Capital Projects
5484: --
5485: -- This section is added as a part of fix for bug 897479.
5486: --
5487: UPDATE pa_expenditure_items_all ei
5488: SET revenue_distributed_flag = 'N',
5489: last_update_date = SYSDATE,
5490: last_updated_by = x_last_updated_by,
5491: last_update_login = x_last_update_login,

Line 5573: UPDATE pa_expenditure_items_all ei

5569: --
5570: -- Added Nvl for net_zero_adjustment_flag (896190)
5571: -- ---------------------------------------------------------------------
5572: /* Updating Project_Burdened_Cost also for Bug 2736773 */
5573: UPDATE pa_expenditure_items_all ei
5574: SET cost_distributed_flag = 'N' ,
5575: adjustment_type ='BURDEN_RECOMPILE', /*2933915*/
5576: cost_burden_distributed_flag = 'N',
5577: last_update_date = SYSDATE,

Line 5664: UPDATE pa_expenditure_items_all ei

5660: --
5661: -- Added Nvl for net_zero_adjustment_flag (896190)
5662: --
5663:
5664: UPDATE pa_expenditure_items_all ei
5665: SET revenue_distributed_flag = 'N',
5666: last_update_date = SYSDATE,
5667: last_updated_by = x_last_updated_by,
5668: last_update_login = x_last_update_login,

Line 5732: UPDATE pa_expenditure_items_all ei

5728: -- (09/17/98)
5729: --
5730: -- Added Nvl for net_zero_adjustment_flag (896190)
5731: --
5732: UPDATE pa_expenditure_items_all ei
5733: SET revenue_distributed_flag = 'N',
5734: last_update_date = SYSDATE,
5735: last_updated_by = x_last_updated_by,
5736: last_update_login = x_last_update_login,

Line 5801: UPDATE pa_expenditure_items_all ei

5797: --
5798: -- This section has been added as a part of bug 897479.
5799: --
5800: --
5801: UPDATE pa_expenditure_items_all ei
5802: SET revenue_distributed_flag = 'N',
5803: last_update_date = SYSDATE,
5804: last_updated_by = x_last_updated_by,
5805: last_update_login = x_last_update_login,

Line 5883: UPDATE pa_expenditure_items_all ei

5879: /*
5880: * Bug 4885396 : Moved 3 EI based checks from Exists subquery to the
5881: * main query.
5882: */
5883: UPDATE pa_expenditure_items_all ei
5884: SET cc_bl_distributed_code =
5885: decode( cc_cross_charge_code,'B',
5886: 'N',
5887: cc_bl_distributed_code),

Line 5986: UPDATE pa_expenditure_items_all ei

5982: --
5983: -- Added Nvl for net_zero_adjustment_flag (896190)
5984: -- ---------------------------------------------------------------------
5985: /* Updating Project_Burdened_Cost also for Bug 2736773 */
5986: UPDATE pa_expenditure_items_all ei
5987: SET cost_distributed_flag = 'N' ,
5988: adjustment_type ='BURDEN_RECOMPILE',
5989: cost_burden_distributed_flag = 'N',
5990: last_update_date = SYSDATE,

Line 6070: UPDATE pa_expenditure_items_all ei

6066: -- (09/17/98)
6067: --
6068: -- Added Nvl for net_zero_adjustment_flag (896190)
6069: --
6070: UPDATE pa_expenditure_items_all ei
6071: SET revenue_distributed_flag = 'N',
6072: last_update_date = SYSDATE,
6073: last_updated_by = x_last_updated_by,
6074: last_update_login = x_last_update_login,

Line 6157: UPDATE pa_expenditure_items_all ei

6153: --
6154: -- This section is created as a part of fix for bug 897479 .
6155: --
6156: --
6157: UPDATE pa_expenditure_items_all ei
6158: SET revenue_distributed_flag = 'N',
6159: last_update_date = SYSDATE,
6160: last_updated_by = x_last_updated_by,
6161: last_update_login = x_last_update_login,

Line 6233: UPDATE pa_expenditure_items_all ei

6229: * updates and activity logging done for TP schedule change.
6230: * Note: explain plan is fine in RBO, cant test it in CBO because of
6231: * non-availability of volume data.
6232: */
6233: UPDATE pa_expenditure_items_all ei
6234: SET cc_bl_distributed_code =
6235: decode( cc_cross_charge_code,'B',
6236: 'N',
6237: cc_bl_distributed_code),

Line 6285: UPDATE pa_expenditure_items_all ITEM

6281: | M - If Enhanced Burdening is SET, for Separate line burdening |
6282: | transactions the adjustment_type is set to BURDEN_RESUMMARIZE |
6283: | - if cost_distributed_flag is Y. |
6284: +====================================================================*/
6285: UPDATE pa_expenditure_items_all ITEM
6286: SET ITEM.adjustment_type = decode(ITEM.cost_ind_compiled_set_id, compiled_set_id, 'BURDEN_RESUMMARIZE' ,ITEM.adjustment_type)
6287: WHERE ITEM.cost_distributed_flag ='Y'
6288: AND ITEM.adjustment_type IS NULL
6289: AND exists ( select 1 from pa_cost_distribution_lines_all cdl

Line 6400: FROM pa_expenditure_items_all ITEM

6396:
6397: CURSOR ei_cost_cursor
6398: IS
6399: SELECT expenditure_item_id
6400: FROM pa_expenditure_items_all ITEM
6401: WHERE cost_ind_compiled_set_id = compiled_set_id
6402: AND adjustment_type in ('BURDEN_RECOMPILE','BURDEN_RESUMMARIZE','RECALC_BURDEN')
6403: AND request_id = x_request_id
6404: AND EXISTS (SELECT NULL

Line 6416: FROM pa_expenditure_items_all ITEM

6412:
6413: CURSOR ei_rev_cursor
6414: IS
6415: SELECT expenditure_item_id
6416: FROM pa_expenditure_items_all ITEM
6417: WHERE rev_ind_compiled_set_id = compiled_set_id
6418: AND request_id = x_request_id
6419: AND EXISTS (SELECT NULL
6420: FROM pa_cost_base_exp_types cbet

Line 6431: FROM pa_expenditure_items_all ITEM

6427:
6428: CURSOR ei_inv_cursor
6429: IS
6430: SELECT expenditure_item_id
6431: FROM pa_expenditure_items_all ITEM
6432: WHERE inv_ind_compiled_set_id = compiled_set_id
6433: AND request_id = x_request_id
6434: AND EXISTS (SELECT NULL
6435: FROM pa_cost_base_exp_types cbet

Line 6450: FROM pa_expenditure_items_all ITEM

6446: /* Commented for bug 4527736
6447: CURSOR ei_tp_cursor
6448: IS
6449: SELECT expenditure_item_id
6450: FROM pa_expenditure_items_all ITEM
6451: WHERE tp_ind_compiled_set_id = compiled_set_id
6452: AND request_id = x_request_id
6453: AND EXISTS (SELECT NULL
6454: FROM pa_cost_base_exp_types cbet