eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSD_DEPOT_UPDATE_PVT dependencies on CSD_REPAIR_ORDER_GROUPS

Line 125: FROM csd_repair_order_groups

121: -- travi new 2501113
122: v_weid number;
123: CURSOR get_grp_id (p_inc_id in number) IS
124: SELECT repair_group_id
125: FROM csd_repair_order_groups
126: WHERE incident_id = p_inc_id;
127:
128: CURSOR get_xref_id (p_rep_grp_id in number) IS
129: SELECT x.repair_job_xref_id, x.group_id, x.object_version_number

Line 140: FROM csd_repair_order_groups crog,

136:
137: -- Cursor to get wip entity id
138: CURSOR get_wip_entity (p_inc_id in number) IS
139: SELECT distinct crog.wip_entity_id
140: FROM csd_repair_order_groups crog,
141: wip_discrete_jobs wdj
142: WHERE crog.wip_entity_id = wdj.wip_entity_id
143: AND wdj.status_type in ( 4,12,5)
144: AND crog.incident_id = p_inc_id;

Line 156: FROM csd_repair_order_groups crog

152:
153: -- Cursor to get repair group id
154: CURSOR get_rep_group (p_wip_ent_id in number) IS
155: SELECT crog.repair_group_id
156: FROM csd_repair_order_groups crog
157: WHERE crog.wip_entity_id = p_wip_ent_id;
158:
159: -- Cursor to get repair line id
160: CURSOR get_repair_lines(p_rep_group_id in number,

Line 287: -- update group level csd_repair_order_groups

283: IF (g_debug > 0 ) THEN
284: csd_gen_utility_pvt.ADD('In C5 updating group : '||C5.repair_group_id||' for wip_entity_id');
285: END IF;
286:
287: -- update group level csd_repair_order_groups
288: UPDATE csd_repair_order_groups
289: SET wip_entity_id = v_weid
290: WHERE repair_group_id = C5.repair_group_id;
291: Exception

Line 288: UPDATE csd_repair_order_groups

284: csd_gen_utility_pvt.ADD('In C5 updating group : '||C5.repair_group_id||' for wip_entity_id');
285: END IF;
286:
287: -- update group level csd_repair_order_groups
288: UPDATE csd_repair_order_groups
289: SET wip_entity_id = v_weid
290: WHERE repair_group_id = C5.repair_group_id;
291: Exception
292: when others then

Line 474: -- update group level csd_repair_order_groups

470: END IF;
471:
472: END LOOP; -- END LOOP FOR C3
473:
474: -- update group level csd_repair_order_groups
475: UPDATE csd_repair_order_groups
476: SET group_txn_status = 'WIP_COMPLETED',
477: completed_quantity = submitted_quantity
478: WHERE repair_group_id = C2.repair_group_id;

Line 475: UPDATE csd_repair_order_groups

471:
472: END LOOP; -- END LOOP FOR C3
473:
474: -- update group level csd_repair_order_groups
475: UPDATE csd_repair_order_groups
476: SET group_txn_status = 'WIP_COMPLETED',
477: completed_quantity = submitted_quantity
478: WHERE repair_group_id = C2.repair_group_id;
479:

Line 561: from csd_repair_order_groups crog,

557: crog.group_txn_status,
558: crog.repair_order_quantity,
559: crog.received_quantity,
560: crog.shipped_quantity
561: from csd_repair_order_groups crog,
562: csd_repair_types_vl crt
563: where crog.repair_type_id = crt.repair_type_id
564: and crog.incident_id = p_inc_id;
565:

Line 663: Update csd_repair_order_groups

659: csd_gen_utility_pvt.add('Updating group txn status and qty ');
660: END IF;
661:
662: -- Update txn_status and rcvd qty
663: Update csd_repair_order_groups
664: set received_quantity = nvl(repair_order_quantity,0) ,
665: group_txn_status = 'OM_RECEIVED'
666: where repair_group_id = grp.repair_group_id ;
667: ELSIF nvl(x_update_count,0) > 0 then

Line 673: Update csd_repair_order_groups

669: csd_gen_utility_pvt.add('Updating recd qty');
670: END IF;
671:
672: -- Update only the rcvd qty
673: Update csd_repair_order_groups
674: set received_quantity = nvl(received_quantity,0)+ x_update_count
675: where repair_group_id = grp.repair_group_id ;
676:
677: END IF;

Line 721: Update csd_repair_order_groups

717: csd_gen_utility_pvt.add('Updating group txn status and qty ');
718: END IF;
719:
720: -- Update txn_status and rcvd qty
721: Update csd_repair_order_groups
722: set received_quantity = nvl(repair_order_quantity,0) ,
723: group_txn_status = 'OM_RECEIVED'
724: where repair_group_id = grp.repair_group_id ;
725: ELSIF nvl(x_update_count,0) > 0 then

Line 731: Update csd_repair_order_groups

727: csd_gen_utility_pvt.add('Updating recd qty');
728: END IF;
729:
730: -- Update only the rcvd qty
731: Update csd_repair_order_groups
732: set received_quantity = nvl(received_quantity,0)+ x_update_count
733: where repair_group_id = grp.repair_group_id ;
734:
735: END IF;

Line 800: Update csd_repair_order_groups

796: csd_gen_utility_pvt.add('Updating group status and qty ');
797: END IF;
798:
799: -- Update txn_status and rcvd qty
800: Update csd_repair_order_groups
801: set shipped_quantity = nvl(repair_order_quantity,0) ,
802: group_txn_status = 'OM_SHIPPED'
803: where repair_group_id = grp.repair_group_id ;
804: ELSIF nvl(x_update_count,0) > 0 then

Line 810: Update csd_repair_order_groups

806: csd_gen_utility_pvt.add('updating shipped qty ='||x_update_count );
807: END IF;
808:
809: -- Update only rcvd qty
810: Update csd_repair_order_groups
811: set shipped_quantity = nvl(shipped_quantity,0)+x_update_count
812: where repair_group_id = grp.repair_group_id ;
813:
814: END IF;

Line 881: from csd_repair_order_groups crog,

877: crog.group_txn_status,
878: crog.repair_order_quantity,
879: crog.received_quantity,
880: crog.shipped_quantity
881: from csd_repair_order_groups crog,
882: csd_repair_types_vl crt
883: where crog.repair_type_id = crt.repair_type_id
884: and crog.incident_id = p_inc_id;
885:

Line 981: Update csd_repair_order_groups

977: csd_gen_utility_pvt.add('Updating the group txn status ');
978: END IF;
979:
980: -- Update txn_status and rcvd qty
981: Update csd_repair_order_groups
982: set received_quantity = nvl(received_quantity ,0) + nvl(x_update_count,0),
983: group_txn_status = 'OM_RECEIVED'
984: where repair_group_id = grp.repair_group_id ;
985: ELSIF nvl(x_update_count,0) > 0 then

Line 991: Update csd_repair_order_groups

987: csd_gen_utility_pvt.add('Updating the recd qty ');
988: END IF;
989:
990: -- Update only rcvd qty
991: Update csd_repair_order_groups
992: set received_quantity = nvl(received_quantity ,0) + nvl(x_update_count,0)
993: where repair_group_id = grp.repair_group_id ;
994:
995: END IF;

Line 1040: Update csd_repair_order_groups

1036: END IF;
1037:
1038:
1039: -- Update txn_status and rcvd qty
1040: Update csd_repair_order_groups
1041: set shipped_quantity = nvl(shipped_quantity ,0) + nvl(x_update_count,0),
1042: group_txn_status = 'OM_SHIPPED'
1043: where repair_group_id = grp.repair_group_id ;
1044:

Line 1051: Update csd_repair_order_groups

1047: csd_gen_utility_pvt.add('updating only shipped qty');
1048: END IF;
1049:
1050: -- Update txn_status and rcvd qty
1051: Update csd_repair_order_groups
1052: set shipped_quantity = nvl(shipped_quantity ,0) + nvl(x_update_count,0)
1053: where repair_group_id = grp.repair_group_id ;
1054: END IF;
1055:

Line 1099: Update csd_repair_order_groups

1095: csd_gen_utility_pvt.add('updating group txn status');
1096: END IF;
1097:
1098: -- Update txn_status and rcvd qty
1099: Update csd_repair_order_groups
1100: set shipped_quantity = nvl(shipped_quantity ,0) + nvl(x_update_count,0),
1101: group_txn_status = 'OM_SHIPPED'
1102: where repair_group_id = grp.repair_group_id ;
1103:

Line 1110: Update csd_repair_order_groups

1106: csd_gen_utility_pvt.add('updating only shipped qty');
1107: END IF;
1108:
1109: -- Update txn_status and rcvd qty
1110: Update csd_repair_order_groups
1111: set shipped_quantity = nvl(shipped_quantity ,0) + nvl(x_update_count,0)
1112: where repair_group_id = grp.repair_group_id ;
1113:
1114: END IF;