[Home] [Help]
279: AND NVL(b.migrated_batch_ind, 'N') <> 'Y'
280: AND NVL(b.update_inventory_ind,'N') = 'Y' --Bug#5763793
281: AND EXISTS
282: ( SELECT 1
283: FROM gme_batch_steps
284: WHERE batch_id = b.batch_id
285: AND step_status in (2,3)
286: )
287: UNION
308: AND lkup.enabled_flag = 'Y'
309: AND NVL(h.update_inventory_ind,'N') = 'Y' --Bug#5763793
310: AND EXISTS
311: ( SELECT 1
312: FROM gme_batch_steps
313: WHERE batch_id = h.batch_id
314: AND step_status = 3
315: )
316: ORDER BY batch_no DESC;
396: AND d.line_no LIKE (p_line_no)
397: AND NOT EXISTS
398: (SELECT 1
399: FROM gme_batch_step_items i2,
400: gme_batch_steps s
401: WHERE i2.batch_id = d.batch_id
402: AND s.batch_id = d.batch_id
403: AND i2.material_detail_id = d.material_detail_id
404: AND i2.batchstep_id = s.batchstep_id
545: NVL(i.lot_status_enabled, 'N'),
546: NVL(i.lot_divisible_flag, 'N')
547: FROM gme_material_details d,
548: gme_batch_step_items si,
549: gme_batch_steps s,
550: mtl_system_items_kfv i
551: WHERE d.batch_id = p_batch_id
552: AND d.batch_id = si.batch_id
553: AND si.material_detail_id = d.material_detail_id
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
587: AND d.batch_id = si.batch_id
588: AND si.material_detail_id = d.material_detail_id
644: i.inventory_item_id,
645: d.material_detail_id
646: FROM gme_material_details d,
647: gme_batch_step_items si,
648: gme_batch_steps s,
649: mtl_system_items_kfv i
650: WHERE
651: d.batch_id = p_batch_id
652: AND d.batch_id = si.batch_id
721: i.inventory_item_id,
722: d.material_detail_id
723: FROM gme_material_details d,
724: gme_batch_step_items si,
725: gme_batch_steps s,
726: mtl_system_items_kfv i
727: WHERE
728: d.batch_id = p_batch_id
729: AND d.batch_id = si.batch_id
799: i.inventory_item_id,
800: d.material_detail_id
801: FROM gme_material_details d,
802: gme_batch_step_items si,
803: gme_batch_steps s,
804: mtl_system_items_kfv i
805: WHERE
806: d.batch_id = p_batch_id
807: AND d.batch_id = si.batch_id
868: SELECT DISTINCT
869: s.batchstep_no,
870: o.oprn_desc,
871: s.batchstep_id
872: FROM gme_batch_steps s,
873: gme_batch_step_items i,
874: gmd_operations o
875: WHERE
876: i.batch_id = p_batch_id
916: SELECT DISTINCT
917: s.batchstep_no,
918: o.oprn_desc,
919: s.batchstep_id
920: FROM gme_batch_steps s,
921: gme_batch_step_items i,
922: gmd_operations o,
923: gme_material_details d
924: WHERE
967: SELECT DISTINCT
968: s.batchstep_no,
969: o.oprn_desc,
970: s.batchstep_id
971: FROM gme_batch_steps s,
972: gme_batch_step_items i,
973: gmd_operations o,
974: gme_material_details d
975: WHERE
1018: SELECT DISTINCT
1019: s.batchstep_no,
1020: o.oprn_desc,
1021: s.batchstep_id
1022: FROM gme_batch_steps s,
1023: gme_batch_step_items i,
1024: gmd_operations o,
1025: gme_material_details d
1026: WHERE
1102: OPEN x_activity_cursor FOR
1103: SELECT a.activity,
1104: a.batchstep_activity_id
1105: FROM gme_batch_header h,
1106: gme_batch_steps s,
1107: gme_batch_step_activities a
1108: WHERE h.organization_id = p_organization_id
1109: AND h.batch_id = p_batch_id
1110: AND h.batch_type = 0
1152: OPEN x_resource_cursor FOR
1153: SELECT r.resources,
1154: r.batchstep_resource_id
1155: FROM gme_batch_header h,
1156: gme_batch_steps s,
1157: gme_batch_step_activities a,
1158: gme_batch_step_resources r
1159: WHERE h.organization_id = p_org_id
1160: AND h.batch_id = p_batch_id
1493: NVL(i.lot_status_enabled, 'N'),
1494: NVL(i.lot_divisible_flag, 'N')
1495: FROM gme_material_details d,
1496: gme_batch_step_items si,
1497: gme_batch_steps s,
1498: mtl_system_items_kfv i
1499: WHERE d.batch_id = p_batch_id
1500: AND d.batch_id = si.batch_id
1501: AND si.material_detail_id = d.material_detail_id
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
1535: AND d.batch_id = si.batch_id
1536: AND si.material_detail_id = d.material_detail_id
1681: NVL(i.lot_status_enabled, 'N'),
1682: NVL(i.lot_divisible_flag, 'N')
1683: FROM gme_material_details d,
1684: gme_batch_step_items si,
1685: gme_batch_steps s,
1686: mtl_system_items_kfv i
1687: WHERE d.batch_id = p_batch_id
1688: AND d.batch_id = si.batch_id
1689: AND si.material_detail_id = d.material_detail_id
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
1723: AND d.batch_id = si.batch_id
1724: AND si.material_detail_id = d.material_detail_id
1872: NVL(i.lot_status_enabled, 'N'),
1873: NVL(i.lot_divisible_flag, 'N')
1874: FROM gme_material_details d,
1875: gme_batch_step_items si,
1876: gme_batch_steps s,
1877: mtl_system_items_kfv i
1878: WHERE d.batch_id = p_batch_id
1879: AND d.batch_id = si.batch_id
1880: AND si.material_detail_id = d.material_detail_id
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
1915: AND d.batch_id = si.batch_id
1916: AND si.material_detail_id = d.material_detail_id
2062: NVL(i.lot_status_enabled, 'N'),
2063: NVL(i.lot_divisible_flag, 'N')
2064: FROM gme_material_details d,
2065: gme_batch_step_items si,
2066: gme_batch_steps s,
2067: mtl_system_items_kfv i
2068: WHERE d.batch_id = p_batch_id
2069: AND d.batch_id = si.batch_id
2070: AND si.material_detail_id = d.material_detail_id
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
2105: AND d.batch_id = si.batch_id
2106: AND si.material_detail_id = d.material_detail_id
2154: SELECT s.batchstep_no,
2155: o.oprn_desc,
2156: s.batchstep_id
2157: FROM gme_batch_header h,
2158: gme_batch_steps s,
2159: gmd_operations o
2160: WHERE h.batch_id = p_batch_id
2161: AND h.batch_type = 0
2162: AND h.batch_id = s.batch_id
2169: SELECT s.batchstep_no,
2170: o.oprn_desc,
2171: s.batchstep_id
2172: FROM gme_batch_header h,
2173: gme_batch_steps s,
2174: gmd_operations o
2175: WHERE h.batch_id = p_batch_id
2176: AND h.batch_type = 0
2177: AND h.batch_id = s.batch_id
3522: d.line_type
3523: FROM gme_batch_header h,
3524: gme_material_details d,
3525: gme_batch_step_items si,
3526: gme_batch_steps s,
3527: gem_lookups lkup
3528: WHERE h.organization_id = p_organization_id
3529: AND h.batch_id = p_batch_id
3530: AND h.batch_id = d.batch_id
3616: d.line_type
3617: FROM gme_batch_header h,
3618: gme_material_details d,
3619: gme_batch_step_items si,
3620: gme_batch_steps s,
3621: gem_lookups lkup
3622: WHERE h.organization_id = p_organization_id
3623: AND h.batch_id = p_batch_id
3624: AND h.batch_id = d.batch_id
3839: TO_NUMBER(NULL) act_step_qty, gbs.step_qty_um,
3840: TO_CHAR(gbs.plan_start_date, p_date_format||gme_mobile_txn.HOUR_MIN_SEC_FORMAT_STRING),
3841: ' ' act_start_date,
3842: TO_CHAR(gbs.plan_start_date, p_date_format||gme_mobile_txn.HOUR_MIN_SEC_FORMAT_STRING) plan_comlt_date
3843: FROM gme_batch_header gbh, gme_batch_steps gbs, gmd_operations gmo, gem_lookups glk
3844: WHERE gbh.batch_id = p_batch_id
3845: AND gbh.batch_type = 0
3846: AND gbh.batch_id = gbs.batch_id
3847: AND gbs.step_status = 1
3870: TO_NUMBER(NULL) act_step_qty, gbs.step_qty_um,
3871: TO_CHAR(gbs.plan_start_date, p_date_format||gme_mobile_txn.HOUR_MIN_SEC_FORMAT_STRING),
3872: DECODE(gbs.actual_start_date,NULL,' ',TO_CHAR(gbs.actual_start_date, p_date_format||gme_mobile_txn.HOUR_MIN_SEC_FORMAT_STRING)) act_start_date,
3873: TO_CHAR(gbs.plan_start_date, p_date_format||gme_mobile_txn.HOUR_MIN_SEC_FORMAT_STRING) plan_comlt_date
3874: FROM gme_batch_header gbh, gme_batch_steps gbs, gmd_operations gmo, gem_lookups glk
3875: WHERE gbh.batch_id = p_batch_id
3876: AND gbh.batch_type = 0
3877: AND gbh.batch_id = gbs.batch_id
3878: AND gbs.step_status IN (1,2)
3912: , r.resource_qty_um
3913: , ROUND(DECODE(s.step_status, 2, r.plan_rsrc_usage, 3, r.actual_rsrc_usage),2)
3914: , r.usage_um
3915: FROM gme_batch_header h,
3916: gme_batch_steps s,
3917: gme_batch_step_activities a,
3918: gme_batch_step_resources r,
3919: gmp_resource_instances i,
3920: fnd_user u
3964: , ROUND(DECODE(s.step_status, 2, r.plan_rsrc_qty, 3, r.actual_rsrc_qty),2)
3965: , r.resource_qty_um
3966: , ROUND(DECODE(s.step_status, 2, r.plan_rsrc_usage, 3, r.actual_rsrc_usage),2)
3967: , r.usage_um
3968: FROM gme_batch_steps s,
3969: gme_batch_step_activities a,
3970: gme_batch_step_resources r,
3971: gmp_resource_instances i,
3972: gme_resource_txns_gtmp t,