APPS.CSTPACDP dependencies on MTL_SYSTEM_ITEMS

Line 238: FROM mtl_system_items

234:
235: /* Check if item is NL trackable and depreciable (asset_creation_code) */
236: SELECT nvl(comms_nl_trackable_flag, 'N'), asset_creation_code
237: INTO l_nl_trackable, l_asset_creation_code
238: FROM mtl_system_items
239: WHERE inventory_item_id = l_item_id
240: AND organization_id = i_org_id;
241:
242: /* Write out log warning if Item is NL trackable or depreciable and

Line 1747: from mtl_system_items

1743: l_stmt_num := 20;
1744:
1745: select nvl(expense_account, -1)
1746: into l_exp_acct
1747: from mtl_system_items
1748: where inventory_item_id = i_item_id
1749: and organization_id = i_org_id;
1750: end if;
1751:

Line 1851: from mtl_system_items msi,

1847: l_stmt_num := 40;
1848:
1849: select nvl(msi.cost_of_sales_account, mp.cost_of_sales_account)
1850: into l_acct
1851: from mtl_system_items msi,
1852: mtl_parameters mp
1853: where msi.organization_id = i_org_id
1854: and msi.inventory_item_id = i_item_id
1855: and mp.organization_id = msi.organization_id;

Line 2453: from mtl_system_items

2449: l_stmt_num := 5;
2450: if (i_exp_item = 1) then
2451: select nvl(expense_account, -1)
2452: into l_exp_acct
2453: from mtl_system_items
2454: where inventory_item_id = i_item_id
2455: and organization_id = i_org_id;
2456: end if;
2457:

Line 2683: from mtl_system_items

2679: if (l_std_org <> -1) then
2680: l_stmt_num := 45;
2681: select decode(inventory_asset_flag, 'Y', 0,1), nvl(expense_account, -1)
2682: into l_std_exp_item, l_std_exp_acct
2683: from mtl_system_items
2684: where inventory_item_id = i_item_id
2685: and organization_id = l_std_org;
2686:
2687: -- if the standard org is the transaction org id then need to find out

Line 7320: FROM mtl_system_items_b

7316: +----------------------------------------------------------------------*/
7317: l_stmt_num := 160;
7318: select decode(inventory_asset_flag,'Y',0,1), nvl(expense_account, -1)
7319: INTO iexp_flg, exp_acct
7320: FROM mtl_system_items_b
7321: WHERE inventory_item_id = item_id
7322: AND organization_id = org_id;
7323:
7324:

Line 7531: FROM mtl_system_items_b send, mtl_system_items_b rec

7527: +----------------------------------------------------------------------*/
7528: l_stmt_num := 460;
7529: select send.primary_uom_code, rec.primary_uom_code
7530: INTO send_uom, rec_uom
7531: FROM mtl_system_items_b send, mtl_system_items_b rec
7532: WHERE send.inventory_item_id = item_id
7533: AND send.organization_id = from_org
7534: AND rec.inventory_item_id = item_id
7535: AND rec.organization_id = to_org;