APPS.QA_PLAN_ELEMENT_API dependencies on MTL_SECONDARY_INVENTORIES

Line 1956: FROM mtl_secondary_inventories

1952: RETURN BOOLEAN IS
1953:
1954: CURSOR c IS
1955: SELECT 1
1956: FROM mtl_secondary_inventories
1957: WHERE organization_id = x_org_id
1958: AND nvl(disable_date, sysdate+1) > sysdate
1959: AND secondary_inventory_name = x_to_subinventory;
1960:

Line 2168: FROM mtl_secondary_inventories

2164: -- kabalakr Tue Jan 27 02:18:59 PST 2004.
2165:
2166: CURSOR c IS
2167: SELECT 1
2168: FROM mtl_secondary_inventories
2169: WHERE organization_id = x_org_id
2170: AND ((((SUBINVENTORY_TYPE <> 2) OR (SUBINVENTORY_TYPE IS NULL))
2171: AND nvl(disable_date, sysdate+1) > sysdate)
2172: OR (SUBINVENTORY_TYPE = 2))

Line 3486: FROM mtl_secondary_inventories

3482: -- After Single Scan LOV
3483: wild := value;
3484:
3485: sql_string := 'SELECT secondary_inventory_name, description
3486: FROM mtl_secondary_inventories
3487: WHERE organization_id = :1
3488: AND nvl(disable_date, sysdate+1) > sysdate
3489: AND secondary_inventory_name like :2
3490: ORDER BY secondary_inventory_name';

Line 4110: FROM mtl_secondary_inventories

4106: -- After Single Scan LOV
4107: wild := value;
4108:
4109: sql_string := 'SELECT secondary_inventory_name, description
4110: FROM mtl_secondary_inventories
4111: WHERE organization_id = :1
4112: AND nvl(disable_date, sysdate+1) > sysdate
4113: AND secondary_inventory_name like :2
4114: ORDER BY secondary_inventory_name';

Line 5411: FROM mtl_secondary_inventories

5407: x_neg_inv NUMBER;
5408:
5409: Cursor sub_loc_cur (p_subinv_name IN VARCHAR2) IS
5410: SELECT locator_type
5411: FROM mtl_secondary_inventories
5412: WHERE organization_id = org_id
5413: AND nvl(disable_date, sysdate + 1) > sysdate
5414: AND secondary_inventory_name = p_subinv_name;
5415: