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.CSTPACDP dependencies on CST_COST_GROUP_ACCOUNTS

Line 899: from cst_cost_group_accounts

895: where organization_id = i_org_id;
896: else
897: select nvl(expense_account, -1)
898: into l_exp_acct1
899: from cst_cost_group_accounts
900: where cost_group_id = i_cost_grp_id
901: and organization_id = i_org_id;
902: end if;
903: end if;

Line 1266: from cst_cost_group_accounts

1262: where organization_id = i_org_id;
1263: else
1264: select nvl(expense_account, -1)
1265: into l_exp_acct
1266: from cst_cost_group_accounts
1267: where cost_group_id = i_cost_grp_id
1268: and organization_id = i_org_id;
1269: end if;
1270: end if;

Line 1515: from cst_cost_group_accounts

1511: where organization_id = i_org_id;
1512: else
1513: select nvl(expense_account, -1)
1514: into l_exp_acct1
1515: from cst_cost_group_accounts
1516: where cost_group_id = i_cost_grp_id
1517: and organization_id = i_org_id;
1518: end if;
1519:

Line 1528: from cst_cost_group_accounts

1524: where organization_id = i_org_id;
1525: else
1526: select nvl(expense_account, -1)
1527: into l_exp_acct2
1528: from cst_cost_group_accounts
1529: where cost_group_id = i_txfr_cost_grp
1530: and organization_id = i_org_id;
1531: end if;
1532: end if;

Line 1706: from cst_cost_group_accounts

1702: else
1703: l_stmt_num := 13;
1704: select nvl(expense_account, -1)
1705: into l_exp_acct
1706: from cst_cost_group_accounts
1707: where cost_group_id = i_cost_grp_id AND
1708: organization_id = i_org_id;
1709: end if;
1710: end if;

Line 2501: from cst_cost_group_accounts

2497: where organization_id = i_org_id;
2498: else
2499: select nvl(expense_account, l_exp_acct)
2500: into l_exp_acct
2501: from cst_cost_group_accounts
2502: where cost_group_id = i_cost_grp_id
2503: and organization_id = i_org_id;
2504: end if;
2505: end if;

Line 2748: from cst_cost_group_accounts

2744: nvl(expense_account, l_std_exp_acct)
2745: into l_std_mat_acct, l_std_mat_ovhd_acct, l_std_res_acct,
2746: l_std_osp_acct, l_std_ovhd_acct,
2747: l_std_exp_acct
2748: from cst_cost_group_accounts
2749: where organization_id = l_std_org
2750: and cost_group_id = l_cg_id;
2751: end if;
2752: end if;

Line 3705: from cst_cost_group_accounts

3701: where organization_id = i_org_id;
3702: else
3703: select nvl(material_account,-1), nvl(material_overhead_account,-1)
3704: into l_acct, l_moh_offset_acct
3705: from cst_cost_group_accounts
3706: where cost_group_id = l_to_cost_grp
3707: and organization_id = i_org_id;
3708: end if;
3709:

Line 4135: from cst_cost_group_accounts

4131: where organization_id = i_org_id;
4132: else
4133: select nvl(material_account,-1)
4134: into l_acct
4135: from cst_cost_group_accounts
4136: where organization_id = i_org_id
4137: and cost_group_id = l_to_cost_grp;
4138: end if;
4139:

Line 4196: from cst_cost_group_accounts

4192: where organization_id = i_org_id;
4193: else
4194: select nvl(material_account,-1)
4195: into l_acct
4196: from cst_cost_group_accounts
4197: where organization_id = i_org_id
4198: and cost_group_id = l_to_cost_grp;
4199: end if;
4200:

Line 4367: from cst_cost_group_accounts

4363: where organization_id = i_org_id;
4364: else
4365: select count(*)
4366: into l_acct_exist
4367: from cst_cost_group_accounts
4368: where organization_id = i_org_id
4369: and cost_group_id = i_cost_grp_id;
4370: end if;
4371:

Line 4402: from cst_cost_group_accounts

4398: l_inv_mat_ovhd_acct,
4399: l_inv_res_acct,
4400: l_inv_osp_acct,
4401: l_inv_ovhd_acct
4402: from cst_cost_group_accounts
4403: where organization_id = i_org_id
4404: and cost_group_id = i_cost_grp_id;
4405: end if;
4406:

Line 4606: from cst_cost_group_accounts

4602: where organization_id = i_org_id;
4603: else
4604: select nvl(average_cost_var_account,-1)
4605: into l_acct
4606: from cst_cost_group_accounts
4607: where organization_id = i_org_id
4608: and cost_group_id = i_cost_grp_id;
4609: end if;
4610: end if;

Line 4737: from cst_cost_group_accounts

4733: where organization_id = i_org_id;
4734: else
4735: select nvl(expense_account, -1)
4736: into l_exp_acct
4737: from cst_cost_group_accounts
4738: where cost_group_id = i_cost_grp_id AND
4739: organization_id = i_org_id;
4740: end if;
4741: else

Line 5263: FROM cst_cost_group_accounts

5259: l_stmt_num := 80;
5260:
5261: SELECT count(*)
5262: INTO l_ccga_count
5263: FROM cst_cost_group_accounts
5264: WHERE cost_group_id = l_cost_grp_id
5265: AND organization_id = i_org_id;
5266:
5267: if (l_ccga_count = 0) then

Line 5281: FROM cst_cost_group_accounts

5277: nvl(resource_account, -1),
5278: nvl(outside_processing_account, -1),
5279: nvl(overhead_account, -1)
5280: INTO l_mat_acct, l_mat_ovhd_acct, l_res_acct, l_osp_acct, l_ovhd_acct
5281: FROM cst_cost_group_accounts
5282: WHERE organization_id = i_org_id
5283: AND cost_group_id = l_cost_grp_id;
5284: end if;
5285: end if;

Line 5458: from cst_cost_group_accounts

5454: where organization_id = i_org_id;
5455: else
5456: select count(*)
5457: into l_acct_exist
5458: from cst_cost_group_accounts
5459: where organization_id = i_org_id
5460: and cost_group_id = i_cost_grp_id;
5461: end if;
5462:

Line 5498: from cst_cost_group_accounts

5494: l_mat_ovhd_acct,
5495: l_res_acct,
5496: l_osp_acct,
5497: l_ovhd_acct
5498: from cst_cost_group_accounts
5499: where organization_id = i_org_id
5500: and cost_group_id = l_cost_grp_id;
5501: end if;
5502:

Line 5668: from cst_cost_group_accounts

5664: where organization_id = i_org_id;
5665: else
5666: select nvl(average_cost_var_account,-1)
5667: into l_acct
5668: from cst_cost_group_accounts
5669: where cost_group_id = i_cost_grp_id
5670: and organization_id = i_org_id;
5671: end if;
5672: end if;

Line 5728: from cst_cost_group_accounts

5724: l_stmt_num := 110;
5725: if cost_element = 1 then
5726: select nvl(payback_mat_var_account,-1)
5727: into l_acct
5728: from cst_cost_group_accounts
5729: where organization_id = i_org_id
5730: and cost_group_id = i_cost_grp_id;
5731: elsif cost_element = 2 then
5732: select nvl(payback_moh_var_account,-1)

Line 5734: from cst_cost_group_accounts

5730: and cost_group_id = i_cost_grp_id;
5731: elsif cost_element = 2 then
5732: select nvl(payback_moh_var_account,-1)
5733: into l_acct
5734: from cst_cost_group_accounts
5735: where organization_id = i_org_id
5736: and cost_group_id = i_cost_grp_id;
5737: elsif cost_element = 3 then
5738: select nvl(payback_res_var_account,-1)

Line 5740: from cst_cost_group_accounts

5736: and cost_group_id = i_cost_grp_id;
5737: elsif cost_element = 3 then
5738: select nvl(payback_res_var_account,-1)
5739: into l_acct
5740: from cst_cost_group_accounts
5741: where organization_id = i_org_id
5742: and cost_group_id = i_cost_grp_id;
5743: elsif cost_element = 4 then
5744: select nvl(payback_osp_var_account,-1)

Line 5746: from cst_cost_group_accounts

5742: and cost_group_id = i_cost_grp_id;
5743: elsif cost_element = 4 then
5744: select nvl(payback_osp_var_account,-1)
5745: into l_acct
5746: from cst_cost_group_accounts
5747: where organization_id = i_org_id
5748: and cost_group_id = i_cost_grp_id;
5749: elsif cost_element = 5 then
5750: select nvl(payback_ovh_var_account,-1)

Line 5752: from cst_cost_group_accounts

5748: and cost_group_id = i_cost_grp_id;
5749: elsif cost_element = 5 then
5750: select nvl(payback_ovh_var_account,-1)
5751: into l_acct
5752: from cst_cost_group_accounts
5753: where organization_id = i_org_id
5754: and cost_group_id = i_cost_grp_id;
5755: end if; -- end selecting different variance account
5756: end if; -- end if l_acct <> -1 then use hook account

Line 7400: FROM cst_cost_group_accounts

7396: l_stmt_num := 230;
7397:
7398: select count(*)
7399: INTO ccga_count
7400: FROM cst_cost_group_accounts
7401: WHERE cost_group_id = cg_id
7402: AND organization_id = org_id;
7403:
7404: l_stmt_num := 240;

Line 7421: from cst_cost_group_accounts

7417: nvl(expense_account, exp_acct)
7418: into mat_acct, mat_ovhd_acct, res_acct,
7419: osp_acct, ovhd_acct,
7420: exp_acct
7421: from cst_cost_group_accounts
7422: where organization_id = org_id
7423: and cost_group_id = cg_id;
7424:
7425: end if; /* if (ccga_count = 0) */

Line 7622: FROM cst_cost_group_accounts

7618: l_stmt_num := 612;
7619:
7620: SELECT count(*)
7621: INTO ccga_count
7622: FROM cst_cost_group_accounts
7623: WHERE cost_group_id = cg_id
7624: AND organization_id = org_id;
7625:
7626: l_stmt_num := 614;

Line 7638: FROM cst_cost_group_accounts

7634: else
7635: l_stmt_num := 616;
7636: SELECT nvl(purchase_price_var_account, io_ppv_acct)
7637: INTO io_ppv_acct
7638: FROM cst_cost_group_accounts
7639: WHERE cost_group_id = cg_id
7640: AND organization_id = org_id ;
7641: end if;
7642: end if; /* if (cg_id <> 1) */

Line 7652: FROM cst_cost_group_accounts

7648: then
7649: l_stmt_num := 640;
7650: SELECT count(*)
7651: INTO ccga_count
7652: FROM cst_cost_group_accounts
7653: WHERE cost_group_id = cg_id
7654: AND organization_id = org_id;
7655:
7656: l_stmt_num := 650;

Line 7670: FROM cst_cost_group_accounts

7666: then
7667: l_stmt_num := 655;
7668: SELECT nvl(purchase_price_var_account, io_ppv_acct)
7669: INTO io_ppv_acct
7670: FROM cst_cost_group_accounts
7671: WHERE cost_group_id = cg_id
7672: AND organization_id = org_id ;
7673: end if; /* if(subinv.len > 0) */
7674: end if; /* if (ccga_count = 0) */