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.

[Home] [Help]

APPS.CSTPAPBR dependencies on MTL_PAC_ACTUAL_COST_DETAILS

Line 1401: from mtl_pac_actual_cost_details

1397: END IF;
1398: l_stmt_num := 40;
1399: select count(transaction_id) /* Bug No. 4586534 */
1400: into l_mat_ovhd_exists
1401: from mtl_pac_actual_cost_details
1402: where transaction_id = i_ae_txn_rec.transaction_id
1403: and pac_period_id = i_ae_txn_rec.accounting_period_id
1404: and cost_group_id = i_ae_txn_rec.cost_group_id
1405: and cost_element_id = 2

Line 2514: from mtl_pac_actual_cost_details

2510: /* Absorb MOH if exists */
2511: l_stmt_num := 67;
2512: select count(transaction_id)
2513: into l_mat_ovhd_exists
2514: from mtl_pac_actual_cost_details
2515: where transaction_id = i_ae_txn_rec.transaction_id
2516: and pac_period_id = i_ae_txn_rec.accounting_period_id
2517: and cost_group_id = i_ae_txn_rec.cost_group_id
2518: and cost_element_id = 2

Line 3039: FROM mtl_pac_actual_cost_details

3035:
3036: l_stmt_num := 122;
3037: SELECT sum(nvl(actual_cost,0))
3038: INTO l_mpacd_cost
3039: FROM mtl_pac_actual_cost_details
3040: WHERE transaction_id = i_ae_txn_rec.transaction_id
3041: AND pac_period_id = i_ae_txn_rec.accounting_period_id
3042: AND cost_group_id = i_ae_txn_rec.cost_group_id;
3043:

Line 3205: FROM mtl_pac_actual_cost_details

3201: l_stmt_num := 165;
3202:
3203: SELECT sum(nvl(actual_cost,0))
3204: INTO l_mpacd_cost
3205: FROM mtl_pac_actual_cost_details
3206: WHERE transaction_id = i_ae_txn_rec.transaction_id
3207: AND pac_period_id = i_ae_txn_rec.accounting_period_id
3208: AND cost_group_id = i_ae_txn_rec.cost_group_id;
3209:

Line 3444: from mtl_pac_actual_cost_details

3440: /* Absorb MOH if exists */
3441: l_stmt_num := 217;
3442: select count(transaction_id)
3443: into l_mat_ovhd_exists
3444: from mtl_pac_actual_cost_details
3445: where transaction_id = i_ae_txn_rec.transaction_id
3446: and pac_period_id = i_ae_txn_rec.accounting_period_id
3447: and cost_group_id = i_ae_txn_rec.cost_group_id
3448: and cost_element_id = 2

Line 3931: FROM mtl_pac_actual_cost_details

3927: l_stmt_num := 315;
3928:
3929: SELECT sum(nvl(actual_cost,0))
3930: INTO l_mpacd_cost
3931: FROM mtl_pac_actual_cost_details
3932: WHERE transaction_id = i_ae_txn_rec.transaction_id
3933: AND pac_period_id = i_ae_txn_rec.accounting_period_id
3934: AND cost_group_id = i_ae_txn_rec.cost_group_id;
3935:

Line 4237: FROM mtl_pac_actual_cost_details

4233:
4234: l_stmt_num := 355;
4235: SELECT sum(nvl(actual_cost,0))
4236: INTO l_mpacd_cost
4237: FROM mtl_pac_actual_cost_details
4238: WHERE transaction_id = i_ae_txn_rec.transaction_id
4239: AND pac_period_id = i_ae_txn_rec.accounting_period_id
4240: AND cost_group_id = i_ae_txn_rec.cost_group_id;
4241:

Line 4495: from mtl_pac_actual_cost_details

4491:
4492: l_stmt_num := 397;
4493: select count(transaction_id)
4494: into l_mat_ovhd_exists
4495: from mtl_pac_actual_cost_details
4496: where transaction_id = i_ae_txn_rec.transaction_id
4497: and pac_period_id = i_ae_txn_rec.accounting_period_id
4498: and cost_group_id = i_ae_txn_rec.cost_group_id
4499: and cost_element_id = 2

Line 4789: from mtl_pac_actual_cost_details

4785: /* Absorb MOH if exists */
4786:
4787: select count(transaction_id)
4788: into l_mat_ovhd_exists
4789: from mtl_pac_actual_cost_details
4790: where transaction_id = i_ae_txn_rec.transaction_id
4791: and pac_period_id = i_ae_txn_rec.accounting_period_id
4792: and cost_group_id = i_ae_txn_rec.cost_group_id
4793: and cost_element_id = 2

Line 5199: FROM mtl_pac_actual_cost_details

5195: l_stmt_num := 535;
5196:
5197: SELECT sum(nvl(actual_cost,0))
5198: INTO l_mpacd_cost
5199: FROM mtl_pac_actual_cost_details
5200: WHERE transaction_id = i_ae_txn_rec.transaction_id
5201: AND pac_period_id = i_ae_txn_rec.accounting_period_id
5202: AND cost_group_id = i_ae_txn_rec.cost_group_id;
5203:

Line 5367: FROM mtl_pac_actual_cost_details

5363: l_stmt_num := 567;
5364:
5365: SELECT sum(nvl(actual_cost,0))
5366: INTO l_mpacd_cost
5367: FROM mtl_pac_actual_cost_details
5368: WHERE transaction_id = i_ae_txn_rec.transaction_id
5369: AND pac_period_id = i_ae_txn_rec.accounting_period_id
5370: AND cost_group_id = i_ae_txn_rec.cost_group_id;
5371:

Line 5534: from mtl_pac_actual_cost_details

5530: /* Absorb MOH if exists */
5531: l_stmt_num := 587;
5532: select count(transaction_id)
5533: into l_mat_ovhd_exists
5534: from mtl_pac_actual_cost_details
5535: where transaction_id = i_ae_txn_rec.transaction_id
5536: and pac_period_id = i_ae_txn_rec.accounting_period_id
5537: and cost_group_id = i_ae_txn_rec.cost_group_id
5538: and cost_element_id = 2

Line 5700: from mtl_pac_actual_cost_details

5696: /* Absorb MOH if exists */
5697:
5698: select count(transaction_id)
5699: into l_mat_ovhd_exists
5700: from mtl_pac_actual_cost_details
5701: where transaction_id = i_ae_txn_rec.transaction_id
5702: and pac_period_id = i_ae_txn_rec.accounting_period_id
5703: and cost_group_id = i_ae_txn_rec.cost_group_id
5704: and cost_element_id = 2

Line 5724: FROM mtl_pac_actual_cost_details

5720: end if;
5721:
5722: SELECT sum(nvl(actual_cost,0))
5723: INTO l_txfr_cost
5724: FROM mtl_pac_actual_cost_details
5725: WHERE transaction_id = i_ae_txn_rec.transaction_id
5726: AND pac_period_id = i_ae_txn_rec.accounting_period_id
5727: AND cost_group_id = i_ae_txn_rec.cost_group_id;
5728:

Line 6077: from mtl_pac_actual_cost_details mpacd

6073: -- --------------------------------
6074: l_stmt_num := 25;
6075: select count(transaction_id) /* Bug 4586534 */
6076: into l_ele_exist
6077: from mtl_pac_actual_cost_details mpacd
6078: where mpacd.transaction_id = i_ae_txn_rec.transaction_id
6079: and mpacd.pac_period_id = i_ae_txn_rec.accounting_period_id
6080: and mpacd.cost_group_id = i_ae_txn_rec.cost_group_id
6081: and rownum < 2; /* 4586534 added rownum filter for perf as its only existence check */

Line 6092: from mtl_pac_actual_cost_details mpacd

6088: -- -----------------------
6089: l_stmt_num := 27;
6090: select sum(nvl(variance_amount,0))
6091: into l_var_total
6092: from mtl_pac_actual_cost_details mpacd
6093: where mpacd.transaction_id = i_ae_txn_rec.transaction_id
6094: and mpacd.pac_period_id = i_ae_txn_rec.accounting_period_id
6095: and mpacd.cost_group_id = i_ae_txn_rec.cost_group_id;
6096:

Line 6127: from mtl_pac_actual_cost_details

6123: sum(nvl(onhand_variance_amount,0))
6124: into l_cost,
6125: l_var,
6126: l_onhand_var
6127: from mtl_pac_actual_cost_details
6128: where transaction_id = i_ae_txn_rec.transaction_id
6129: and pac_period_id = i_ae_txn_rec.accounting_period_id
6130: and cost_group_id = i_ae_txn_rec.cost_group_id
6131: and cost_element_id = cost_element;

Line 6637: mtl_pac_actual_cost_details MPACD

6633:
6634: SELECT count(*)
6635: INTO l_count_so
6636: FROM mtl_material_transactions MMT,
6637: mtl_pac_actual_cost_details MPACD
6638: WHERE (MMT.transaction_action_id = 1 OR MMT.transaction_action_id = 7)
6639: AND MMT.transaction_source_type_id = 2
6640: AND EXISTS (SELECT 1
6641: FROM cst_cost_group_assignments CCGA

Line 6810: from mtl_pac_actual_cost_details

6806: l_stmt_num := 70;
6807: if (l_ovhd_absp = 1) then
6808: select count(transaction_id) /* Changed for the bug No . 4586534 */
6809: into l_mat_ovhd_exists
6810: from mtl_pac_actual_cost_details
6811: where transaction_id = i_ae_txn_rec.transaction_id
6812: and pac_period_id = i_ae_txn_rec.accounting_period_id
6813: and cost_group_id = i_ae_txn_rec.cost_group_id
6814: and cost_element_id = 2

Line 7256: from mtl_pac_actual_cost_details mpacd

7252: l_acct_line_type := 31;
7253:
7254: select count(*)
7255: into l_ele_exist
7256: from mtl_pac_actual_cost_details mpacd
7257: where mpacd.transaction_id = i_ae_txn_rec.transaction_id
7258: and mpacd.pac_period_id = i_ae_txn_rec.accounting_period_id
7259: and mpacd.cost_group_id = i_ae_txn_rec.cost_group_id;
7260:

Line 7269: from mtl_pac_actual_cost_details

7265: l_stmt_num := 40;
7266:
7267: select sum(nvl(actual_cost,0))
7268: into l_cost
7269: from mtl_pac_actual_cost_details
7270: where transaction_id = i_ae_txn_rec.transaction_id
7271: and pac_period_id = i_ae_txn_rec.accounting_period_id
7272: and cost_group_id = i_ae_txn_rec.cost_group_id;
7273:

Line 7531: from mtl_pac_actual_cost_details mpacd

7527: l_stmt_num := 30;
7528:
7529: select count(transaction_id)
7530: into l_ele_exist
7531: from mtl_pac_actual_cost_details mpacd
7532: where mpacd.transaction_id = i_ae_txn_rec.transaction_id
7533: and mpacd.pac_period_id = i_ae_txn_rec.accounting_period_id
7534: and mpacd.cost_group_id = i_ae_txn_rec.cost_group_id
7535: and rownum < 2; /* 4586534 added rownum filter for perf as its only existence check */

Line 7547: from mtl_pac_actual_cost_details

7543: l_stmt_num := 40;
7544: select sum(nvl(actual_cost,0)),
7545: sum(nvl(variance_amount,0)) /* Bug 3123936: Prop of 2896193 */
7546: into l_cost, l_var
7547: from mtl_pac_actual_cost_details
7548: where transaction_id = i_ae_txn_rec.transaction_id
7549: and pac_period_id = i_ae_txn_rec.accounting_period_id
7550: and cost_group_id = i_ae_txn_rec.cost_group_id
7551: and cost_element_id = cost_element;

Line 7647: from mtl_pac_actual_cost_details

7643: /* Bug 3213936: Propogation of 2896193 : Start */
7644:
7645: select sum(nvl(variance_amount,0))
7646: into l_var
7647: from mtl_pac_actual_cost_details
7648: where transaction_id = i_ae_txn_rec.transaction_id
7649: and pac_period_id = i_ae_txn_rec.accounting_period_id
7650: and cost_group_id = i_ae_txn_rec.cost_group_id;
7651:

Line 7773: from mtl_pac_actual_cost_details

7769: l_stmt_num := 10;
7770:
7771: select count(transaction_id)
7772: into l_ele_exist
7773: from mtl_pac_actual_cost_details
7774: where transaction_id = i_ae_txn_rec.transaction_id
7775: and pac_period_id = i_ae_txn_rec.accounting_period_id
7776: and cost_group_id = i_ae_txn_rec.cost_group_id
7777: and rownum < 2; /* 4586534 added rownum filter for perf as its only existence check */

Line 7793: from mtl_pac_actual_cost_details

7789: l_stmt_num := 20;
7790:
7791: select sum(nvl(actual_cost,0))
7792: into l_cost
7793: from mtl_pac_actual_cost_details
7794: where transaction_id = i_ae_txn_rec.transaction_id
7795: and pac_period_id = i_ae_txn_rec.accounting_period_id
7796: and cost_group_id = i_ae_txn_rec.cost_group_id
7797: and cost_element_id = cost_element

Line 7876: from mtl_pac_actual_cost_details

7872: l_stmt_num := 50;
7873:
7874: select nvl(sum(nvl(actual_cost,0)),0)
7875: into l_cost
7876: from mtl_pac_actual_cost_details
7877: where transaction_id = i_ae_txn_rec.transaction_id
7878: and pac_period_id = i_ae_txn_rec.accounting_period_id
7879: and cost_group_id = i_ae_txn_rec.cost_group_id
7880: and (cost_element_id <> 2

Line 9176: FROM MTL_PAC_ACTUAL_COST_DETAILS

9172:
9173: l_stmt_num := 10;
9174: SELECT COUNT(*)
9175: INTO l_ele_exist
9176: FROM MTL_PAC_ACTUAL_COST_DETAILS
9177: WHERE transaction_id = i_ae_txn_rec.transaction_id
9178: AND pac_period_id = i_ae_txn_rec.accounting_period_id
9179: AND cost_group_id = i_ae_txn_rec.cost_group_id;
9180:

Line 9236: FROM mtl_pac_actual_cost_details

9232: SELECT SUM(nvl(actual_cost,0)) ,
9233: SUM(nvl(wip_variance,0))
9234: INTO l_cost,
9235: l_wip_variance
9236: FROM mtl_pac_actual_cost_details
9237: WHERe transaction_id = i_ae_txn_rec.transaction_id
9238: AND pac_period_id = i_ae_txn_rec.accounting_period_id
9239: AND cost_group_id = i_ae_txn_rec.cost_group_id
9240: AND cost_element_id = cost_element

Line 10183: FROM mtl_pac_actual_cost_details

10179:
10180: l_stmt_num := 320;
10181: SELECT sum(nvl(actual_cost,0))
10182: INTO l_mpacd_cost
10183: FROM mtl_pac_actual_cost_details
10184: WHERE transaction_id = i_ae_txn_rec.transaction_id
10185: AND pac_period_id = i_ae_txn_rec.accounting_period_id
10186: AND cost_group_id = i_ae_txn_rec.cost_group_id;
10187: