DBA Data[Home] [Help]

APPS.OPIMPXWI dependencies on MTL_SYSTEM_ITEMS

Line 1243: MTL_SYSTEM_ITEMS msi

1239: mmt.SUBINVENTORY_CODE,
1240: mmt.LOCATOR_ID,
1241: sum(mmt.PRIMARY_QUANTITY)
1242: FROM MTL_MATERIAL_TRANSACTIONS mmt,
1243: MTL_SYSTEM_ITEMS msi
1244: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
1245: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
1246: AND mmt.ORGANIZATION_ID=Org_id
1247: AND msi.LOT_CONTROL_CODE = 1

Line 1273: MTL_SYSTEM_ITEMS msi,

1269: mmt.SUBINVENTORY_CODE,
1270: mmt.LOCATOR_ID,
1271: sum(mtln.PRIMARY_QUANTITY)
1272: FROM MTL_MATERIAL_TRANSACTIONS mmt,
1273: MTL_SYSTEM_ITEMS msi,
1274: MTL_TRANSACTION_LOT_NUMBERS mtln
1275: WHERE mmt.INVENTORY_ITEM_ID=msi.INVENTORY_ITEM_ID
1276: AND mmt.ORGANIZATION_ID=msi.ORGANIZATION_ID
1277: AND mmt.ORGANIZATION_ID=Org_id

Line 1366: FROM mtl_system_items

1362: PRIMARY_UOM_CODE
1363: INTO l_item_status,
1364: l_item_type,
1365: l_base_uom
1366: FROM mtl_system_items
1367: WHERE inventory_item_id=l_item_id
1368: AND organization_id = l_organization_id;
1369:
1370: l_statement:=2;

Line 1448: FROM mtl_system_items

1444: PRIMARY_UOM_CODE
1445: INTO l_item_status,
1446: l_item_type,
1447: l_base_uom
1448: FROM mtl_system_items
1449: WHERE inventory_item_id=l_item_id
1450: AND organization_id = l_organization_id;
1451:
1452: l_statement:=6;

Line 1656: FROM mtl_system_items

1652:
1653: -- check if item is expense item
1654: SELECT inventory_asset_flag
1655: INTO non_expense_item
1656: FROM mtl_system_items
1657: WHERE organization_id = p_organization_id
1658: AND inventory_item_id = p_item_id;
1659: /*---------------------------------------------------------------------------------------------------
1660: Find the cost for the item as of last trx in the day for the key combination.

Line 1996: mtl_system_items msi

1992: mmt.SUBINVENTORY_CODE,
1993: mmt.LOCATOR_ID
1994: FROM MTL_MATERIAL_TRANSACTIONS mmt,
1995: MTL_TRANSACTION_LOT_NUMBERS mtln,
1996: mtl_system_items msi
1997: WHERE mmt.ORGANIZATION_ID=Org_id
1998: AND mmt.transaction_date >= Trunc(p_from_date)
1999: AND mmt.transaction_id = mtln.transaction_id (+)
2000: and msi.organization_id = mmt.organization_id

Line 2193: FROM mtl_system_items

2189:
2190: -- see if this is an expense item
2191: SELECT inventory_asset_flag
2192: INTO non_expense_item
2193: FROM mtl_system_items
2194: WHERE organization_id = org_id
2195: AND inventory_item_id = l_item_id;
2196:
2197: -- If this is not an expense sub or and expense item,

Line 2271: FROM mtl_system_items

2267: PRIMARY_UOM_CODE
2268: INTO l_item_status,
2269: l_item_type,
2270: l_base_uom
2271: FROM mtl_system_items
2272: WHERE inventory_item_id=l_item_id
2273: AND organization_id = Org_id;
2274:
2275: OPIMPXIN.Insert_update_push_log(

Line 2387: mtl_system_items msi

2383: msi.inventory_item_status_code,
2384: msi.item_type,
2385: msi.primary_uom_code
2386: FROM MTL_MATERIAL_TRANSACTIONS mmt,
2387: mtl_system_items msi
2388: WHERE ( mmt.ORGANIZATION_ID=Org_id or mmt.transfer_organization_id =Org_id)
2389: AND mmt.organization_id=msi.organization_id
2390: AND mmt.inventory_item_id=msi.inventory_item_id
2391: AND mmt.transaction_action_id in (12,21)