[Home] [Help]
537: NVL(i.lot_status_enabled, 'N'),
538: NVL(i.lot_divisible_flag, 'N')
539: FROM
540: gme_material_details d,
541: mtl_cross_references mcr,
542: mtl_system_items_kfv i
543: WHERE d.batch_id = p_batch_id
544: AND d.inventory_item_id = i.inventory_item_id
545: AND d.organization_id = i.organization_id
605: NVL(i.lot_status_enabled, 'N'),
606: NVL(i.lot_divisible_flag, 'N')
607: FROM
608: gme_material_details d,
609: mtl_cross_references mcr,
610: gme_batch_step_items si,
611: gme_batch_steps s,
612: mtl_system_items_kfv i
613: WHERE d.batch_id = p_batch_id
1276: NVL(i.lot_status_enabled, 'N'),
1277: NVL(i.lot_divisible_flag, 'N')
1278: FROM
1279: gme_material_details d,
1280: mtl_cross_references mcr,
1281: mtl_system_items_kfv i
1282: WHERE d.batch_id = p_batch_id
1283: AND d.inventory_item_id = i.inventory_item_id
1284: AND d.organization_id = i.organization_id
1375: NVL(i.lot_status_enabled, 'N'),
1376: NVL(i.lot_divisible_flag, 'N')
1377: FROM
1378: gme_material_details d,
1379: mtl_cross_references mcr,
1380: mtl_system_items_kfv i
1381: WHERE d.batch_id = p_batch_id
1382: AND d.inventory_item_id = i.inventory_item_id
1383: AND d.organization_id = i.organization_id
1485: NVL(i.lot_status_enabled, 'N'),
1486: NVL(i.lot_divisible_flag, 'N')
1487: FROM
1488: gme_material_details d,
1489: mtl_cross_references mcr,
1490: mtl_system_items_kfv i
1491: WHERE d.batch_id = p_batch_id
1492: AND d.inventory_item_id = i.inventory_item_id
1493: AND d.organization_id = i.organization_id
1553: NVL(i.lot_status_enabled, 'N'),
1554: NVL(i.lot_divisible_flag, 'N')
1555: FROM
1556: gme_material_details d,
1557: mtl_cross_references mcr,
1558: gme_batch_step_items si,
1559: gme_batch_steps s,
1560: mtl_system_items_kfv i
1561: WHERE d.batch_id = p_batch_id
1672: NVL(i.lot_status_enabled, 'N'),
1673: NVL(i.lot_divisible_flag, 'N')
1674: FROM
1675: gme_material_details d,
1676: mtl_cross_references mcr,
1677: mtl_system_items_kfv i
1678: WHERE d.batch_id = p_batch_id
1679: AND d.inventory_item_id = i.inventory_item_id
1680: AND d.organization_id = i.organization_id
1741: NVL(i.lot_status_enabled, 'N'),
1742: NVL(i.lot_divisible_flag, 'N')
1743: FROM
1744: gme_material_details d,
1745: mtl_cross_references mcr,
1746: gme_batch_step_items si,
1747: gme_batch_steps s,
1748: mtl_system_items_kfv i
1749: WHERE d.batch_id = p_batch_id
1863: NVL(i.lot_status_enabled, 'N'),
1864: NVL(i.lot_divisible_flag, 'N')
1865: FROM
1866: gme_material_details d,
1867: mtl_cross_references mcr,
1868: mtl_system_items_kfv i
1869: WHERE d.batch_id = p_batch_id
1870: AND d.inventory_item_id = i.inventory_item_id
1871: AND d.organization_id = i.organization_id
1933: NVL(i.lot_status_enabled, 'N'),
1934: NVL(i.lot_divisible_flag, 'N')
1935: FROM
1936: gme_material_details d,
1937: mtl_cross_references mcr,
1938: gme_batch_step_items si,
1939: gme_batch_steps s,
1940: mtl_system_items_kfv i
1941: WHERE d.batch_id = p_batch_id
2053: NVL(i.lot_status_enabled, 'N'),
2054: NVL(i.lot_divisible_flag, 'N')
2055: FROM
2056: gme_material_details d,
2057: mtl_cross_references mcr,
2058: mtl_system_items_kfv i
2059: WHERE d.batch_id = p_batch_id
2060: AND d.inventory_item_id = i.inventory_item_id
2061: AND d.organization_id = i.organization_id
2123: NVL(i.lot_status_enabled, 'N'),
2124: NVL(i.lot_divisible_flag, 'N')
2125: FROM
2126: gme_material_details d,
2127: mtl_cross_references mcr,
2128: gme_batch_step_items si,
2129: gme_batch_steps s,
2130: mtl_system_items_kfv i
2131: WHERE d.batch_id = p_batch_id