[Home] [Help]
510: NVL(i.lot_status_enabled, 'N'),
511: NVL(i.lot_divisible_flag, 'N')
512: FROM
513: gme_material_details d,
514: mtl_cross_references mcr,
515: mtl_system_items_kfv i
516: WHERE d.batch_id = p_batch_id
517: AND d.inventory_item_id = i.inventory_item_id
518: AND d.organization_id = i.organization_id
578: NVL(i.lot_status_enabled, 'N'),
579: NVL(i.lot_divisible_flag, 'N')
580: FROM
581: gme_material_details d,
582: mtl_cross_references mcr,
583: gme_batch_step_items si,
584: gme_batch_steps s,
585: mtl_system_items_kfv i
586: WHERE d.batch_id = p_batch_id
1249: NVL(i.lot_status_enabled, 'N'),
1250: NVL(i.lot_divisible_flag, 'N')
1251: FROM
1252: gme_material_details d,
1253: mtl_cross_references mcr,
1254: mtl_system_items_kfv i
1255: WHERE d.batch_id = p_batch_id
1256: AND d.inventory_item_id = i.inventory_item_id
1257: AND d.organization_id = i.organization_id
1348: NVL(i.lot_status_enabled, 'N'),
1349: NVL(i.lot_divisible_flag, 'N')
1350: FROM
1351: gme_material_details d,
1352: mtl_cross_references mcr,
1353: mtl_system_items_kfv i
1354: WHERE d.batch_id = p_batch_id
1355: AND d.inventory_item_id = i.inventory_item_id
1356: AND d.organization_id = i.organization_id
1458: NVL(i.lot_status_enabled, 'N'),
1459: NVL(i.lot_divisible_flag, 'N')
1460: FROM
1461: gme_material_details d,
1462: mtl_cross_references mcr,
1463: mtl_system_items_kfv i
1464: WHERE d.batch_id = p_batch_id
1465: AND d.inventory_item_id = i.inventory_item_id
1466: AND d.organization_id = i.organization_id
1526: NVL(i.lot_status_enabled, 'N'),
1527: NVL(i.lot_divisible_flag, 'N')
1528: FROM
1529: gme_material_details d,
1530: mtl_cross_references mcr,
1531: gme_batch_step_items si,
1532: gme_batch_steps s,
1533: mtl_system_items_kfv i
1534: WHERE d.batch_id = p_batch_id
1645: NVL(i.lot_status_enabled, 'N'),
1646: NVL(i.lot_divisible_flag, 'N')
1647: FROM
1648: gme_material_details d,
1649: mtl_cross_references mcr,
1650: mtl_system_items_kfv i
1651: WHERE d.batch_id = p_batch_id
1652: AND d.inventory_item_id = i.inventory_item_id
1653: AND d.organization_id = i.organization_id
1714: NVL(i.lot_status_enabled, 'N'),
1715: NVL(i.lot_divisible_flag, 'N')
1716: FROM
1717: gme_material_details d,
1718: mtl_cross_references mcr,
1719: gme_batch_step_items si,
1720: gme_batch_steps s,
1721: mtl_system_items_kfv i
1722: WHERE d.batch_id = p_batch_id
1836: NVL(i.lot_status_enabled, 'N'),
1837: NVL(i.lot_divisible_flag, 'N')
1838: FROM
1839: gme_material_details d,
1840: mtl_cross_references mcr,
1841: mtl_system_items_kfv i
1842: WHERE d.batch_id = p_batch_id
1843: AND d.inventory_item_id = i.inventory_item_id
1844: AND d.organization_id = i.organization_id
1906: NVL(i.lot_status_enabled, 'N'),
1907: NVL(i.lot_divisible_flag, 'N')
1908: FROM
1909: gme_material_details d,
1910: mtl_cross_references mcr,
1911: gme_batch_step_items si,
1912: gme_batch_steps s,
1913: mtl_system_items_kfv i
1914: WHERE d.batch_id = p_batch_id
2026: NVL(i.lot_status_enabled, 'N'),
2027: NVL(i.lot_divisible_flag, 'N')
2028: FROM
2029: gme_material_details d,
2030: mtl_cross_references mcr,
2031: mtl_system_items_kfv i
2032: WHERE d.batch_id = p_batch_id
2033: AND d.inventory_item_id = i.inventory_item_id
2034: AND d.organization_id = i.organization_id
2096: NVL(i.lot_status_enabled, 'N'),
2097: NVL(i.lot_divisible_flag, 'N')
2098: FROM
2099: gme_material_details d,
2100: mtl_cross_references mcr,
2101: gme_batch_step_items si,
2102: gme_batch_steps s,
2103: mtl_system_items_kfv i
2104: WHERE d.batch_id = p_batch_id