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 756: FROM MTL_SYSTEM_ITEMS_B

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

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

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

Line 1865: FROM mtl_system_items_b

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

Line 2031: FROM mtl_system_items

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