APPS.QA_VALIDATION_API dependencies on MTL_SUBINVENTORIES_VAL_V

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

951: from mtl_parameters
952: where organization_id = org_id;
953:
954:
955: -- Bug 3381173. The cursor C2 was based on the view mtl_subinventories_val_v,
956: -- which is only for storage subs. Based the cursor on mtl_secondary_inventories
957: -- and added the where clause to differentiate receiving subs.
958: -- kabalakr Tue Jan 27 02:18:59 PST 2004.
959:

Line 972: from mtl_subinventories_val_v

968:
969: /*
970: CURSOR C2 (org_id NUMBER) IS
971: select locator_type
972: from mtl_subinventories_val_v
973: where organization_id = org_id
974: and secondary_inventory_name = g_subinventory;
975: */
976:

Line 1116: from mtl_subinventories_val_v

1112: -- bhsankar Mon Jul 16 05:51:51 PDT 2007
1113: --
1114: CURSOR C2 (org_id NUMBER) IS
1115: select locator_type
1116: from mtl_subinventories_val_v
1117: where organization_id = org_id
1118: and secondary_inventory_name = g_comp_subinventory;
1119:
1120: BEGIN

Line 1377: from mtl_subinventories_val_v

1373: where organization_id = org_id;
1374:
1375: CURSOR C2 (org_id NUMBER) IS
1376: select locator_type
1377: from mtl_subinventories_val_v
1378: where organization_id = org_id
1379: and secondary_inventory_name = g_to_subinventory;
1380:
1381: