APPS.OKL_AM_REMARKET_ASSET_PVT dependencies on MTL_SYSTEM_ITEMS

Line 172: -- query mtl_system_items with inventory_item_id and org_id and get source_subinventory and distribution account.

168:
169: -- subinventory and distribution account ID are retrieved from profiles at the time of item creation. Since profiles
170: -- may change between the time item is created and time when Order is booked against the item, we store these values
171: -- in the following fields. Later when we reduce the quantitiy of an item, after the order is booked, we can
172: -- query mtl_system_items with inventory_item_id and org_id and get source_subinventory and distribution account.
173:
174: --SECHAWLA 19-MAY-04 3634514: Populate subinventory only if p_assign_subinv = 'Y'
175: IF p_assign_subinv = 'Y' THEN
176: l_item_rec.SOURCE_TYPE := 1;

Line 758: FROM MTL_SYSTEM_ITEMS_B

754: -- SECHAWLA 18-OCT-04 3924244 : new declarations
755: -- check if item already exists in inventory
756: CURSOR l_mtlsystemitems_csr(cp_inv_item_number IN VARCHAR2) IS
757: SELECT count(*)
758: FROM MTL_SYSTEM_ITEMS_B
759: WHERE segment1 = cp_inv_item_number;
760:
761: l_item_cnt NUMBER;
762:

Line 1840: -- Innentory Item Id and Organization Id form the PK for mtl_system_items

1836: -- p_org_id - organization that the item belongs to
1837: -- p_dist_account_id - Distribution Account
1838: -- p_quantity - Ordered Quantity
1839: -- p_sysdate - system date
1840: -- Innentory Item Id and Organization Id form the PK for mtl_system_items
1841: -- Version : 1.0
1842: -- History : SECHAWLA 05-DEC-02 Bug# 2620853
1843: -- Commented out the codethat references disribution account id, as it is optional
1844: -- SECHAWLA 16-JAN-03 Bug # 2754280

Line 1869: FROM mtl_system_items_b

1865:
1866: -- This cursor is used to make sure that the item exists in active state, before removing the item
1867: CURSOR l_mtlsysitems_csr(p_inventory_item_id NUMBER,p_organization_id NUMBER) IS
1868: SELECT 'x'
1869: FROM mtl_system_items_b
1870: WHERE inventory_item_id = p_inventory_item_id
1871: AND organization_id = p_organization_id
1872: AND end_date_active IS NULL;
1873: */

Line 2035: FROM mtl_system_items

2031: CURSOR l_mtlsystemitems_csr(p_item_id NUMBER, p_org_id NUMBER) IS
2032: -- SECHAWLA Bug# 2620853 : ENCUMBRANCE_ACCOUNT (which stores the distribution accout id) is not required
2033: --SELECT SOURCE_SUBINVENTORY, ENCUMBRANCE_ACCOUNT
2034: SELECT SOURCE_SUBINVENTORY
2035: FROM mtl_system_items
2036: WHERE inventory_item_id = p_item_id
2037: AND organization_id = p_org_id;
2038:
2039: l_order_number NUMBER;