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.CSTPAPBR dependencies on MTL_PAC_ACTUAL_COST_DETAILS

Line 1183: from mtl_pac_actual_cost_details

1179: END IF;
1180: l_stmt_num := 40;
1181: select count(transaction_id) /* Bug No. 4586534 */
1182: into l_mat_ovhd_exists
1183: from mtl_pac_actual_cost_details
1184: where transaction_id = i_ae_txn_rec.transaction_id
1185: and pac_period_id = i_ae_txn_rec.accounting_period_id
1186: and cost_group_id = i_ae_txn_rec.cost_group_id
1187: and cost_element_id = 2

Line 2232: from mtl_pac_actual_cost_details

2228: /* Absorb MOH if exists */
2229: l_stmt_num := 67;
2230: select count(transaction_id)
2231: into l_mat_ovhd_exists
2232: from mtl_pac_actual_cost_details
2233: where transaction_id = i_ae_txn_rec.transaction_id
2234: and pac_period_id = i_ae_txn_rec.accounting_period_id
2235: and cost_group_id = i_ae_txn_rec.cost_group_id
2236: and cost_element_id = 2

Line 2757: FROM mtl_pac_actual_cost_details

2753:
2754: l_stmt_num := 122;
2755: SELECT sum(nvl(actual_cost,0))
2756: INTO l_mpacd_cost
2757: FROM mtl_pac_actual_cost_details
2758: WHERE transaction_id = i_ae_txn_rec.transaction_id
2759: AND pac_period_id = i_ae_txn_rec.accounting_period_id
2760: AND cost_group_id = i_ae_txn_rec.cost_group_id;
2761:

Line 2923: FROM mtl_pac_actual_cost_details

2919: l_stmt_num := 165;
2920:
2921: SELECT sum(nvl(actual_cost,0))
2922: INTO l_mpacd_cost
2923: FROM mtl_pac_actual_cost_details
2924: WHERE transaction_id = i_ae_txn_rec.transaction_id
2925: AND pac_period_id = i_ae_txn_rec.accounting_period_id
2926: AND cost_group_id = i_ae_txn_rec.cost_group_id;
2927:

Line 3162: from mtl_pac_actual_cost_details

3158: /* Absorb MOH if exists */
3159: l_stmt_num := 217;
3160: select count(transaction_id)
3161: into l_mat_ovhd_exists
3162: from mtl_pac_actual_cost_details
3163: where transaction_id = i_ae_txn_rec.transaction_id
3164: and pac_period_id = i_ae_txn_rec.accounting_period_id
3165: and cost_group_id = i_ae_txn_rec.cost_group_id
3166: and cost_element_id = 2

Line 3649: FROM mtl_pac_actual_cost_details

3645: l_stmt_num := 315;
3646:
3647: SELECT sum(nvl(actual_cost,0))
3648: INTO l_mpacd_cost
3649: FROM mtl_pac_actual_cost_details
3650: WHERE transaction_id = i_ae_txn_rec.transaction_id
3651: AND pac_period_id = i_ae_txn_rec.accounting_period_id
3652: AND cost_group_id = i_ae_txn_rec.cost_group_id;
3653:

Line 3955: FROM mtl_pac_actual_cost_details

3951:
3952: l_stmt_num := 355;
3953: SELECT sum(nvl(actual_cost,0))
3954: INTO l_mpacd_cost
3955: FROM mtl_pac_actual_cost_details
3956: WHERE transaction_id = i_ae_txn_rec.transaction_id
3957: AND pac_period_id = i_ae_txn_rec.accounting_period_id
3958: AND cost_group_id = i_ae_txn_rec.cost_group_id;
3959:

Line 4213: from mtl_pac_actual_cost_details

4209:
4210: l_stmt_num := 397;
4211: select count(transaction_id)
4212: into l_mat_ovhd_exists
4213: from mtl_pac_actual_cost_details
4214: where transaction_id = i_ae_txn_rec.transaction_id
4215: and pac_period_id = i_ae_txn_rec.accounting_period_id
4216: and cost_group_id = i_ae_txn_rec.cost_group_id
4217: and cost_element_id = 2

Line 4507: from mtl_pac_actual_cost_details

4503: /* Absorb MOH if exists */
4504:
4505: select count(transaction_id)
4506: into l_mat_ovhd_exists
4507: from mtl_pac_actual_cost_details
4508: where transaction_id = i_ae_txn_rec.transaction_id
4509: and pac_period_id = i_ae_txn_rec.accounting_period_id
4510: and cost_group_id = i_ae_txn_rec.cost_group_id
4511: and cost_element_id = 2

Line 4917: FROM mtl_pac_actual_cost_details

4913: l_stmt_num := 535;
4914:
4915: SELECT sum(nvl(actual_cost,0))
4916: INTO l_mpacd_cost
4917: FROM mtl_pac_actual_cost_details
4918: WHERE transaction_id = i_ae_txn_rec.transaction_id
4919: AND pac_period_id = i_ae_txn_rec.accounting_period_id
4920: AND cost_group_id = i_ae_txn_rec.cost_group_id;
4921:

Line 5085: FROM mtl_pac_actual_cost_details

5081: l_stmt_num := 567;
5082:
5083: SELECT sum(nvl(actual_cost,0))
5084: INTO l_mpacd_cost
5085: FROM mtl_pac_actual_cost_details
5086: WHERE transaction_id = i_ae_txn_rec.transaction_id
5087: AND pac_period_id = i_ae_txn_rec.accounting_period_id
5088: AND cost_group_id = i_ae_txn_rec.cost_group_id;
5089:

Line 5252: from mtl_pac_actual_cost_details

5248: /* Absorb MOH if exists */
5249: l_stmt_num := 587;
5250: select count(transaction_id)
5251: into l_mat_ovhd_exists
5252: from mtl_pac_actual_cost_details
5253: where transaction_id = i_ae_txn_rec.transaction_id
5254: and pac_period_id = i_ae_txn_rec.accounting_period_id
5255: and cost_group_id = i_ae_txn_rec.cost_group_id
5256: and cost_element_id = 2

Line 5418: from mtl_pac_actual_cost_details

5414: /* Absorb MOH if exists */
5415:
5416: select count(transaction_id)
5417: into l_mat_ovhd_exists
5418: from mtl_pac_actual_cost_details
5419: where transaction_id = i_ae_txn_rec.transaction_id
5420: and pac_period_id = i_ae_txn_rec.accounting_period_id
5421: and cost_group_id = i_ae_txn_rec.cost_group_id
5422: and cost_element_id = 2

Line 5442: FROM mtl_pac_actual_cost_details

5438: end if;
5439:
5440: SELECT sum(nvl(actual_cost,0))
5441: INTO l_txfr_cost
5442: FROM mtl_pac_actual_cost_details
5443: WHERE transaction_id = i_ae_txn_rec.transaction_id
5444: AND pac_period_id = i_ae_txn_rec.accounting_period_id
5445: AND cost_group_id = i_ae_txn_rec.cost_group_id;
5446:

Line 5795: from mtl_pac_actual_cost_details mpacd

5791: -- --------------------------------
5792: l_stmt_num := 25;
5793: select count(transaction_id) /* Bug 4586534 */
5794: into l_ele_exist
5795: from mtl_pac_actual_cost_details mpacd
5796: where mpacd.transaction_id = i_ae_txn_rec.transaction_id
5797: and mpacd.pac_period_id = i_ae_txn_rec.accounting_period_id
5798: and mpacd.cost_group_id = i_ae_txn_rec.cost_group_id
5799: and rownum < 2; /* 4586534 added rownum filter for perf as its only existence check */

Line 5810: from mtl_pac_actual_cost_details mpacd

5806: -- -----------------------
5807: l_stmt_num := 27;
5808: select sum(nvl(variance_amount,0))
5809: into l_var_total
5810: from mtl_pac_actual_cost_details mpacd
5811: where mpacd.transaction_id = i_ae_txn_rec.transaction_id
5812: and mpacd.pac_period_id = i_ae_txn_rec.accounting_period_id
5813: and mpacd.cost_group_id = i_ae_txn_rec.cost_group_id;
5814:

Line 5845: from mtl_pac_actual_cost_details

5841: sum(nvl(onhand_variance_amount,0))
5842: into l_cost,
5843: l_var,
5844: l_onhand_var
5845: from mtl_pac_actual_cost_details
5846: where transaction_id = i_ae_txn_rec.transaction_id
5847: and pac_period_id = i_ae_txn_rec.accounting_period_id
5848: and cost_group_id = i_ae_txn_rec.cost_group_id
5849: and cost_element_id = cost_element;

Line 6506: from mtl_pac_actual_cost_details

6502: l_stmt_num := 70;
6503: if (l_ovhd_absp = 1) then
6504: select count(transaction_id) /* Changed for the bug No . 4586534 */
6505: into l_mat_ovhd_exists
6506: from mtl_pac_actual_cost_details
6507: where transaction_id = i_ae_txn_rec.transaction_id
6508: and pac_period_id = i_ae_txn_rec.accounting_period_id
6509: and cost_group_id = i_ae_txn_rec.cost_group_id
6510: and cost_element_id = 2

Line 6882: from mtl_pac_actual_cost_details mpacd

6878: l_acct_line_type := 31;
6879:
6880: select count(*)
6881: into l_ele_exist
6882: from mtl_pac_actual_cost_details mpacd
6883: where mpacd.transaction_id = i_ae_txn_rec.transaction_id
6884: and mpacd.pac_period_id = i_ae_txn_rec.accounting_period_id
6885: and mpacd.cost_group_id = i_ae_txn_rec.cost_group_id;
6886:

Line 6895: from mtl_pac_actual_cost_details

6891: l_stmt_num := 40;
6892:
6893: select sum(nvl(actual_cost,0))
6894: into l_cost
6895: from mtl_pac_actual_cost_details
6896: where transaction_id = i_ae_txn_rec.transaction_id
6897: and pac_period_id = i_ae_txn_rec.accounting_period_id
6898: and cost_group_id = i_ae_txn_rec.cost_group_id;
6899:

Line 7157: from mtl_pac_actual_cost_details mpacd

7153: l_stmt_num := 30;
7154:
7155: select count(transaction_id)
7156: into l_ele_exist
7157: from mtl_pac_actual_cost_details mpacd
7158: where mpacd.transaction_id = i_ae_txn_rec.transaction_id
7159: and mpacd.pac_period_id = i_ae_txn_rec.accounting_period_id
7160: and mpacd.cost_group_id = i_ae_txn_rec.cost_group_id
7161: and rownum < 2; /* 4586534 added rownum filter for perf as its only existence check */

Line 7173: from mtl_pac_actual_cost_details

7169: l_stmt_num := 40;
7170: select sum(nvl(actual_cost,0)),
7171: sum(nvl(variance_amount,0)) /* Bug 3123936: Prop of 2896193 */
7172: into l_cost, l_var
7173: from mtl_pac_actual_cost_details
7174: where transaction_id = i_ae_txn_rec.transaction_id
7175: and pac_period_id = i_ae_txn_rec.accounting_period_id
7176: and cost_group_id = i_ae_txn_rec.cost_group_id
7177: and cost_element_id = cost_element;

Line 7264: from mtl_pac_actual_cost_details

7260: /* Bug 3213936: Propogation of 2896193 : Start */
7261:
7262: select sum(nvl(variance_amount,0))
7263: into l_var
7264: from mtl_pac_actual_cost_details
7265: where transaction_id = i_ae_txn_rec.transaction_id
7266: and pac_period_id = i_ae_txn_rec.accounting_period_id
7267: and cost_group_id = i_ae_txn_rec.cost_group_id;
7268:

Line 7390: from mtl_pac_actual_cost_details

7386: l_stmt_num := 10;
7387:
7388: select count(transaction_id)
7389: into l_ele_exist
7390: from mtl_pac_actual_cost_details
7391: where transaction_id = i_ae_txn_rec.transaction_id
7392: and pac_period_id = i_ae_txn_rec.accounting_period_id
7393: and cost_group_id = i_ae_txn_rec.cost_group_id
7394: and rownum < 2; /* 4586534 added rownum filter for perf as its only existence check */

Line 7410: from mtl_pac_actual_cost_details

7406: l_stmt_num := 20;
7407:
7408: select sum(nvl(actual_cost,0))
7409: into l_cost
7410: from mtl_pac_actual_cost_details
7411: where transaction_id = i_ae_txn_rec.transaction_id
7412: and pac_period_id = i_ae_txn_rec.accounting_period_id
7413: and cost_group_id = i_ae_txn_rec.cost_group_id
7414: and cost_element_id = cost_element

Line 7493: from mtl_pac_actual_cost_details

7489: l_stmt_num := 50;
7490:
7491: select nvl(sum(nvl(actual_cost,0)),0)
7492: into l_cost
7493: from mtl_pac_actual_cost_details
7494: where transaction_id = i_ae_txn_rec.transaction_id
7495: and pac_period_id = i_ae_txn_rec.accounting_period_id
7496: and cost_group_id = i_ae_txn_rec.cost_group_id
7497: and (cost_element_id <> 2

Line 8735: FROM MTL_PAC_ACTUAL_COST_DETAILS

8731:
8732: l_stmt_num := 10;
8733: SELECT COUNT(*)
8734: INTO l_ele_exist
8735: FROM MTL_PAC_ACTUAL_COST_DETAILS
8736: WHERE transaction_id = i_ae_txn_rec.transaction_id
8737: AND pac_period_id = i_ae_txn_rec.accounting_period_id
8738: AND cost_group_id = i_ae_txn_rec.cost_group_id;
8739:

Line 8795: FROM mtl_pac_actual_cost_details

8791: SELECT SUM(nvl(actual_cost,0)) ,
8792: SUM(nvl(wip_variance,0))
8793: INTO l_cost,
8794: l_wip_variance
8795: FROM mtl_pac_actual_cost_details
8796: WHERe transaction_id = i_ae_txn_rec.transaction_id
8797: AND pac_period_id = i_ae_txn_rec.accounting_period_id
8798: AND cost_group_id = i_ae_txn_rec.cost_group_id
8799: AND cost_element_id = cost_element

Line 9716: FROM mtl_pac_actual_cost_details

9712:
9713: l_stmt_num := 320;
9714: SELECT sum(nvl(actual_cost,0))
9715: INTO l_mpacd_cost
9716: FROM mtl_pac_actual_cost_details
9717: WHERE transaction_id = i_ae_txn_rec.transaction_id
9718: AND pac_period_id = i_ae_txn_rec.accounting_period_id
9719: AND cost_group_id = i_ae_txn_rec.cost_group_id;
9720: