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.CSTPAVCP dependencies on MTL_SYSTEM_ITEMS

Line 1279: from mtl_system_items

1275:
1276: l_stmt_num := 20;
1277: select decode(inventory_asset_flag, 'Y',0,1)
1278: into l_exp_item
1279: from mtl_system_items
1280: where inventory_item_id = i_item_id
1281: and organization_id = i_org_id;
1282:
1283: if (g_debug = 'Y') then

Line 3926: FROM mtl_system_items

3922: l_stmt_num := 33;
3923:
3924: SELECT inventory_asset_flag
3925: INTO l_asset_item_flag
3926: FROM mtl_system_items
3927: WHERE organization_id = i_org_id
3928: AND inventory_item_id = (SELECT inventory_item_id
3929: FROM mtl_material_transactions
3930: WHERE transaction_id = i_txn_id);

Line 4549: from mtl_system_items

4545: if (l_std_org = i_txn_org_id) then
4546: l_stmt_num := 20;
4547: select decode(inventory_asset_flag, 'Y', 0, 1)
4548: into l_std_exp
4549: from mtl_system_items
4550: where inventory_item_id = i_item_id
4551: and organization_id = l_std_org;
4552:
4553: l_stmt_num := 30;

Line 4602: from mtl_system_items

4598: l_stmt_num := 40;
4599:
4600: select decode(inventory_asset_flag, 'Y',0,1)
4601: into o_exp_flag
4602: from mtl_system_items
4603: where inventory_item_id = i_item_id
4604: and organization_id = i_org_id;
4605: end if;
4606:

Line 4720: from mtl_system_items

4716: -- set l_to_std_exp = 1 to later insert into mcacd from mctcd.
4717: l_stmt_num := 102;
4718: select decode(inventory_asset_flag, 'Y', 0, 1)
4719: into l_to_std_exp
4720: from mtl_system_items
4721: where inventory_item_id = i_item_id
4722: and organization_id = l_std_org;
4723: end if;
4724: if (l_to_std_exp = 1) then

Line 5326: from mtl_system_items

5322: if (l_std_org = i_txfr_org_id and i_txn_action_id = 3) then
5323: l_stmt_num := 170;
5324: select decode(inventory_asset_flag, 'Y', 0, 1)
5325: into l_txfr_std_exp
5326: from mtl_system_items
5327: where inventory_item_id = i_item_id
5328: and organization_id = l_std_org;
5329:
5330: l_stmt_num := 180;

Line 5794: from mtl_system_items

5790: l_stmt_num := 10;
5791:
5792: select primary_uom_code
5793: into o_snd_uom
5794: from mtl_system_items
5795: where organization_id = i_from_org
5796: and inventory_item_id = i_item_id;
5797:
5798: l_stmt_num := 20;

Line 5802: from mtl_system_items

5798: l_stmt_num := 20;
5799:
5800: select primary_uom_code
5801: into o_rcv_uom
5802: from mtl_system_items
5803: where organization_id = i_to_org
5804: and inventory_item_id = i_item_id;
5805:
5806: /* IF g_debug = 'Y' THEN

Line 6607: mtl_system_items_b msi

6603: NVL(mp.AVG_RATES_COST_TYPE_ID, -1) "AVG_RATES_COST_TYPE_ID",
6604: decode(msi.INVENTORY_ASSET_FLAG,'Y',0,1) "EXP_ITEM"
6605: FROM mtl_material_transactions mmt,
6606: mtl_parameters mp,
6607: mtl_system_items_b msi
6608: WHERE mmt.organization_id = mp.organization_id
6609: AND mmt.inventory_item_id = msi.inventory_item_id
6610: AND mmt.organization_id = msi.organization_id
6611: AND (( p_parent_id is not null and

Line 6694: FROM MTL_SYSTEM_ITEMS

6690: -------------------------------------------------------------------------
6691: l_stmt_num := 17;
6692: SELECT decode(INVENTORY_ASSET_FLAG,'Y',0,1)
6693: INTO l_exp_item
6694: FROM MTL_SYSTEM_ITEMS
6695: WHERE INVENTORY_ITEM_ID = c_mmt_txn_rec.inventory_item_id
6696: AND ORGANIZATION_ID = c_mmt_txn_rec.organization_id;
6697:
6698: if (c_mmt_txn_rec.subinventory_code is null) then

Line 7931: l_exp_item MTL_SYSTEM_ITEMS.INVENTORY_ASSET_FLAG%TYPE;

7927: l_conversion_rate NUMBER;
7928: l_conversion_type VARCHAR2(30);
7929: l_sending_curr VARCHAR2(15);
7930:
7931: l_exp_item MTL_SYSTEM_ITEMS.INVENTORY_ASSET_FLAG%TYPE;
7932: l_exp_flag VARCHAR2(1);
7933: l_subinventory_code MTL_MATERIAL_TRANSACTIONS.SUBINVENTORY_CODE%TYPE;
7934:
7935:

Line 8067: FROM MTL_SYSTEM_ITEMS

8063:
8064: l_stmt_num := 12;
8065: SELECT INVENTORY_ASSET_FLAG
8066: INTO l_exp_item
8067: FROM MTL_SYSTEM_ITEMS
8068: WHERE INVENTORY_ITEM_ID = l_item_id
8069: AND ORGANIZATION_ID = l_parent_org_id;
8070:
8071: if ( ( l_subinventory_code is null ) or

Line 9166: p_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,

9162: PROCEDURE CompEncumbrance_IntOrdersExp (
9163: p_api_version IN NUMBER,
9164: p_transaction_id IN MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID%TYPE,
9165: p_req_line_id IN PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE,
9166: p_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,
9167: p_organization_id IN MTL_PARAMETERS.ORGANIZATION_ID%TYPE,
9168: p_primary_qty IN MTL_MATERIAL_TRANSACTIONS.PRIMARY_QUANTITY%TYPE,
9169: p_total_primary_qty IN NUMBER,
9170: x_encumbrance_amount OUT NOCOPY NUMBER,

Line 9247: FROM mtl_system_items

9243: /* Get UOM for this item/org from MSI */
9244: l_stmt_num := 30;
9245: SELECT primary_uom_code
9246: INTO l_primary_uom_code
9247: FROM mtl_system_items
9248: WHERE organization_id = p_organization_id
9249: AND inventory_item_id = p_item_id;
9250:
9251: if g_debug = 'Y' then