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 1838: from mtl_system_items

1834: l_stmt_num := 20;
1835:
1836: select nvl(expense_account, -1)
1837: into l_exp_acct
1838: from mtl_system_items
1839: where inventory_item_id = i_item_id
1840: and organization_id = i_org_id;
1841: end if;
1842:

Line 1942: from mtl_system_items msi,

1938: l_stmt_num := 40;
1939:
1940: select nvl(msi.cost_of_sales_account, mp.cost_of_sales_account)
1941: into l_acct
1942: from mtl_system_items msi,
1943: mtl_parameters mp
1944: where msi.organization_id = i_org_id
1945: and msi.inventory_item_id = i_item_id
1946: and mp.organization_id = msi.organization_id;

Line 2544: from mtl_system_items

2540: l_stmt_num := 5;
2541: if (i_exp_item = 1) then
2542: select nvl(expense_account, -1)
2543: into l_exp_acct
2544: from mtl_system_items
2545: where inventory_item_id = i_item_id
2546: and organization_id = i_org_id;
2547: end if;
2548:

Line 2774: from mtl_system_items

2770: if (l_std_org <> -1) then
2771: l_stmt_num := 45;
2772: select decode(inventory_asset_flag, 'Y', 0,1), nvl(expense_account, -1)
2773: into l_std_exp_item, l_std_exp_acct
2774: from mtl_system_items
2775: where inventory_item_id = i_item_id
2776: and organization_id = l_std_org;
2777:
2778: -- if the standard org is the transaction org id then need to find out

Line 7519: FROM mtl_system_items_b

7515: +----------------------------------------------------------------------*/
7516: l_stmt_num := 160;
7517: select decode(inventory_asset_flag,'Y',0,1), nvl(expense_account, -1)
7518: INTO iexp_flg, exp_acct
7519: FROM mtl_system_items_b
7520: WHERE inventory_item_id = item_id
7521: AND organization_id = org_id;
7522:
7523:

Line 7730: FROM mtl_system_items_b send, mtl_system_items_b rec

7726: +----------------------------------------------------------------------*/
7727: l_stmt_num := 460;
7728: select send.primary_uom_code, rec.primary_uom_code
7729: INTO send_uom, rec_uom
7730: FROM mtl_system_items_b send, mtl_system_items_b rec
7731: WHERE send.inventory_item_id = item_id
7732: AND send.organization_id = from_org
7733: AND rec.inventory_item_id = item_id
7734: AND rec.organization_id = to_org;