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

1427:
1428: l_stmt_num := 20;
1429: select decode(inventory_asset_flag, 'Y',0,1)
1430: into l_exp_item
1431: from mtl_system_items
1432: where inventory_item_id = i_item_id
1433: and organization_id = i_org_id;
1434:
1435: if (g_debug = 'Y') then

Line 4097: FROM mtl_system_items

4093: l_stmt_num := 33;
4094:
4095: SELECT inventory_asset_flag
4096: INTO l_asset_item_flag
4097: FROM mtl_system_items
4098: WHERE organization_id = i_org_id
4099: AND inventory_item_id = (SELECT inventory_item_id
4100: FROM mtl_material_transactions
4101: WHERE transaction_id = i_txn_id);

Line 4724: from mtl_system_items

4720: if (l_std_org = i_txn_org_id) then
4721: l_stmt_num := 20;
4722: select decode(inventory_asset_flag, 'Y', 0, 1)
4723: into l_std_exp
4724: from mtl_system_items
4725: where inventory_item_id = i_item_id
4726: and organization_id = l_std_org;
4727:
4728: l_stmt_num := 30;

Line 4777: from mtl_system_items

4773: l_stmt_num := 40;
4774:
4775: select decode(inventory_asset_flag, 'Y',0,1)
4776: into o_exp_flag
4777: from mtl_system_items
4778: where inventory_item_id = i_item_id
4779: and organization_id = i_org_id;
4780: end if;
4781:

Line 4895: from mtl_system_items

4891: -- set l_to_std_exp = 1 to later insert into mcacd from mctcd.
4892: l_stmt_num := 102;
4893: select decode(inventory_asset_flag, 'Y', 0, 1)
4894: into l_to_std_exp
4895: from mtl_system_items
4896: where inventory_item_id = i_item_id
4897: and organization_id = l_std_org;
4898: end if;
4899: if (l_to_std_exp = 1) then

Line 5519: from mtl_system_items

5515: if (l_std_org = i_txfr_org_id and i_txn_action_id = 3) then
5516: l_stmt_num := 170;
5517: select decode(inventory_asset_flag, 'Y', 0, 1)
5518: into l_txfr_std_exp
5519: from mtl_system_items
5520: where inventory_item_id = i_item_id
5521: and organization_id = l_std_org;
5522:
5523: l_stmt_num := 180;

Line 5987: from mtl_system_items

5983: l_stmt_num := 10;
5984:
5985: select primary_uom_code
5986: into o_snd_uom
5987: from mtl_system_items
5988: where organization_id = i_from_org
5989: and inventory_item_id = i_item_id;
5990:
5991: l_stmt_num := 20;

Line 5995: from mtl_system_items

5991: l_stmt_num := 20;
5992:
5993: select primary_uom_code
5994: into o_rcv_uom
5995: from mtl_system_items
5996: where organization_id = i_to_org
5997: and inventory_item_id = i_item_id;
5998:
5999: /* IF g_debug = 'Y' THEN

Line 6800: mtl_system_items_b msi

6796: NVL(mp.AVG_RATES_COST_TYPE_ID, -1) "AVG_RATES_COST_TYPE_ID",
6797: decode(msi.INVENTORY_ASSET_FLAG,'Y',0,1) "EXP_ITEM"
6798: FROM mtl_material_transactions mmt,
6799: mtl_parameters mp,
6800: mtl_system_items_b msi
6801: WHERE mmt.organization_id = mp.organization_id
6802: AND mmt.inventory_item_id = msi.inventory_item_id
6803: AND mmt.organization_id = msi.organization_id
6804: AND (( p_parent_id is not null and

Line 6887: FROM MTL_SYSTEM_ITEMS

6883: -------------------------------------------------------------------------
6884: l_stmt_num := 17;
6885: SELECT decode(INVENTORY_ASSET_FLAG,'Y',0,1)
6886: INTO l_exp_item
6887: FROM MTL_SYSTEM_ITEMS
6888: WHERE INVENTORY_ITEM_ID = c_mmt_txn_rec.inventory_item_id
6889: AND ORGANIZATION_ID = c_mmt_txn_rec.organization_id;
6890:
6891: if (c_mmt_txn_rec.subinventory_code is null) then

Line 8126: l_exp_item MTL_SYSTEM_ITEMS.INVENTORY_ASSET_FLAG%TYPE;

8122: l_conversion_rate NUMBER;
8123: l_conversion_type VARCHAR2(30);
8124: l_sending_curr VARCHAR2(15);
8125:
8126: l_exp_item MTL_SYSTEM_ITEMS.INVENTORY_ASSET_FLAG%TYPE;
8127: l_exp_flag VARCHAR2(1);
8128: l_subinventory_code MTL_MATERIAL_TRANSACTIONS.SUBINVENTORY_CODE%TYPE;
8129:
8130:

Line 8262: FROM MTL_SYSTEM_ITEMS

8258:
8259: l_stmt_num := 12;
8260: SELECT INVENTORY_ASSET_FLAG
8261: INTO l_exp_item
8262: FROM MTL_SYSTEM_ITEMS
8263: WHERE INVENTORY_ITEM_ID = l_item_id
8264: AND ORGANIZATION_ID = l_parent_org_id;
8265:
8266: if ( ( l_subinventory_code is null ) or

Line 9363: p_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,

9359: PROCEDURE CompEncumbrance_IntOrdersExp (
9360: p_api_version IN NUMBER,
9361: p_transaction_id IN MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID%TYPE,
9362: p_req_line_id IN PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE,
9363: p_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,
9364: p_organization_id IN MTL_PARAMETERS.ORGANIZATION_ID%TYPE,
9365: p_primary_qty IN MTL_MATERIAL_TRANSACTIONS.PRIMARY_QUANTITY%TYPE,
9366: p_total_primary_qty IN NUMBER,
9367: x_encumbrance_amount OUT NOCOPY NUMBER,

Line 9444: FROM mtl_system_items

9440: /* Get UOM for this item/org from MSI */
9441: l_stmt_num := 30;
9442: SELECT primary_uom_code
9443: INTO l_primary_uom_code
9444: FROM mtl_system_items
9445: WHERE organization_id = p_organization_id
9446: AND inventory_item_id = p_item_id;
9447:
9448: if g_debug = 'Y' then