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_UPDATE_PROGRAMS_PVT dependencies on CSD_REPAIR_HISTORY

Line 1072: from csd_repair_history crh,

1068: and mt.transaction_source_id = JOB.wip_entity_id
1069: and mt.transaction_source_type_id = 5 -- Job or Schedule
1070: and mt.transaction_action_id = 31 -- Wip Assembly Completion
1071: and mut.serial_number not in (select crh.paramc3
1072: from csd_repair_history crh,
1073: csd_repair_job_xref crj
1074: where crh.repair_line_id = crj.repair_line_id
1075: and crj.wip_entity_id = JOB.wip_entity_id
1076: and crh.event_code = 'JC')

Line 1210: from csd_repair_history crh,

1206: and mt.transaction_source_id = JOB.wip_entity_id
1207: and mt.transaction_source_type_id = 5 -- Job or Schedule
1208: and mt.transaction_action_id = 31 -- Wip Assembly Completion
1209: and mut.serial_number not in (select crh.paramc3
1210: from csd_repair_history crh,
1211: csd_repair_job_xref crj
1212: where crh.repair_line_id = crj.repair_line_id
1213: and crj.wip_entity_id = JOB.wip_entity_id
1214: and crh.event_code = 'JC')

Line 1313: FROM CSD_REPAIR_HISTORY

1309: Exit;
1310: ELSE
1311: SELECT nvl(SUM(paramn5),0)
1312: INTO l_total_qty
1313: FROM CSD_REPAIR_HISTORY
1314: WHERE paramn3 = MTL.transaction_id
1315: AND paramn4 = JOB.wip_entity_id
1316: AND event_Code= 'JC';
1317:

Line 2227: FROM csd_repair_history crh

2223: AND rcvt.source_document_code = 'RMA'
2224: AND rcvt.organization_id = haou.organization_id
2225: AND NOT EXISTS
2226: (SELECT 'X'
2227: FROM csd_repair_history crh
2228: WHERE crh.repair_line_id = cpt.repair_line_id
2229: AND event_code = decode(rcvt.transaction_type,
2230: 'DELIVER','RR',
2231: 'ACCEPT', 'IP',

Line 2306: FROM csd_repair_history crh

2302: AND rcvt.source_document_code = 'RMA'
2303: AND rcvt.organization_id = haou.organization_id
2304: AND NOT EXISTS
2305: (SELECT 'X'
2306: FROM csd_repair_history crh
2307: WHERE crh.repair_line_id = cpt.repair_line_id
2308: AND event_code = decode(rcvt.transaction_type,
2309: 'DELIVER','RR',
2310: 'ACCEPT', 'IP',

Line 2379: FROM csd_repair_history crh

2375: AND rcvt.source_document_code = 'RMA'
2376: AND rcvt.organization_id = haou.organization_id
2377: AND NOT EXISTS
2378: (SELECT 'X'
2379: FROM csd_repair_history crh
2380: WHERE crh.repair_line_id = cpt.repair_line_id
2381: AND event_code = decode(rcvt.transaction_type,
2382: 'DELIVER','RR',
2383: 'ACCEPT', 'IP',

Line 3554: from csd_repair_history crh

3550: Debug('Processing Accept txn types',l_mod_name,1);
3551:
3552: select nvl(sum(paramn3),0)
3553: into l_total_accept_qty
3554: from csd_repair_history crh
3555: where crh.event_code = 'IP'
3556: and crh.paramn1 = RCV.transaction_id;
3557:
3558: -- Debug messages

Line 3568: from csd_repair_history crh

3564: END IF;
3565:
3566: select nvl(sum(paramn4),0), nvl(sum(paramn3),0)
3567: into l_pt_reject_qty, l_pt_accept_qty
3568: from csd_repair_history crh
3569: where crh.event_code = 'IP'
3570: and crh.paramn2 = RO.product_transaction_id;
3571: -- Debug messages
3572: Debug('l_pt_reject_qty :'||l_pt_reject_qty,l_mod_name,1);

Line 3654: from csd_repair_history crh

3650: Debug('In DEL Loop ',l_mod_name,1);
3651:
3652: select nvl(sum(quantity),0)
3653: into l_total_del_qty
3654: from csd_repair_history crh
3655: where crh.event_code = 'RRI'
3656: and crh.paramn1 = DEL.transaction_id;
3657: -- Debug messages
3658: Debug('l_total_del_qty : '||l_total_del_qty,l_mod_name,1);

Line 3668: from csd_repair_history crh

3664: END IF;
3665:
3666: select nvl(sum(quantity),0)
3667: into l_pt_del_qty
3668: from csd_repair_history crh
3669: where crh.event_code = 'RRI'
3670: and crh.paramn2 = RO.product_transaction_id;
3671: -- Debug messages
3672: Debug('l_pt_del_qty : '||l_pt_del_qty,l_mod_name,1);

Line 3929: from csd_repair_history crh

3925: -- Handles Inspection Required routing option
3926:
3927: select nvl(sum(paramn4),0)
3928: into l_total_reject_qty
3929: from csd_repair_history crh
3930: where crh.event_code = 'IP'
3931: and crh.paramn1 = RCV.transaction_id;
3932: IF l_total_reject_qty >= RCV.rcvd_qty THEN
3933: -- Debug messages

Line 3940: from csd_repair_history crh

3936: END IF;
3937:
3938: select nvl(sum(paramn3),0),nvl(sum(paramn4),0)
3939: into l_pt_accept_qty, l_pt_reject_qty
3940: from csd_repair_history crh
3941: where crh.event_code = 'IP'
3942: and crh.paramn2 = RO.product_transaction_id;
3943: -- Debug messages
3944: Debug('l_pt_accept_qty'||l_pt_accept_qty,l_mod_name,1);

Line 4022: from csd_repair_history crh

4018: Debug('In DEL Loop ',l_mod_name,1);
4019:
4020: select nvl(sum(quantity),0)
4021: into l_total_del_qty
4022: from csd_repair_history crh
4023: where crh.event_code = 'RRI'
4024: and crh.paramn1 = DEL.transaction_id;
4025: -- Debug messages
4026: Debug('l_total_del_qty : '||l_total_del_qty,l_mod_name,1);

Line 4036: from csd_repair_history crh

4032: END IF;
4033:
4034: select nvl(sum(quantity),0)
4035: into l_pt_del_qty
4036: from csd_repair_history crh
4037: where crh.event_code = 'RRI'
4038: and crh.paramn2 = RO.product_transaction_id;
4039: -- Debug messages
4040: Debug('l_pt_del_qty : '||l_pt_del_qty,l_mod_name,1);

Line 4299: from csd_repair_history crh

4295: -- Handles the Direct Delivery and standard routing options
4296:
4297: select nvl(sum(quantity),0)
4298: into l_total_qty
4299: from csd_repair_history crh
4300: where crh.event_code = 'RRI'
4301: and crh.paramn1 = RCV.transaction_id;
4302: IF l_total_qty >= RCV.rcvd_qty THEN
4303: -- Debug messages

Line 4310: from csd_repair_history crh

4306: END IF;
4307:
4308: select nvl(sum(quantity),0)
4309: into l_pt_del_qty
4310: from csd_repair_history crh
4311: where crh.event_code = 'RRI'
4312: and paramn2 = RO.product_transaction_id;
4313:
4314: -- Debug messages

Line 4970: from csd_repair_history crh

4966: Debug('Processing Accept txn types',l_mod_name,1);
4967:
4968: select nvl(sum(paramn3),0)
4969: into l_total_accept_qty
4970: from csd_repair_history crh
4971: where crh.event_code = 'IP'
4972: and crh.paramn1 = RCV.transaction_id;
4973:
4974: -- Debug messages

Line 4984: from csd_repair_history crh

4980: END IF;
4981:
4982: select nvl(sum(paramn4),0), nvl(sum(paramn3),0)
4983: into l_pt_reject_qty, l_pt_accept_qty
4984: from csd_repair_history crh
4985: where crh.event_code = 'IP'
4986: and crh.paramn2 = RO.product_transaction_id;
4987: -- Debug messages
4988: Debug('l_pt_reject_qty :'||l_pt_reject_qty,l_mod_name,1);

Line 5070: from csd_repair_history crh

5066: Debug('In DEL Loop ',l_mod_name,1);
5067:
5068: select nvl(sum(quantity),0)
5069: into l_total_del_qty
5070: from csd_repair_history crh
5071: where crh.event_code = 'RRI'
5072: and crh.paramn1 = DEL.transaction_id;
5073: -- Debug messages
5074: Debug('l_total_del_qty : '||l_total_del_qty,l_mod_name,1);

Line 5084: from csd_repair_history crh

5080: END IF;
5081:
5082: select nvl(sum(quantity),0)
5083: into l_pt_del_qty
5084: from csd_repair_history crh
5085: where crh.event_code = 'RRI'
5086: and crh.paramn2 = RO.product_transaction_id;
5087: -- Debug messages
5088: Debug('l_pt_del_qty : '||l_pt_del_qty,l_mod_name,1);

Line 5350: from csd_repair_history crh

5346: -- Handles Inspection Required routing option
5347:
5348: select nvl(sum(paramn4),0)
5349: into l_total_reject_qty
5350: from csd_repair_history crh
5351: where crh.event_code = 'IP'
5352: and crh.paramn1 = RCV.transaction_id;
5353: IF l_total_reject_qty >= RCV.rcvd_qty THEN
5354: -- Debug messages

Line 5361: from csd_repair_history crh

5357: END IF;
5358:
5359: select nvl(sum(paramn3),0),nvl(sum(paramn4),0)
5360: into l_pt_accept_qty, l_pt_reject_qty
5361: from csd_repair_history crh
5362: where crh.event_code = 'IP'
5363: and crh.paramn2 = RO.product_transaction_id;
5364: -- Debug messages
5365: Debug('l_pt_accept_qty'||l_pt_accept_qty,l_mod_name,1);

Line 5443: from csd_repair_history crh

5439: Debug('In DEL Loop ',l_mod_name,1);
5440:
5441: select nvl(sum(quantity),0)
5442: into l_total_del_qty
5443: from csd_repair_history crh
5444: where crh.event_code = 'RRI'
5445: and crh.paramn1 = DEL.transaction_id;
5446: -- Debug messages
5447: Debug('l_total_del_qty : '||l_total_del_qty,l_mod_name,1);

Line 5457: from csd_repair_history crh

5453: END IF;
5454:
5455: select nvl(sum(quantity),0)
5456: into l_pt_del_qty
5457: from csd_repair_history crh
5458: where crh.event_code = 'RRI'
5459: and crh.paramn2 = RO.product_transaction_id;
5460: -- Debug messages
5461: Debug('l_pt_del_qty : '||l_pt_del_qty,l_mod_name,1);

Line 5725: from csd_repair_history crh

5721: -- Handles the Direct Delivery and standard routing options
5722:
5723: select nvl(sum(quantity),0)
5724: into l_total_qty
5725: from csd_repair_history crh
5726: where crh.event_code = 'RRI'
5727: and crh.paramn1 = RCV.transaction_id;
5728: IF l_total_qty >= RCV.rcvd_qty THEN
5729: -- Debug messages

Line 5736: from csd_repair_history crh

5732: END IF;
5733:
5734: select nvl(sum(quantity),0)
5735: into l_pt_del_qty
5736: from csd_repair_history crh
5737: where crh.event_code = 'RRI'
5738: and paramn2 = RO.product_transaction_id;
5739:
5740: -- Debug messages

Line 6410: from csd_repair_history crh

6406: AND dd.released_status in ('C','I','Y') --bug#14657082, 15859195
6407: AND ced.source_code = 'DR'
6408: AND not exists
6409: (select 'NOT EXIST'
6410: from csd_repair_history crh
6411: where crh.repair_line_id = cpt.repair_line_id
6412: and crh.paramn1 = dd.delivery_detail_id
6413: and event_code = 'PS')
6414: AND oel.line_id in ( Select line_id

Line 6488: from csd_repair_history crh

6484: AND dd.released_status in ('C','I','Y') --bug#14657082, --15859195
6485: AND ced.source_code = 'DR'
6486: AND not exists
6487: (select 'NOT EXIST'
6488: from csd_repair_history crh
6489: where crh.repair_line_id = cpt.repair_line_id
6490: and crh.paramn1 = dd.delivery_detail_id
6491: and event_code = 'PS')
6492: AND oel.line_id in ( Select line_id

Line 6568: from csd_repair_history crh

6564: AND ced.source_code = 'DR'
6565: AND dd.source_code = 'OE' -- 12.1 FP bug#7551078, subhat
6566: AND not exists
6567: (select 'NOT EXIST'
6568: from csd_repair_history crh
6569: where crh.repair_line_id = cpt.repair_line_id
6570: and crh.paramn1 = dd.delivery_detail_id
6571: and event_code = 'PS')
6572: AND cpt.repair_line_id = p_repair_line_id

Line 7892: from csd_repair_history

7888: Debug('Processing the move-out lines ',l_mod_name,1);
7889:
7890: Select nvl(sum(quantity),0)
7891: into l_total_shipped_qty
7892: from csd_repair_history
7893: where event_code = 'PSI'
7894: and paramn1 = DEL.delivery_detail_id;
7895:
7896: -- Debug messages

Line 9387: ,csd_repair_history hist

9383: select tsk.task_id
9384: ,rep.repair_line_id
9385: --,max(hist.repair_history_id) repair_history_id
9386: from csd_repair_tasks_v tsk
9387: ,csd_repair_history hist
9388: ,csd_repairs rep
9389: where rep.repair_line_id = tsk.source_object_id
9390: and tsk.source_object_id = hist.repair_line_id
9391: and tsk.task_id = hist.paramn1

Line 9415: ,csd_repair_history hist

9411: tsk.last_update_date, -- hist.paramd4
9412: hist.paramc3, -- tsk.owner
9413: hist.paramc6 -- tsk.task_status
9414: from CSD_REPAIR_TASKS_V tsk
9415: ,csd_repair_history hist
9416: where tsk.source_object_type_code = 'DR'
9417: and tsk.task_id = l_task_id
9418: and tsk.source_object_id = l_repair_line_id
9419: and hist.repair_history_id = l_rep_hist_id

Line 9503: from CSD_REPAIR_HISTORY hist2

9499: l_task_status := ''; -- tsk.task_status
9500:
9501: select max(hist2.repair_history_id)
9502: into l_rep_hist_id
9503: from CSD_REPAIR_HISTORY hist2
9504: where hist2.repair_line_id = R.repair_line_id
9505: and hist2.paramn1 = R.task_id;
9506:
9507: l_task_id := R.task_id;