APPS.QA_PLAN_ELEMENT_API dependencies on MTL_SECONDARY_INVENTORIES

Line 1975: FROM mtl_secondary_inventories

1971: RETURN BOOLEAN IS
1972:
1973: CURSOR c IS
1974: SELECT 1
1975: FROM mtl_secondary_inventories
1976: WHERE organization_id = x_org_id
1977: AND nvl(disable_date, sysdate+1) > sysdate
1978: AND secondary_inventory_name = x_to_subinventory;
1979:

Line 2187: FROM mtl_secondary_inventories

2183: -- kabalakr Tue Jan 27 02:18:59 PST 2004.
2184:
2185: CURSOR c IS
2186: SELECT 1
2187: FROM mtl_secondary_inventories
2188: WHERE organization_id = x_org_id
2189: AND ((((SUBINVENTORY_TYPE <> 2) OR (SUBINVENTORY_TYPE IS NULL))
2190: AND nvl(disable_date, sysdate+1) > sysdate)
2191: OR (SUBINVENTORY_TYPE = 2))

Line 3578: FROM mtl_secondary_inventories

3574: -- After Single Scan LOV
3575: wild := value;
3576:
3577: sql_string := 'SELECT secondary_inventory_name, description
3578: FROM mtl_secondary_inventories
3579: WHERE organization_id = :1
3580: AND nvl(disable_date, sysdate+1) > sysdate
3581: AND secondary_inventory_name like :2
3582: ORDER BY secondary_inventory_name';

Line 4308: FROM mtl_secondary_inventories

4304: -- After Single Scan LOV
4305: wild := value;
4306:
4307: sql_string := 'SELECT secondary_inventory_name, description
4308: FROM mtl_secondary_inventories
4309: WHERE organization_id = :1
4310: AND nvl(disable_date, sysdate+1) > sysdate
4311: AND secondary_inventory_name like :2
4312: ORDER BY secondary_inventory_name';

Line 5615: FROM mtl_secondary_inventories

5611: x_neg_inv NUMBER;
5612:
5613: Cursor sub_loc_cur (p_subinv_name IN VARCHAR2) IS
5614: SELECT locator_type
5615: FROM mtl_secondary_inventories
5616: WHERE organization_id = org_id
5617: AND nvl(disable_date, sysdate + 1) > sysdate
5618: AND secondary_inventory_name = p_subinv_name;
5619: