APPS.CSTPLVCP dependencies on MTL_SYSTEM_ITEMS

Line 602: from mtl_system_items

598: l_std_org := i_txn_org_id;
599: l_stmt_num := 102;
600: select decode(inventory_asset_flag, 'Y', 0, 1)
601: into l_to_std_exp
602: from mtl_system_items
603: where inventory_item_id = i_item_id
604: and organization_id = l_std_org;
605:
606: l_stmt_num := 103;

Line 1081: from mtl_system_items

1077: if (l_std_org = i_txn_org_id) then
1078: l_stmt_num := 20;
1079: select decode(inventory_asset_flag, 'Y', 0, 1)
1080: into l_std_exp
1081: from mtl_system_items
1082: where inventory_item_id = i_item_id
1083: and organization_id = l_std_org;
1084:
1085: l_stmt_num := 30;

Line 1126: from mtl_system_items

1122: l_stmt_num := 40;
1123:
1124: select decode(inventory_asset_flag, 'Y',0,1)
1125: into o_exp_flag
1126: from mtl_system_items
1127: where inventory_item_id = i_item_id
1128: and organization_id = i_org_id;
1129: end if;
1130:

Line 1342: from mtl_system_items

1338: -- = 1 to later insert into mcacd from mcacd.
1339: l_stmt_num := 102;
1340: select decode(inventory_asset_flag, 'Y', 0, 1)
1341: into l_to_std_exp
1342: from mtl_system_items
1343: where inventory_item_id = i_item_id
1344: and organization_id = l_std_org;
1345: end if;
1346: if (l_to_std_exp = 1) then

Line 1986: from mtl_system_items

1982:
1983: l_stmt_num := 230;
1984: select decode(inventory_asset_flag, 'Y', 0, 1)
1985: into l_txfr_std_exp
1986: from mtl_system_items
1987: where inventory_item_id = i_item_id
1988: and organization_id = l_std_org;
1989:
1990: l_stmt_num := 240;

Line 2355: from mtl_system_items

2351: l_stmt_num := 10;
2352:
2353: select primary_uom_code
2354: into o_snd_uom
2355: from mtl_system_items
2356: where organization_id = i_from_org
2357: and inventory_item_id = i_item_id;
2358:
2359: l_stmt_num := 20;

Line 2363: from mtl_system_items

2359: l_stmt_num := 20;
2360:
2361: select primary_uom_code
2362: into o_rcv_uom
2363: from mtl_system_items
2364: where organization_id = i_to_org
2365: and inventory_item_id = i_item_id;
2366:
2367: EXCEPTION

Line 2989: from mtl_system_items

2985: l_stmt_num := 20;
2986:
2987: select decode(inventory_asset_flag, 'Y',0,1)
2988: into l_exp_item
2989: from mtl_system_items
2990: where inventory_item_id = i_item_id
2991: and organization_id = i_org_id;
2992:
2993: -- check if subinventory is an expense sub.

Line 4374: from mtl_system_items

4370: if (i_txn_action_id = 22 or i_txn_action_id = 15)
4371: then
4372: select decode(inventory_asset_flag, 'Y',0,1)
4373: into o_exp_flag
4374: from mtl_system_items
4375: where inventory_item_id = i_item_id
4376: and organization_id = i_org_id;
4377: end if;
4378: