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 990: from cst_cost_group_accounts

986: where organization_id = i_org_id;
987: else
988: select nvl(expense_account, -1)
989: into l_exp_acct1
990: from cst_cost_group_accounts
991: where cost_group_id = i_cost_grp_id
992: and organization_id = i_org_id;
993: end if;
994: end if;

Line 1357: from cst_cost_group_accounts

1353: where organization_id = i_org_id;
1354: else
1355: select nvl(expense_account, -1)
1356: into l_exp_acct
1357: from cst_cost_group_accounts
1358: where cost_group_id = i_cost_grp_id
1359: and organization_id = i_org_id;
1360: end if;
1361: end if;

Line 1606: from cst_cost_group_accounts

1602: where organization_id = i_org_id;
1603: else
1604: select nvl(expense_account, -1)
1605: into l_exp_acct1
1606: from cst_cost_group_accounts
1607: where cost_group_id = i_cost_grp_id
1608: and organization_id = i_org_id;
1609: end if;
1610:

Line 1619: from cst_cost_group_accounts

1615: where organization_id = i_org_id;
1616: else
1617: select nvl(expense_account, -1)
1618: into l_exp_acct2
1619: from cst_cost_group_accounts
1620: where cost_group_id = i_txfr_cost_grp
1621: and organization_id = i_org_id;
1622: end if;
1623: end if;

Line 1797: from cst_cost_group_accounts

1793: else
1794: l_stmt_num := 13;
1795: select nvl(expense_account, -1)
1796: into l_exp_acct
1797: from cst_cost_group_accounts
1798: where cost_group_id = i_cost_grp_id AND
1799: organization_id = i_org_id;
1800: end if;
1801: end if;

Line 2592: from cst_cost_group_accounts

2588: where organization_id = i_org_id;
2589: else
2590: select nvl(expense_account, l_exp_acct)
2591: into l_exp_acct
2592: from cst_cost_group_accounts
2593: where cost_group_id = i_cost_grp_id
2594: and organization_id = i_org_id;
2595: end if;
2596: end if;

Line 2839: from cst_cost_group_accounts

2835: nvl(expense_account, l_std_exp_acct)
2836: into l_std_mat_acct, l_std_mat_ovhd_acct, l_std_res_acct,
2837: l_std_osp_acct, l_std_ovhd_acct,
2838: l_std_exp_acct
2839: from cst_cost_group_accounts
2840: where organization_id = l_std_org
2841: and cost_group_id = l_cg_id;
2842: end if;
2843: end if;

Line 3796: from cst_cost_group_accounts

3792: where organization_id = i_org_id;
3793: else
3794: select nvl(material_account,-1), nvl(material_overhead_account,-1)
3795: into l_acct, l_moh_offset_acct
3796: from cst_cost_group_accounts
3797: where cost_group_id = l_to_cost_grp
3798: and organization_id = i_org_id;
3799: end if;
3800:

Line 4226: from cst_cost_group_accounts

4222: where organization_id = i_org_id;
4223: else
4224: select nvl(material_account,-1)
4225: into l_acct
4226: from cst_cost_group_accounts
4227: where organization_id = i_org_id
4228: and cost_group_id = l_to_cost_grp;
4229: end if;
4230:

Line 4287: from cst_cost_group_accounts

4283: where organization_id = i_org_id;
4284: else
4285: select nvl(material_account,-1)
4286: into l_acct
4287: from cst_cost_group_accounts
4288: where organization_id = i_org_id
4289: and cost_group_id = l_to_cost_grp;
4290: end if;
4291:

Line 4458: from cst_cost_group_accounts

4454: where organization_id = i_org_id;
4455: else
4456: select count(*)
4457: into l_acct_exist
4458: from cst_cost_group_accounts
4459: where organization_id = i_org_id
4460: and cost_group_id = i_cost_grp_id;
4461: end if;
4462:

Line 4493: from cst_cost_group_accounts

4489: l_inv_mat_ovhd_acct,
4490: l_inv_res_acct,
4491: l_inv_osp_acct,
4492: l_inv_ovhd_acct
4493: from cst_cost_group_accounts
4494: where organization_id = i_org_id
4495: and cost_group_id = i_cost_grp_id;
4496: end if;
4497:

Line 4697: from cst_cost_group_accounts

4693: where organization_id = i_org_id;
4694: else
4695: select nvl(average_cost_var_account,-1)
4696: into l_acct
4697: from cst_cost_group_accounts
4698: where organization_id = i_org_id
4699: and cost_group_id = i_cost_grp_id;
4700: end if;
4701: end if;

Line 4828: from cst_cost_group_accounts

4824: where organization_id = i_org_id;
4825: else
4826: select nvl(expense_account, -1)
4827: into l_exp_acct
4828: from cst_cost_group_accounts
4829: where cost_group_id = i_cost_grp_id AND
4830: organization_id = i_org_id;
4831: end if;
4832: else

Line 5355: FROM cst_cost_group_accounts

5351: l_stmt_num := 80;
5352:
5353: SELECT count(*)
5354: INTO l_ccga_count
5355: FROM cst_cost_group_accounts
5356: WHERE cost_group_id = l_cost_grp_id
5357: AND organization_id = i_org_id;
5358:
5359: if (l_ccga_count = 0) then

Line 5373: FROM cst_cost_group_accounts

5369: nvl(resource_account, -1),
5370: nvl(outside_processing_account, -1),
5371: nvl(overhead_account, -1)
5372: INTO l_mat_acct, l_mat_ovhd_acct, l_res_acct, l_osp_acct, l_ovhd_acct
5373: FROM cst_cost_group_accounts
5374: WHERE organization_id = i_org_id
5375: AND cost_group_id = l_cost_grp_id;
5376: end if;
5377: end if;

Line 5550: from cst_cost_group_accounts

5546: where organization_id = i_org_id;
5547: else
5548: select count(*)
5549: into l_acct_exist
5550: from cst_cost_group_accounts
5551: where organization_id = i_org_id
5552: and cost_group_id = i_cost_grp_id;
5553: end if;
5554:

Line 5590: from cst_cost_group_accounts

5586: l_mat_ovhd_acct,
5587: l_res_acct,
5588: l_osp_acct,
5589: l_ovhd_acct
5590: from cst_cost_group_accounts
5591: where organization_id = i_org_id
5592: and cost_group_id = l_cost_grp_id;
5593: end if;
5594:

Line 5760: from cst_cost_group_accounts

5756: where organization_id = i_org_id;
5757: else
5758: select nvl(average_cost_var_account,-1)
5759: into l_acct
5760: from cst_cost_group_accounts
5761: where cost_group_id = i_cost_grp_id
5762: and organization_id = i_org_id;
5763: end if;
5764: end if;

Line 5820: from cst_cost_group_accounts

5816: l_stmt_num := 110;
5817: if cost_element = 1 then
5818: select nvl(payback_mat_var_account,-1)
5819: into l_acct
5820: from cst_cost_group_accounts
5821: where organization_id = i_org_id
5822: and cost_group_id = i_cost_grp_id;
5823: elsif cost_element = 2 then
5824: select nvl(payback_moh_var_account,-1)

Line 5826: from cst_cost_group_accounts

5822: and cost_group_id = i_cost_grp_id;
5823: elsif cost_element = 2 then
5824: select nvl(payback_moh_var_account,-1)
5825: into l_acct
5826: from cst_cost_group_accounts
5827: where organization_id = i_org_id
5828: and cost_group_id = i_cost_grp_id;
5829: elsif cost_element = 3 then
5830: select nvl(payback_res_var_account,-1)

Line 5832: from cst_cost_group_accounts

5828: and cost_group_id = i_cost_grp_id;
5829: elsif cost_element = 3 then
5830: select nvl(payback_res_var_account,-1)
5831: into l_acct
5832: from cst_cost_group_accounts
5833: where organization_id = i_org_id
5834: and cost_group_id = i_cost_grp_id;
5835: elsif cost_element = 4 then
5836: select nvl(payback_osp_var_account,-1)

Line 5838: from cst_cost_group_accounts

5834: and cost_group_id = i_cost_grp_id;
5835: elsif cost_element = 4 then
5836: select nvl(payback_osp_var_account,-1)
5837: into l_acct
5838: from cst_cost_group_accounts
5839: where organization_id = i_org_id
5840: and cost_group_id = i_cost_grp_id;
5841: elsif cost_element = 5 then
5842: select nvl(payback_ovh_var_account,-1)

Line 5844: from cst_cost_group_accounts

5840: and cost_group_id = i_cost_grp_id;
5841: elsif cost_element = 5 then
5842: select nvl(payback_ovh_var_account,-1)
5843: into l_acct
5844: from cst_cost_group_accounts
5845: where organization_id = i_org_id
5846: and cost_group_id = i_cost_grp_id;
5847: end if; -- end selecting different variance account
5848: end if; -- end if l_acct <> -1 then use hook account

Line 7599: FROM cst_cost_group_accounts

7595: l_stmt_num := 230;
7596:
7597: select count(*)
7598: INTO ccga_count
7599: FROM cst_cost_group_accounts
7600: WHERE cost_group_id = cg_id
7601: AND organization_id = org_id;
7602:
7603: l_stmt_num := 240;

Line 7620: from cst_cost_group_accounts

7616: nvl(expense_account, exp_acct)
7617: into mat_acct, mat_ovhd_acct, res_acct,
7618: osp_acct, ovhd_acct,
7619: exp_acct
7620: from cst_cost_group_accounts
7621: where organization_id = org_id
7622: and cost_group_id = cg_id;
7623:
7624: end if; /* if (ccga_count = 0) */

Line 7821: FROM cst_cost_group_accounts

7817: l_stmt_num := 612;
7818:
7819: SELECT count(*)
7820: INTO ccga_count
7821: FROM cst_cost_group_accounts
7822: WHERE cost_group_id = cg_id
7823: AND organization_id = org_id;
7824:
7825: l_stmt_num := 614;

Line 7837: FROM cst_cost_group_accounts

7833: else
7834: l_stmt_num := 616;
7835: SELECT nvl(purchase_price_var_account, io_ppv_acct)
7836: INTO io_ppv_acct
7837: FROM cst_cost_group_accounts
7838: WHERE cost_group_id = cg_id
7839: AND organization_id = org_id ;
7840: end if;
7841: end if; /* if (cg_id <> 1) */

Line 7851: FROM cst_cost_group_accounts

7847: then
7848: l_stmt_num := 640;
7849: SELECT count(*)
7850: INTO ccga_count
7851: FROM cst_cost_group_accounts
7852: WHERE cost_group_id = cg_id
7853: AND organization_id = org_id;
7854:
7855: l_stmt_num := 650;

Line 7869: FROM cst_cost_group_accounts

7865: then
7866: l_stmt_num := 655;
7867: SELECT nvl(purchase_price_var_account, io_ppv_acct)
7868: INTO io_ppv_acct
7869: FROM cst_cost_group_accounts
7870: WHERE cost_group_id = cg_id
7871: AND organization_id = org_id ;
7872: end if; /* if(subinv.len > 0) */
7873: end if; /* if (ccga_count = 0) */