DBA Data[Home] [Help]

APPS.INV_LABEL_PVT1 dependencies on WMS_ITEM_LOCATIONS_KFV

Line 1834: , wms_item_locations_kfv wilk

1830: , mtl_parameters mp
1831: /*Commented for bug# 6334460 start
1832: , DUAL d
1833: Commented for bug# 6334460 end */
1834: , wms_item_locations_kfv wilk
1835: --, mtl_item_locations_kfv milk -- Modified for bug # 5015415
1836: /*Commented for bug# 6334460 start
1837: WHERE d.dummy = 'X'
1838: AND msik.concatenated_segments(+) <> NVL('@@@', d.dummy)

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

1853:
1854: For PJM Org, Locator field in Material Label should not show the Project and task id's.
1855: This is because, the Project and Task Id's are not Bar code transactable.
1856: In mtl_item_locations_kfv, the cocatenated segments will have Project and
1857: Task Id's attached to it. Whereas in wms_item_locations_kfv, concatenated
1858: segments will have only the physical details (Row, Rack and Bin)
1859: and not the project and Task id's.
1860: AND milk.organization_id(+) = msik.organization_id
1861: AND milk.subinventory_code(+) = l_subinventory_code