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 1065: from csd_repair_history crh,

1061: and mt.transaction_source_id = JOB.wip_entity_id
1062: and mt.transaction_source_type_id = 5 -- Job or Schedule
1063: and mt.transaction_action_id = 31 -- Wip Assembly Completion
1064: and mut.serial_number not in (select crh.paramc3
1065: from csd_repair_history crh,
1066: csd_repair_job_xref crj
1067: where crh.repair_line_id = crj.repair_line_id
1068: and crj.wip_entity_id = JOB.wip_entity_id
1069: and crh.event_code = 'JC')

Line 1203: from csd_repair_history crh,

1199: and mt.transaction_source_id = JOB.wip_entity_id
1200: and mt.transaction_source_type_id = 5 -- Job or Schedule
1201: and mt.transaction_action_id = 31 -- Wip Assembly Completion
1202: and mut.serial_number not in (select crh.paramc3
1203: from csd_repair_history crh,
1204: csd_repair_job_xref crj
1205: where crh.repair_line_id = crj.repair_line_id
1206: and crj.wip_entity_id = JOB.wip_entity_id
1207: and crh.event_code = 'JC')

Line 1306: FROM CSD_REPAIR_HISTORY

1302: Exit;
1303: ELSE
1304: SELECT nvl(SUM(paramn5),0)
1305: INTO l_total_qty
1306: FROM CSD_REPAIR_HISTORY
1307: WHERE paramn3 = MTL.transaction_id
1308: AND paramn4 = JOB.wip_entity_id
1309: AND event_Code= 'JC';
1310:

Line 2167: FROM csd_repair_history crh

2163: AND rcvt.source_document_code = 'RMA'
2164: AND rcvt.organization_id = haou.organization_id
2165: AND NOT EXISTS
2166: (SELECT 'X'
2167: FROM csd_repair_history crh
2168: WHERE crh.repair_line_id = cpt.repair_line_id
2169: AND event_code = decode(rcvt.transaction_type,
2170: 'DELIVER','RR',
2171: 'ACCEPT', 'IP',

Line 2245: FROM csd_repair_history crh

2241: AND rcvt.source_document_code = 'RMA'
2242: AND rcvt.organization_id = haou.organization_id
2243: AND NOT EXISTS
2244: (SELECT 'X'
2245: FROM csd_repair_history crh
2246: WHERE crh.repair_line_id = cpt.repair_line_id
2247: AND event_code = decode(rcvt.transaction_type,
2248: 'DELIVER','RR',
2249: 'ACCEPT', 'IP',

Line 2317: FROM csd_repair_history crh

2313: AND rcvt.source_document_code = 'RMA'
2314: AND rcvt.organization_id = haou.organization_id
2315: AND NOT EXISTS
2316: (SELECT 'X'
2317: FROM csd_repair_history crh
2318: WHERE crh.repair_line_id = cpt.repair_line_id
2319: AND event_code = decode(rcvt.transaction_type,
2320: 'DELIVER','RR',
2321: 'ACCEPT', 'IP',

Line 3393: from csd_repair_history crh

3389: Debug('Processing Accept txn types',l_mod_name,1);
3390:
3391: select nvl(sum(paramn3),0)
3392: into l_total_accept_qty
3393: from csd_repair_history crh
3394: where crh.event_code = 'IP'
3395: and crh.paramn1 = RCV.transaction_id;
3396:
3397: -- Debug messages

Line 3407: from csd_repair_history crh

3403: END IF;
3404:
3405: select nvl(sum(paramn4),0), nvl(sum(paramn3),0)
3406: into l_pt_reject_qty, l_pt_accept_qty
3407: from csd_repair_history crh
3408: where crh.event_code = 'IP'
3409: and crh.paramn2 = RO.product_transaction_id;
3410: -- Debug messages
3411: Debug('l_pt_reject_qty :'||l_pt_reject_qty,l_mod_name,1);

Line 3493: from csd_repair_history crh

3489: Debug('In DEL Loop ',l_mod_name,1);
3490:
3491: select nvl(sum(quantity),0)
3492: into l_total_del_qty
3493: from csd_repair_history crh
3494: where crh.event_code = 'RRI'
3495: and crh.paramn1 = DEL.transaction_id;
3496: -- Debug messages
3497: Debug('l_total_del_qty : '||l_total_del_qty,l_mod_name,1);

Line 3507: from csd_repair_history crh

3503: END IF;
3504:
3505: select nvl(sum(quantity),0)
3506: into l_pt_del_qty
3507: from csd_repair_history crh
3508: where crh.event_code = 'RRI'
3509: and crh.paramn2 = RO.product_transaction_id;
3510: -- Debug messages
3511: Debug('l_pt_del_qty : '||l_pt_del_qty,l_mod_name,1);

Line 3768: from csd_repair_history crh

3764: -- Handles Inspection Required routing option
3765:
3766: select nvl(sum(paramn4),0)
3767: into l_total_reject_qty
3768: from csd_repair_history crh
3769: where crh.event_code = 'IP'
3770: and crh.paramn1 = RCV.transaction_id;
3771: IF l_total_reject_qty >= RCV.rcvd_qty THEN
3772: -- Debug messages

Line 3779: from csd_repair_history crh

3775: END IF;
3776:
3777: select nvl(sum(paramn3),0),nvl(sum(paramn4),0)
3778: into l_pt_accept_qty, l_pt_reject_qty
3779: from csd_repair_history crh
3780: where crh.event_code = 'IP'
3781: and crh.paramn2 = RO.product_transaction_id;
3782: -- Debug messages
3783: Debug('l_pt_accept_qty'||l_pt_accept_qty,l_mod_name,1);

Line 3861: from csd_repair_history crh

3857: Debug('In DEL Loop ',l_mod_name,1);
3858:
3859: select nvl(sum(quantity),0)
3860: into l_total_del_qty
3861: from csd_repair_history crh
3862: where crh.event_code = 'RRI'
3863: and crh.paramn1 = DEL.transaction_id;
3864: -- Debug messages
3865: Debug('l_total_del_qty : '||l_total_del_qty,l_mod_name,1);

Line 3875: from csd_repair_history crh

3871: END IF;
3872:
3873: select nvl(sum(quantity),0)
3874: into l_pt_del_qty
3875: from csd_repair_history crh
3876: where crh.event_code = 'RRI'
3877: and crh.paramn2 = RO.product_transaction_id;
3878: -- Debug messages
3879: Debug('l_pt_del_qty : '||l_pt_del_qty,l_mod_name,1);

Line 4138: from csd_repair_history crh

4134: -- Handles the Direct Delivery and standard routing options
4135:
4136: select nvl(sum(quantity),0)
4137: into l_total_qty
4138: from csd_repair_history crh
4139: where crh.event_code = 'RRI'
4140: and crh.paramn1 = RCV.transaction_id;
4141: IF l_total_qty >= RCV.rcvd_qty THEN
4142: -- Debug messages

Line 4149: from csd_repair_history crh

4145: END IF;
4146:
4147: select nvl(sum(quantity),0)
4148: into l_pt_del_qty
4149: from csd_repair_history crh
4150: where crh.event_code = 'RRI'
4151: and paramn2 = RO.product_transaction_id;
4152:
4153: -- Debug messages

Line 4809: from csd_repair_history crh

4805: Debug('Processing Accept txn types',l_mod_name,1);
4806:
4807: select nvl(sum(paramn3),0)
4808: into l_total_accept_qty
4809: from csd_repair_history crh
4810: where crh.event_code = 'IP'
4811: and crh.paramn1 = RCV.transaction_id;
4812:
4813: -- Debug messages

Line 4823: from csd_repair_history crh

4819: END IF;
4820:
4821: select nvl(sum(paramn4),0), nvl(sum(paramn3),0)
4822: into l_pt_reject_qty, l_pt_accept_qty
4823: from csd_repair_history crh
4824: where crh.event_code = 'IP'
4825: and crh.paramn2 = RO.product_transaction_id;
4826: -- Debug messages
4827: Debug('l_pt_reject_qty :'||l_pt_reject_qty,l_mod_name,1);

Line 4909: from csd_repair_history crh

4905: Debug('In DEL Loop ',l_mod_name,1);
4906:
4907: select nvl(sum(quantity),0)
4908: into l_total_del_qty
4909: from csd_repair_history crh
4910: where crh.event_code = 'RRI'
4911: and crh.paramn1 = DEL.transaction_id;
4912: -- Debug messages
4913: Debug('l_total_del_qty : '||l_total_del_qty,l_mod_name,1);

Line 4923: from csd_repair_history crh

4919: END IF;
4920:
4921: select nvl(sum(quantity),0)
4922: into l_pt_del_qty
4923: from csd_repair_history crh
4924: where crh.event_code = 'RRI'
4925: and crh.paramn2 = RO.product_transaction_id;
4926: -- Debug messages
4927: Debug('l_pt_del_qty : '||l_pt_del_qty,l_mod_name,1);

Line 5189: from csd_repair_history crh

5185: -- Handles Inspection Required routing option
5186:
5187: select nvl(sum(paramn4),0)
5188: into l_total_reject_qty
5189: from csd_repair_history crh
5190: where crh.event_code = 'IP'
5191: and crh.paramn1 = RCV.transaction_id;
5192: IF l_total_reject_qty >= RCV.rcvd_qty THEN
5193: -- Debug messages

Line 5200: from csd_repair_history crh

5196: END IF;
5197:
5198: select nvl(sum(paramn3),0),nvl(sum(paramn4),0)
5199: into l_pt_accept_qty, l_pt_reject_qty
5200: from csd_repair_history crh
5201: where crh.event_code = 'IP'
5202: and crh.paramn2 = RO.product_transaction_id;
5203: -- Debug messages
5204: Debug('l_pt_accept_qty'||l_pt_accept_qty,l_mod_name,1);

Line 5282: from csd_repair_history crh

5278: Debug('In DEL Loop ',l_mod_name,1);
5279:
5280: select nvl(sum(quantity),0)
5281: into l_total_del_qty
5282: from csd_repair_history crh
5283: where crh.event_code = 'RRI'
5284: and crh.paramn1 = DEL.transaction_id;
5285: -- Debug messages
5286: Debug('l_total_del_qty : '||l_total_del_qty,l_mod_name,1);

Line 5296: from csd_repair_history crh

5292: END IF;
5293:
5294: select nvl(sum(quantity),0)
5295: into l_pt_del_qty
5296: from csd_repair_history crh
5297: where crh.event_code = 'RRI'
5298: and crh.paramn2 = RO.product_transaction_id;
5299: -- Debug messages
5300: Debug('l_pt_del_qty : '||l_pt_del_qty,l_mod_name,1);

Line 5564: from csd_repair_history crh

5560: -- Handles the Direct Delivery and standard routing options
5561:
5562: select nvl(sum(quantity),0)
5563: into l_total_qty
5564: from csd_repair_history crh
5565: where crh.event_code = 'RRI'
5566: and crh.paramn1 = RCV.transaction_id;
5567: IF l_total_qty >= RCV.rcvd_qty THEN
5568: -- Debug messages

Line 5575: from csd_repair_history crh

5571: END IF;
5572:
5573: select nvl(sum(quantity),0)
5574: into l_pt_del_qty
5575: from csd_repair_history crh
5576: where crh.event_code = 'RRI'
5577: and paramn2 = RO.product_transaction_id;
5578:
5579: -- Debug messages

Line 6210: from csd_repair_history crh

6206: AND dd.released_status in ('C','I')
6207: AND ced.source_code = 'DR'
6208: AND not exists
6209: (select 'NOT EXIST'
6210: from csd_repair_history crh
6211: where crh.repair_line_id = cpt.repair_line_id
6212: and crh.paramn1 = dd.delivery_detail_id
6213: and event_code = 'PS')
6214: AND oel.line_id in ( Select line_id

Line 6287: from csd_repair_history crh

6283: AND dd.released_status in ('C','I')
6284: AND ced.source_code = 'DR'
6285: AND not exists
6286: (select 'NOT EXIST'
6287: from csd_repair_history crh
6288: where crh.repair_line_id = cpt.repair_line_id
6289: and crh.paramn1 = dd.delivery_detail_id
6290: and event_code = 'PS')
6291: AND oel.line_id in ( Select line_id

Line 6366: from csd_repair_history crh

6362: AND ced.source_code = 'DR'
6363: AND dd.source_code = 'OE' -- 12.1 FP bug#7551078, subhat
6364: AND not exists
6365: (select 'NOT EXIST'
6366: from csd_repair_history crh
6367: where crh.repair_line_id = cpt.repair_line_id
6368: and crh.paramn1 = dd.delivery_detail_id
6369: and event_code = 'PS')
6370: AND cpt.repair_line_id = p_repair_line_id

Line 7600: from csd_repair_history

7596: Debug('Processing the move-out lines ',l_mod_name,1);
7597:
7598: Select nvl(sum(quantity),0)
7599: into l_total_shipped_qty
7600: from csd_repair_history
7601: where event_code = 'PSI'
7602: and paramn1 = DEL.delivery_detail_id;
7603:
7604: -- Debug messages

Line 9035: ,csd_repair_history hist

9031: select tsk.task_id
9032: ,rep.repair_line_id
9033: --,max(hist.repair_history_id) repair_history_id
9034: from csd_repair_tasks_v tsk
9035: ,csd_repair_history hist
9036: ,csd_repairs rep
9037: where rep.repair_line_id = tsk.source_object_id
9038: and tsk.source_object_id = hist.repair_line_id
9039: and tsk.task_id = hist.paramn1

Line 9063: ,csd_repair_history hist

9059: tsk.last_update_date, -- hist.paramd4
9060: hist.paramc3, -- tsk.owner
9061: hist.paramc6 -- tsk.task_status
9062: from CSD_REPAIR_TASKS_V tsk
9063: ,csd_repair_history hist
9064: where tsk.source_object_type_code = 'DR'
9065: and tsk.task_id = l_task_id
9066: and tsk.source_object_id = l_repair_line_id
9067: and hist.repair_history_id = l_rep_hist_id

Line 9151: from CSD_REPAIR_HISTORY hist2

9147: l_task_status := ''; -- tsk.task_status
9148:
9149: select max(hist2.repair_history_id)
9150: into l_rep_hist_id
9151: from CSD_REPAIR_HISTORY hist2
9152: where hist2.repair_line_id = R.repair_line_id
9153: and hist2.paramn1 = R.task_id;
9154:
9155: l_task_id := R.task_id;