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 879: from mtl_secondary_inventories

875: l_stmt_num := 10;
876:
877: select decode(asset_inventory,1,0,1)
878: into l_exp_sub1
879: from mtl_secondary_inventories
880: where secondary_inventory_name = i_subinv
881: and organization_id = i_org_id;
882:
883: if (l_wms_flg = 0) then

Line 886: from mtl_secondary_inventories

882:
883: if (l_wms_flg = 0) then
884: select nvl(expense_account, -1)
885: into l_exp_acct1
886: from mtl_secondary_inventories
887: where secondary_inventory_name = i_subinv
888: and organization_id = i_org_id;
889: else
890: if (i_cost_grp_id = 1) then

Line 1246: from mtl_secondary_inventories

1242: -- Scrap transactions do not have inventory impact!!
1243: if (i_txn_act_id <> 30) then
1244: select decode(asset_inventory,1,0,1)
1245: into l_exp_sub
1246: from mtl_secondary_inventories
1247: where secondary_inventory_name = i_subinv
1248: and organization_id = i_org_id;
1249:
1250: if (l_wms_flg = 0) then

Line 1253: from mtl_secondary_inventories

1249:
1250: if (l_wms_flg = 0) then
1251: select nvl(expense_account, -1)
1252: into l_exp_acct
1253: from mtl_secondary_inventories
1254: where secondary_inventory_name = i_subinv
1255: and organization_id = i_org_id;
1256: else
1257: if (i_cost_grp_id = 1) then

Line 1481: from mtl_secondary_inventories

1477: l_stmt_num := 10;
1478:
1479: select decode(asset_inventory,1,0,1)
1480: into l_exp_sub1
1481: from mtl_secondary_inventories
1482: where secondary_inventory_name = i_subinv
1483: and organization_id = i_org_id;
1484:
1485: l_stmt_num := 20;

Line 1488: from mtl_secondary_inventories

1484:
1485: l_stmt_num := 20;
1486: select decode(asset_inventory,1,0,1)
1487: into l_exp_sub2
1488: from mtl_secondary_inventories
1489: where secondary_inventory_name = nvl(i_txf_subinv,i_subinv)
1490: and organization_id = i_org_id;
1491:
1492: if (l_wms_flg = 0) then

Line 1495: from mtl_secondary_inventories

1491:
1492: if (l_wms_flg = 0) then
1493: select nvl(expense_account, -1)
1494: into l_exp_acct1
1495: from mtl_secondary_inventories
1496: where secondary_inventory_name = i_subinv
1497: and organization_id = i_org_id;
1498:
1499: select nvl(expense_account, -1)

Line 1501: from mtl_secondary_inventories

1497: and organization_id = i_org_id;
1498:
1499: select nvl(expense_account, -1)
1500: into l_exp_acct2
1501: from mtl_secondary_inventories
1502: where secondary_inventory_name = i_txf_subinv
1503: and organization_id = i_org_id;
1504:
1505: else

Line 1683: from mtl_secondary_inventories

1679: l_stmt_num := 10;
1680:
1681: select decode(asset_inventory,1,0,1)
1682: into l_exp_sub
1683: from mtl_secondary_inventories
1684: where secondary_inventory_name = i_subinv
1685: and organization_id = i_org_id;
1686:
1687: if (l_wms_flg = 0) then

Line 1691: from mtl_secondary_inventories

1687: if (l_wms_flg = 0) then
1688: l_stmt_num := 11;
1689: select nvl(expense_account, -1)
1690: into l_exp_acct
1691: from mtl_secondary_inventories
1692: where secondary_inventory_name = i_subinv AND
1693: organization_id = i_org_id;
1694: else
1695: if (i_cost_grp_id = 1) then

Line 2481: from mtl_secondary_inventories

2477:
2478: else
2479: select decode(asset_inventory,1,0,1)
2480: into l_exp_sub
2481: from mtl_secondary_inventories
2482: where secondary_inventory_name = l_subinv
2483: and organization_id = i_org_id;
2484:
2485: if (l_wms_flg = 0) then

Line 2488: from mtl_secondary_inventories

2484:
2485: if (l_wms_flg = 0) then
2486: select nvl(expense_account, l_exp_acct)
2487: into l_exp_acct
2488: from mtl_secondary_inventories
2489: where secondary_inventory_name = l_subinv
2490: and organization_id = i_org_id;
2491: else
2492: if (i_cost_grp_id = 1) then

Line 2712: from mtl_secondary_inventories msi

2708: l_subinv := i_subinv;
2709:
2710: select decode(asset_inventory,1,0,1)
2711: into l_std_exp_sub
2712: from mtl_secondary_inventories msi
2713: where msi.organization_id = l_std_org
2714: and secondary_inventory_name = l_subinv;
2715:
2716: /* Changes for PJM for Standard Costing */

Line 2724: from mtl_secondary_inventories msi

2720: nvl(expense_account, l_std_exp_acct)
2721: into l_std_mat_acct, l_std_mat_ovhd_acct, l_std_res_acct,
2722: l_std_osp_acct, l_std_ovhd_acct,
2723: l_std_exp_acct
2724: from mtl_secondary_inventories msi
2725: where msi.organization_id = l_std_org
2726: and secondary_inventory_name = l_subinv;
2727: else
2728: select decode(l_std_org,l_from_org,l_from_cost_grp,l_to_cost_grp)

Line 5242: FROM mtl_secondary_inventories

5238: nvl(resource_account, -1),
5239: nvl(outside_processing_account, -1),
5240: nvl(overhead_account, -1)
5241: INTO l_mat_acct, l_mat_ovhd_acct, l_res_acct, l_osp_acct, l_ovhd_acct
5242: FROM mtl_secondary_inventories
5243: WHERE organization_id = i_org_id
5244: and secondary_inventory_name = i_subinv;
5245: else
5246: if (l_cost_grp_id = 1) then

Line 7343: FROM mtl_secondary_inventories

7339: SELECT DECODE(txn_act_id, 3, DECODE(iexp_flg,1,1,DECODE(asset_inventory,1,0,1)),
7340: iexp_flg),
7341: DECODE(asset_inventory,1,0,1)
7342: INTO exp_flg, exp_sub
7343: FROM mtl_secondary_inventories
7344: WHERE secondary_inventory_name = subinv
7345: AND organization_id = org_id;
7346: end if;
7347:

Line 7377: from mtl_secondary_inventories msi

7373: nvl(expense_account, exp_acct)
7374: into mat_acct, mat_ovhd_acct, res_acct,
7375: osp_acct, ovhd_acct,
7376: exp_acct
7377: from mtl_secondary_inventories msi
7378: where msi.organization_id = org_id
7379: and secondary_inventory_name = subinv;
7380: end if;
7381: else