APPS.WMS_ASSIGNMENT_PVT dependencies on MTL_PARAMETERS

Line 53: FROM mtl_parameters mp

49: l_value_name VARCHAR2(2000);
50: --
51: CURSOR obj3 IS -- org / opposing org
52: SELECT mp.organization_code
53: FROM mtl_parameters mp
54: WHERE mp.organization_id =
55: fnd_number.canonical_to_number(p_pk1_value)
56: ;
57: --

Line 129: FROM mtl_parameters mp

125: ;
126: --
127: CURSOR obj19 IS -- opposing sub
128: SELECT mp.organization_code||' / '||msi.secondary_inventory_name
129: FROM mtl_parameters mp
130: ,mtl_secondary_inventories msi
131: WHERE msi.organization_id = fnd_number.canonical_to_number(p_pk1_value)
132: AND msi.secondary_inventory_name = p_pk2_value
133: AND mp.organization_id = msi.organization_id