APPS.CSTPLVCP dependencies on MTL_SYSTEM_ITEMS

Line 668: from mtl_system_items

664: l_std_org := i_txn_org_id;
665: l_stmt_num := 102;
666: select decode(inventory_asset_flag, 'Y', 0, 1)
667: into l_to_std_exp
668: from mtl_system_items
669: where inventory_item_id = i_item_id
670: and organization_id = l_std_org;
671:
672: l_stmt_num := 103;

Line 1147: from mtl_system_items

1143: if (l_std_org = i_txn_org_id) then
1144: l_stmt_num := 20;
1145: select decode(inventory_asset_flag, 'Y', 0, 1)
1146: into l_std_exp
1147: from mtl_system_items
1148: where inventory_item_id = i_item_id
1149: and organization_id = l_std_org;
1150:
1151: l_stmt_num := 30;

Line 1192: from mtl_system_items

1188: l_stmt_num := 40;
1189:
1190: select decode(inventory_asset_flag, 'Y',0,1)
1191: into o_exp_flag
1192: from mtl_system_items
1193: where inventory_item_id = i_item_id
1194: and organization_id = i_org_id;
1195: end if;
1196:

Line 1408: from mtl_system_items

1404: -- = 1 to later insert into mcacd from mcacd.
1405: l_stmt_num := 102;
1406: select decode(inventory_asset_flag, 'Y', 0, 1)
1407: into l_to_std_exp
1408: from mtl_system_items
1409: where inventory_item_id = i_item_id
1410: and organization_id = l_std_org;
1411: end if;
1412: if (l_to_std_exp = 1) then

Line 2052: from mtl_system_items

2048:
2049: l_stmt_num := 230;
2050: select decode(inventory_asset_flag, 'Y', 0, 1)
2051: into l_txfr_std_exp
2052: from mtl_system_items
2053: where inventory_item_id = i_item_id
2054: and organization_id = l_std_org;
2055:
2056: l_stmt_num := 240;

Line 2421: from mtl_system_items

2417: l_stmt_num := 10;
2418:
2419: select primary_uom_code
2420: into o_snd_uom
2421: from mtl_system_items
2422: where organization_id = i_from_org
2423: and inventory_item_id = i_item_id;
2424:
2425: l_stmt_num := 20;

Line 2429: from mtl_system_items

2425: l_stmt_num := 20;
2426:
2427: select primary_uom_code
2428: into o_rcv_uom
2429: from mtl_system_items
2430: where organization_id = i_to_org
2431: and inventory_item_id = i_item_id;
2432:
2433: EXCEPTION

Line 3055: from mtl_system_items

3051: l_stmt_num := 20;
3052:
3053: select decode(inventory_asset_flag, 'Y',0,1)
3054: into l_exp_item
3055: from mtl_system_items
3056: where inventory_item_id = i_item_id
3057: and organization_id = i_org_id;
3058:
3059: -- check if subinventory is an expense sub.

Line 4441: from mtl_system_items

4437: if (i_txn_action_id = 22 or i_txn_action_id = 15)
4438: then
4439: select decode(inventory_asset_flag, 'Y',0,1)
4440: into o_exp_flag
4441: from mtl_system_items
4442: where inventory_item_id = i_item_id
4443: and organization_id = i_org_id;
4444: end if;
4445: