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 MTL_SECONDARY_INVENTORIES

Line 970: from mtl_secondary_inventories

966: l_stmt_num := 10;
967:
968: select decode(asset_inventory,1,0,1)
969: into l_exp_sub1
970: from mtl_secondary_inventories
971: where secondary_inventory_name = i_subinv
972: and organization_id = i_org_id;
973:
974: if (l_wms_flg = 0) then

Line 977: from mtl_secondary_inventories

973:
974: if (l_wms_flg = 0) then
975: select nvl(expense_account, -1)
976: into l_exp_acct1
977: from mtl_secondary_inventories
978: where secondary_inventory_name = i_subinv
979: and organization_id = i_org_id;
980: else
981: if (i_cost_grp_id = 1) then

Line 1337: from mtl_secondary_inventories

1333: -- Scrap transactions do not have inventory impact!!
1334: if (i_txn_act_id <> 30) then
1335: select decode(asset_inventory,1,0,1)
1336: into l_exp_sub
1337: from mtl_secondary_inventories
1338: where secondary_inventory_name = i_subinv
1339: and organization_id = i_org_id;
1340:
1341: if (l_wms_flg = 0) then

Line 1344: from mtl_secondary_inventories

1340:
1341: if (l_wms_flg = 0) then
1342: select nvl(expense_account, -1)
1343: into l_exp_acct
1344: from mtl_secondary_inventories
1345: where secondary_inventory_name = i_subinv
1346: and organization_id = i_org_id;
1347: else
1348: if (i_cost_grp_id = 1) then

Line 1572: from mtl_secondary_inventories

1568: l_stmt_num := 10;
1569:
1570: select decode(asset_inventory,1,0,1)
1571: into l_exp_sub1
1572: from mtl_secondary_inventories
1573: where secondary_inventory_name = i_subinv
1574: and organization_id = i_org_id;
1575:
1576: l_stmt_num := 20;

Line 1579: from mtl_secondary_inventories

1575:
1576: l_stmt_num := 20;
1577: select decode(asset_inventory,1,0,1)
1578: into l_exp_sub2
1579: from mtl_secondary_inventories
1580: where secondary_inventory_name = nvl(i_txf_subinv,i_subinv)
1581: and organization_id = i_org_id;
1582:
1583: if (l_wms_flg = 0) then

Line 1586: from mtl_secondary_inventories

1582:
1583: if (l_wms_flg = 0) then
1584: select nvl(expense_account, -1)
1585: into l_exp_acct1
1586: from mtl_secondary_inventories
1587: where secondary_inventory_name = i_subinv
1588: and organization_id = i_org_id;
1589:
1590: select nvl(expense_account, -1)

Line 1592: from mtl_secondary_inventories

1588: and organization_id = i_org_id;
1589:
1590: select nvl(expense_account, -1)
1591: into l_exp_acct2
1592: from mtl_secondary_inventories
1593: where secondary_inventory_name = nvl(i_txf_subinv,i_subinv)
1594: and organization_id = i_org_id;
1595:
1596: else

Line 1774: from mtl_secondary_inventories

1770: l_stmt_num := 10;
1771:
1772: select decode(asset_inventory,1,0,1)
1773: into l_exp_sub
1774: from mtl_secondary_inventories
1775: where secondary_inventory_name = i_subinv
1776: and organization_id = i_org_id;
1777:
1778: if (l_wms_flg = 0) then

Line 1782: from mtl_secondary_inventories

1778: if (l_wms_flg = 0) then
1779: l_stmt_num := 11;
1780: select nvl(expense_account, -1)
1781: into l_exp_acct
1782: from mtl_secondary_inventories
1783: where secondary_inventory_name = i_subinv AND
1784: organization_id = i_org_id;
1785: else
1786: if (i_cost_grp_id = 1) then

Line 2572: from mtl_secondary_inventories

2568:
2569: else
2570: select decode(asset_inventory,1,0,1)
2571: into l_exp_sub
2572: from mtl_secondary_inventories
2573: where secondary_inventory_name = l_subinv
2574: and organization_id = i_org_id;
2575:
2576: if (l_wms_flg = 0) then

Line 2579: from mtl_secondary_inventories

2575:
2576: if (l_wms_flg = 0) then
2577: select nvl(expense_account, l_exp_acct)
2578: into l_exp_acct
2579: from mtl_secondary_inventories
2580: where secondary_inventory_name = l_subinv
2581: and organization_id = i_org_id;
2582: else
2583: if (i_cost_grp_id = 1) then

Line 2803: from mtl_secondary_inventories msi

2799: l_subinv := i_subinv;
2800:
2801: select decode(asset_inventory,1,0,1)
2802: into l_std_exp_sub
2803: from mtl_secondary_inventories msi
2804: where msi.organization_id = l_std_org
2805: and secondary_inventory_name = l_subinv;
2806:
2807: /* Changes for PJM for Standard Costing */

Line 2815: from mtl_secondary_inventories msi

2811: nvl(expense_account, l_std_exp_acct)
2812: into l_std_mat_acct, l_std_mat_ovhd_acct, l_std_res_acct,
2813: l_std_osp_acct, l_std_ovhd_acct,
2814: l_std_exp_acct
2815: from mtl_secondary_inventories msi
2816: where msi.organization_id = l_std_org
2817: and secondary_inventory_name = l_subinv;
2818: else
2819: select decode(l_std_org,l_from_org,l_from_cost_grp,l_to_cost_grp)

Line 5334: FROM mtl_secondary_inventories

5330: nvl(resource_account, -1),
5331: nvl(outside_processing_account, -1),
5332: nvl(overhead_account, -1)
5333: INTO l_mat_acct, l_mat_ovhd_acct, l_res_acct, l_osp_acct, l_ovhd_acct
5334: FROM mtl_secondary_inventories
5335: WHERE organization_id = i_org_id
5336: and secondary_inventory_name = i_subinv;
5337: else
5338: if (l_cost_grp_id = 1) then

Line 7542: FROM mtl_secondary_inventories

7538: SELECT DECODE(txn_act_id, 3, DECODE(iexp_flg,1,1,DECODE(asset_inventory,1,0,1)),
7539: iexp_flg),
7540: DECODE(asset_inventory,1,0,1)
7541: INTO exp_flg, exp_sub
7542: FROM mtl_secondary_inventories
7543: WHERE secondary_inventory_name = subinv
7544: AND organization_id = org_id;
7545: end if;
7546:

Line 7576: from mtl_secondary_inventories msi

7572: nvl(expense_account, exp_acct)
7573: into mat_acct, mat_ovhd_acct, res_acct,
7574: osp_acct, ovhd_acct,
7575: exp_acct
7576: from mtl_secondary_inventories msi
7577: where msi.organization_id = org_id
7578: and secondary_inventory_name = subinv;
7579: end if;
7580: else