DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_LOV dependencies on MTL_CROSS_REFERENCES

Line 1254: mtl_cross_references mcr

1250: NVL(tracking_quantity_ind,'P'),
1251: NVL(dual_uom_deviation_high,0),
1252: NVL(dual_uom_deviation_low,0)
1253: FROM mtl_system_items_vl msik, /* Bug 5581528 */
1254: mtl_cross_references mcr
1255: WHERE msik.organization_id = p_organization_id
1256: AND msik.inventory_item_id = mcr.inventory_item_id
1257: AND mcr.cross_reference_type = g_gtin_cross_ref_type
1258: AND mcr.cross_reference LIKE l_cross_ref

Line 1362: mtl_cross_references mcr

1358: NVL(tracking_quantity_ind,'P'),
1359: NVL(dual_uom_deviation_high,0),
1360: NVL(dual_uom_deviation_low,0)
1361: FROM mtl_system_items_vl msik, /* Bug 5581528 */
1362: mtl_cross_references mcr
1363: WHERE msik.organization_id = p_organization_id
1364: AND msik.inventory_item_id = mcr.inventory_item_id
1365: AND mcr.cross_reference_type = g_gtin_cross_ref_type
1366: AND mcr.cross_reference LIKE l_cross_ref