DBA Data[Home] [Help]

APPS.INV_LABEL_PVT2 dependencies on WMS_ITEM_LOCATIONS_KFV

Line 994: , wms_item_locations_kfv wilk -- Modified for bug # 5015415

990: , po_hazard_classes poh
991: , mtl_serial_numbers msn
992: , cst_cost_groups ccg
993: , wip_entities wipent
994: , wms_item_locations_kfv wilk -- Modified for bug # 5015415
995: -- , mtl_item_locations_kfv milk -- Added as part of change for patchset "I".
996: WHERE msik.inventory_item_id = l_inventory_item_id
997: AND msik.organization_id = l_organization_id
998: AND poh.hazard_class_id(+) = msik.hazard_class_id

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

1006:
1007: For PJM Org, Locator field in Material Label should not show the Project and task id's.
1008: This is because, the Project and Task Id's are not Bar code transactable.
1009: In mtl_item_locations_kfv, the cocatenated segments will have Project and
1010: Task Id's attached to it. Whereas in wms_item_locations_kfv, concatenated
1011: segments will have only the physical details (Row, Rack and Bin)
1012: and not the project and Task id's.
1013:
1014: AND milk.inventory_location_id(+) = l_locator_id