DBA Data[Home] [Help]

APPS.INV_LABEL_PVT2 dependencies on WMS_ITEM_LOCATIONS_KFV

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

997: , po_hazard_classes poh
998: , mtl_serial_numbers msn
999: , cst_cost_groups ccg
1000: , wip_entities wipent
1001: , wms_item_locations_kfv wilk -- Modified for bug # 5015415
1002: -- , mtl_item_locations_kfv milk -- Added as part of change for patchset "I".
1003: WHERE msik.inventory_item_id = l_inventory_item_id
1004: AND msik.organization_id = l_organization_id
1005: AND poh.hazard_class_id(+) = msik.hazard_class_id

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

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