APPS.QA_VALIDATION_API dependencies on MTL_SUBINVENTORIES_VAL_V

Line 944: -- Bug 3381173. The cursor C2 was based on the view mtl_subinventories_val_v,

940: from mtl_parameters
941: where organization_id = org_id;
942:
943:
944: -- Bug 3381173. The cursor C2 was based on the view mtl_subinventories_val_v,
945: -- which is only for storage subs. Based the cursor on mtl_secondary_inventories
946: -- and added the where clause to differentiate receiving subs.
947: -- kabalakr Tue Jan 27 02:18:59 PST 2004.
948:

Line 961: from mtl_subinventories_val_v

957:
958: /*
959: CURSOR C2 (org_id NUMBER) IS
960: select locator_type
961: from mtl_subinventories_val_v
962: where organization_id = org_id
963: and secondary_inventory_name = g_subinventory;
964: */
965:

Line 1105: from mtl_subinventories_val_v

1101: -- bhsankar Mon Jul 16 05:51:51 PDT 2007
1102: --
1103: CURSOR C2 (org_id NUMBER) IS
1104: select locator_type
1105: from mtl_subinventories_val_v
1106: where organization_id = org_id
1107: and secondary_inventory_name = g_comp_subinventory;
1108:
1109: BEGIN

Line 1366: from mtl_subinventories_val_v

1362: where organization_id = org_id;
1363:
1364: CURSOR C2 (org_id NUMBER) IS
1365: select locator_type
1366: from mtl_subinventories_val_v
1367: where organization_id = org_id
1368: and secondary_inventory_name = g_to_subinventory;
1369:
1370: