eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_ASSIGNMENT_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 67: FROM mtl_secondary_inventories msi

63: ;
64: --
65: CURSOR obj7 IS -- sub
66: SELECT msi.secondary_inventory_name
67: FROM mtl_secondary_inventories msi
68: WHERE msi.organization_id = fnd_number.canonical_to_number(p_pk1_value)
69: AND msi.secondary_inventory_name = p_pk2_value
70: ;
71: --

Line 75: ,mtl_secondary_inventories msi

71: --
72: CURSOR obj9 IS -- item-sub
73: SELECT msik.concatenated_segments||' / '||msi.SECONDARY_INVENTORY_NAME
74: FROM mtl_system_items_kfv msik
75: ,mtl_secondary_inventories msi
76: WHERE msi.organization_id = msik.organization_id
77: AND msi.secondary_inventory_name = p_pk3_value
78: AND msik.organization_id = fnd_number.canonical_to_number(p_pk1_value)
79: AND msik.inventory_item_id = fnd_number.canonical_to_number(p_pk2_value)

Line 130: ,mtl_secondary_inventories msi

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
134: ;