DBA Data[Home] [Help]

APPS.WMS_ASSIGNMENT_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 60: FROM mtl_system_items_kfv msik

56: ;
57: --
58: CURSOR obj4 IS -- item
59: SELECT msik.concatenated_segments
60: FROM mtl_system_items_kfv msik
61: WHERE msik.organization_id = fnd_number.canonical_to_number(p_pk1_value)
62: AND msik.inventory_item_id = fnd_number.canonical_to_number(p_pk2_value)
63: ;
64: --

Line 74: FROM mtl_system_items_kfv msik

70: ;
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)