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 370: mtl_system_items msi,

366: decode(msi.inventory_asset_flag,'Y',0,1)
367: INTO
368: l_ae_txn_rec.exp_item
369: FROM
370: mtl_system_items msi,
371: wip_transactions wt
372: WHERE
373: msi.inventory_item_id = wt.primary_item_id AND
374: wt.organization_id = msi.organization_id AND

Line 1942: FROM mtl_system_items

1938: than the cost group of the transaction org. */
1939: IF (i_ae_txn_rec.cost_group_id <> l_txn_cost_group_id) THEN
1940: SELECT decode(inventory_asset_flag, 'Y', 0, 1)
1941: INTO l_cg_exp_item
1942: FROM mtl_system_items
1943: WHERE organization_id = i_ae_txn_rec.xfer_organization_id
1944: AND inventory_item_id = i_ae_txn_rec.inventory_item_id;
1945: ELSE
1946: l_cg_exp_item := i_ae_txn_rec.exp_item;

Line 6406: from mtl_system_items msi,

6402: l_stmt_num := 45;
6403:
6404: select nvl(msi.cost_of_sales_account, mp.cost_of_sales_account)
6405: into l_acct_rec.account
6406: from mtl_system_items msi,
6407: mtl_parameters mp
6408: where msi.organization_id = i_ae_txn_rec.organization_id
6409: and msi.inventory_item_id = i_ae_txn_rec.inventory_item_id
6410: and mp.organization_id = msi.organization_id;

Line 9174: FROM mtl_system_items MSI, mtl_parameters MP

9170: l_stmt_num := 90;
9171:
9172: SELECT nvl(MSI.cost_of_sales_account, MP.cost_of_sales_account)
9173: INTO l_cogs_ccid
9174: FROM mtl_system_items MSI, mtl_parameters MP
9175: WHERE MSI.organization_id = l_from_org
9176: AND MSI.inventory_item_id = i_ae_txn_rec.inventory_item_id
9177: AND MP.organization_id = MSI.organization_id;
9178:

Line 10475: p_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,

10471: PROCEDURE CompEncumbrance_IntOrdersExp (
10472: p_api_version IN NUMBER,
10473: p_transaction_id IN MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID%TYPE,
10474: p_req_line_id IN PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE,
10475: p_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,
10476: p_organization_id IN MTL_PARAMETERS.ORGANIZATION_ID%TYPE,
10477: p_primary_qty IN MTL_MATERIAL_TRANSACTIONS.PRIMARY_QUANTITY%TYPE,
10478: p_total_primary_qty IN NUMBER,
10479: x_encumbrance_amount OUT NOCOPY NUMBER,

Line 10551: FROM mtl_system_items

10547: /* Get UOM for this item/org from MSI */
10548: l_stmt_num := 30;
10549: SELECT primary_uom_code
10550: INTO l_primary_uom_code
10551: FROM mtl_system_items
10552: WHERE organization_id = p_organization_id
10553: AND inventory_item_id = p_item_id;
10554:
10555: /* Convert the total_primary_quantity into source_doc_quantity */