DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_LOV dependencies on MTL_CROSS_REFERENCES

Line 1329: mtl_cross_references mcr

1325: NVL(tracking_quantity_ind,'P'),
1326: NVL(dual_uom_deviation_high,0),
1327: NVL(dual_uom_deviation_low,0)
1328: FROM mtl_system_items_vl msik, /* Bug 5581528 */
1329: mtl_cross_references mcr
1330: WHERE msik.organization_id = p_organization_id
1331: AND msik.inventory_item_id = mcr.inventory_item_id
1332: AND mcr.cross_reference_type = g_gtin_cross_ref_type
1333: AND mcr.cross_reference LIKE l_cross_ref

Line 1439: mtl_cross_references mcr

1435: NVL(tracking_quantity_ind,'P'),
1436: NVL(dual_uom_deviation_high,0),
1437: NVL(dual_uom_deviation_low,0)
1438: FROM mtl_system_items_vl msik, /* Bug 5581528 */
1439: mtl_cross_references mcr
1440: WHERE msik.organization_id = p_organization_id
1441: AND msik.inventory_item_id = mcr.inventory_item_id
1442: AND mcr.cross_reference_type = g_gtin_cross_ref_type
1443: AND mcr.cross_reference LIKE l_cross_ref