APPS.CSTPAPBR dependencies on MTL_SYSTEM_ITEMS

Line 183: mtl_system_items msi

179: l_ae_txn_rec.cogs_percentage,
180: l_ae_txn_rec.expense_account_id
181: FROM
182: mtl_material_transactions mmt,
183: mtl_system_items msi
184: WHERE
185: mmt.inventory_item_id = msi.inventory_item_id AND
186: mmt.organization_id = msi.organization_id AND
187: mmt.transaction_id = i_transaction_id;

Line 376: mtl_system_items msi,

372: decode(msi.inventory_asset_flag,'Y',0,1)
373: INTO
374: l_ae_txn_rec.exp_item
375: FROM
376: mtl_system_items msi,
377: wip_transactions wt
378: WHERE
379: msi.inventory_item_id = wt.primary_item_id AND
380: wt.organization_id = msi.organization_id AND

Line 2071: from mtl_system_items

2067:
2068: if ((l_fob_point = 1 and i_ae_txn_rec.txn_action_id = 21) or (l_fob_point = 2 and i_ae_txn_rec.txn_action_id = 12)) then
2069: select decode(inventory_asset_flag,'Y',0,1)
2070: into l_exp2
2071: from mtl_system_items
2072: where inventory_item_id = i_ae_txn_rec.inventory_item_id
2073: and organization_id = i_ae_txn_rec.xfer_organization_id;
2074: elsif ((l_fob_point = 2 and i_ae_txn_rec.txn_action_id = 21) or (l_fob_point = 1 and i_ae_txn_rec.txn_action_id = 12)) then
2075: select decode(inventory_asset_flag,'Y',0,1)

Line 2077: from mtl_system_items

2073: and organization_id = i_ae_txn_rec.xfer_organization_id;
2074: elsif ((l_fob_point = 2 and i_ae_txn_rec.txn_action_id = 21) or (l_fob_point = 1 and i_ae_txn_rec.txn_action_id = 12)) then
2075: select decode(inventory_asset_flag,'Y',0,1)
2076: into l_exp2
2077: from mtl_system_items
2078: where inventory_item_id = i_ae_txn_rec.inventory_item_id
2079: and organization_id = i_ae_txn_rec.organization_id;
2080: end if;
2081:

Line 2224: FROM mtl_system_items

2220: than the cost group of the transaction org. */
2221: IF (i_ae_txn_rec.cost_group_id <> l_txn_cost_group_id) THEN
2222: SELECT decode(inventory_asset_flag, 'Y', 0, 1)
2223: INTO l_cg_exp_item
2224: FROM mtl_system_items
2225: WHERE organization_id = i_ae_txn_rec.xfer_organization_id
2226: AND inventory_item_id = i_ae_txn_rec.inventory_item_id;
2227: ELSE
2228: l_cg_exp_item := i_ae_txn_rec.exp_item;

Line 6710: from mtl_system_items msi,

6706: l_stmt_num := 45;
6707:
6708: select nvl(msi.cost_of_sales_account, mp.cost_of_sales_account)
6709: into l_acct_rec.account
6710: from mtl_system_items msi,
6711: mtl_parameters mp
6712: where msi.organization_id = i_ae_txn_rec.organization_id
6713: and msi.inventory_item_id = i_ae_txn_rec.inventory_item_id
6714: and mp.organization_id = msi.organization_id;

Line 9615: FROM mtl_system_items MSI, mtl_parameters MP

9611: l_stmt_num := 90;
9612:
9613: SELECT nvl(MSI.cost_of_sales_account, MP.cost_of_sales_account)
9614: INTO l_cogs_ccid
9615: FROM mtl_system_items MSI, mtl_parameters MP
9616: WHERE MSI.organization_id = l_from_org
9617: AND MSI.inventory_item_id = i_ae_txn_rec.inventory_item_id
9618: AND MP.organization_id = MSI.organization_id;
9619:

Line 10959: p_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,

10955: PROCEDURE CompEncumbrance_IntOrdersExp (
10956: p_api_version IN NUMBER,
10957: p_transaction_id IN MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID%TYPE,
10958: p_req_line_id IN PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE,
10959: p_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,
10960: p_organization_id IN MTL_PARAMETERS.ORGANIZATION_ID%TYPE,
10961: p_primary_qty IN MTL_MATERIAL_TRANSACTIONS.PRIMARY_QUANTITY%TYPE,
10962: p_total_primary_qty IN NUMBER,
10963: x_encumbrance_amount OUT NOCOPY NUMBER,

Line 11035: FROM mtl_system_items

11031: /* Get UOM for this item/org from MSI */
11032: l_stmt_num := 30;
11033: SELECT primary_uom_code
11034: INTO l_primary_uom_code
11035: FROM mtl_system_items
11036: WHERE organization_id = p_organization_id
11037: AND inventory_item_id = p_item_id;
11038:
11039: /* Convert the total_primary_quantity into source_doc_quantity */