APPS.INV_LABEL_PVT1 dependencies on WMS_ITEM_LOCATIONS_KFV

Line 1883: , wms_item_locations_kfv wilk

1879: , mtl_parameters mp
1880: /*Commented for bug# 6334460 start
1881: , DUAL d
1882: Commented for bug# 6334460 end */
1883: , wms_item_locations_kfv wilk
1884: --, mtl_item_locations_kfv milk -- Modified for bug # 5015415
1885: /*Commented for bug# 6334460 start
1886: WHERE d.dummy = 'X'
1887: AND msik.concatenated_segments(+) <> NVL('@@@', d.dummy)

Line 1906: Task Id's attached to it. Whereas in wms_item_locations_kfv, concatenated

1902:
1903: For PJM Org, Locator field in Material Label should not show the Project and task id's.
1904: This is because, the Project and Task Id's are not Bar code transactable.
1905: In mtl_item_locations_kfv, the cocatenated segments will have Project and
1906: Task Id's attached to it. Whereas in wms_item_locations_kfv, concatenated
1907: segments will have only the physical details (Row, Rack and Bin)
1908: and not the project and Task id's.
1909: AND milk.organization_id(+) = msik.organization_id
1910: AND milk.subinventory_code(+) = l_subinventory_code