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.

[Home] [Help]

APPS.CSD_MIGRATE_FROM_115X_PKG6 dependencies on CSD_REPAIRS

Line 25: from jtf_tasks_vl, csd_repairs

21:
22: /*CURSOR get_repair_tasks(p_start_repair_line_id number, p_end_repair_line_id number)
23: IS
24: select jtf_tasks_vl.task_id, repair_line_id
25: from jtf_tasks_vl, csd_repairs
26: where jtf_tasks_vl.source_object_id = csd_repairs.repair_line_id
27: and source_object_type_code='DR'
28: and repair_line_id between p_start_repair_line_id
29: and p_end_repair_line_id

Line 26: where jtf_tasks_vl.source_object_id = csd_repairs.repair_line_id

22: /*CURSOR get_repair_tasks(p_start_repair_line_id number, p_end_repair_line_id number)
23: IS
24: select jtf_tasks_vl.task_id, repair_line_id
25: from jtf_tasks_vl, csd_repairs
26: where jtf_tasks_vl.source_object_id = csd_repairs.repair_line_id
27: and source_object_type_code='DR'
28: and repair_line_id between p_start_repair_line_id
29: and p_end_repair_line_id
30: and not exists( select 'x' from csd_tasks

Line 32: and csd_tasks.repair_line_id = csd_repairs.repair_line_id);*/

28: and repair_line_id between p_start_repair_line_id
29: and p_end_repair_line_id
30: and not exists( select 'x' from csd_tasks
31: where csd_tasks.task_id = jtf_tasks_vl.task_id
32: and csd_tasks.repair_line_id = csd_repairs.repair_line_id);*/
33:
34: BEGIN
35: -- Get the Slab Number for the table
36:

Line 39: CSD_MIG_SLABS_PKG.GET_TABLE_SLABS('CSD_REPAIRS',

35: -- Get the Slab Number for the table
36:
37: BEGIN
38:
39: CSD_MIG_SLABS_PKG.GET_TABLE_SLABS('CSD_REPAIRS',
40: 'CSD',
41: p_slab_number,
42: v_min,
43: v_max);

Line 67: csd_repairs.repair_line_id,

63: LAST_UPDATE_LOGIN
64: ) select
65: CSD.csd_tasks_s.nextval,
66: jtf_tasks_vl.task_id,
67: csd_repairs.repair_line_id,
68: 'N',
69: 1,
70: FND_GLOBAL.user_id,
71: SYSDATE,

Line 76: CSD_REPAIRS

72: FND_GLOBAL.user_id,
73: SYSDATE,
74: FND_GLOBAL.login_id
75: from jtf_tasks_vl,
76: CSD_REPAIRS
77: where jtf_tasks_vl.source_object_id = csd_repairs.repair_line_id
78: and source_object_type_code='DR'
79: and repair_line_id between v_min and v_max
80: and not exists( select 'x' from csd_tasks

Line 77: where jtf_tasks_vl.source_object_id = csd_repairs.repair_line_id

73: SYSDATE,
74: FND_GLOBAL.login_id
75: from jtf_tasks_vl,
76: CSD_REPAIRS
77: where jtf_tasks_vl.source_object_id = csd_repairs.repair_line_id
78: and source_object_type_code='DR'
79: and repair_line_id between v_min and v_max
80: and not exists( select 'x' from csd_tasks
81: where csd_tasks.task_id = jtf_tasks_vl.task_id

Line 82: and csd_tasks.repair_line_id = csd_repairs.repair_line_id);

78: and source_object_type_code='DR'
79: and repair_line_id between v_min and v_max
80: and not exists( select 'x' from csd_tasks
81: where csd_tasks.task_id = jtf_tasks_vl.task_id
82: and csd_tasks.repair_line_id = csd_repairs.repair_line_id);
83:
84:
85: COMMIT;
86:

Line 103: OF CSD.CSD_REPAIRS.REPAIR_LINE_ID%TYPE;

99: -- Definitions --
100: TYPE VARTAB IS TABLE OF VARCHAR2(1);
101: TYPE NUMTAB IS TABLE OF NUMBER;
102: TYPE REP_LINE_ID_ARRAY_TYPE IS VARRAY (1000)
103: OF CSD.CSD_REPAIRS.REPAIR_LINE_ID%TYPE;
104: TYPE ORIG_SOURCE_REF_ARRAY_TYPE IS VARRAY (1000)
105: OF CSD.CSD_REPAIRS.ORIGINAL_SOURCE_REFERENCE%TYPE;
106: TYPE FLOW_STATUS_ID_ARRAY_TYPE IS VARRAY (1000)
107: OF CSD.CSD_REPAIRS.FLOW_STATUS_ID%TYPE;

Line 105: OF CSD.CSD_REPAIRS.ORIGINAL_SOURCE_REFERENCE%TYPE;

101: TYPE NUMTAB IS TABLE OF NUMBER;
102: TYPE REP_LINE_ID_ARRAY_TYPE IS VARRAY (1000)
103: OF CSD.CSD_REPAIRS.REPAIR_LINE_ID%TYPE;
104: TYPE ORIG_SOURCE_REF_ARRAY_TYPE IS VARRAY (1000)
105: OF CSD.CSD_REPAIRS.ORIGINAL_SOURCE_REFERENCE%TYPE;
106: TYPE FLOW_STATUS_ID_ARRAY_TYPE IS VARRAY (1000)
107: OF CSD.CSD_REPAIRS.FLOW_STATUS_ID%TYPE;
108: TYPE INVENTORY_ORG_ID_ARRAY_TYPE IS VARRAY (1000)
109: OF CSD.CSD_REPAIRS.INVENTORY_ORG_ID%TYPE;

Line 107: OF CSD.CSD_REPAIRS.FLOW_STATUS_ID%TYPE;

103: OF CSD.CSD_REPAIRS.REPAIR_LINE_ID%TYPE;
104: TYPE ORIG_SOURCE_REF_ARRAY_TYPE IS VARRAY (1000)
105: OF CSD.CSD_REPAIRS.ORIGINAL_SOURCE_REFERENCE%TYPE;
106: TYPE FLOW_STATUS_ID_ARRAY_TYPE IS VARRAY (1000)
107: OF CSD.CSD_REPAIRS.FLOW_STATUS_ID%TYPE;
108: TYPE INVENTORY_ORG_ID_ARRAY_TYPE IS VARRAY (1000)
109: OF CSD.CSD_REPAIRS.INVENTORY_ORG_ID%TYPE;
110: TYPE INVENTORY_ITEM_ID_ARRAY_TYPE IS VARRAY (1000)
111: OF CSD.CSD_REPAIRS.INVENTORY_ITEM_ID%TYPE;

Line 109: OF CSD.CSD_REPAIRS.INVENTORY_ORG_ID%TYPE;

105: OF CSD.CSD_REPAIRS.ORIGINAL_SOURCE_REFERENCE%TYPE;
106: TYPE FLOW_STATUS_ID_ARRAY_TYPE IS VARRAY (1000)
107: OF CSD.CSD_REPAIRS.FLOW_STATUS_ID%TYPE;
108: TYPE INVENTORY_ORG_ID_ARRAY_TYPE IS VARRAY (1000)
109: OF CSD.CSD_REPAIRS.INVENTORY_ORG_ID%TYPE;
110: TYPE INVENTORY_ITEM_ID_ARRAY_TYPE IS VARRAY (1000)
111: OF CSD.CSD_REPAIRS.INVENTORY_ITEM_ID%TYPE;
112:
113: -- Variables --

Line 111: OF CSD.CSD_REPAIRS.INVENTORY_ITEM_ID%TYPE;

107: OF CSD.CSD_REPAIRS.FLOW_STATUS_ID%TYPE;
108: TYPE INVENTORY_ORG_ID_ARRAY_TYPE IS VARRAY (1000)
109: OF CSD.CSD_REPAIRS.INVENTORY_ORG_ID%TYPE;
110: TYPE INVENTORY_ITEM_ID_ARRAY_TYPE IS VARRAY (1000)
111: OF CSD.CSD_REPAIRS.INVENTORY_ITEM_ID%TYPE;
112:
113: -- Variables --
114: repair_line_id_arr REP_LINE_ID_ARRAY_TYPE;
115: original_source_reference_arr ORIG_SOURCE_REF_ARRAY_TYPE;

Line 149: from csd_repairs

145: original_source_reference,
146: flow_status_id,
147: inventory_org_id,
148: inventory_item_id
149: from csd_repairs
150: where flow_status_id is null
151: or inventory_org_id is null;
152:
153: -- Cursor to get om rma org id

Line 157: csd_repairs cr

153: -- Cursor to get om rma org id
154: CURSOR c_get_om_rma_org_id (p_repair_line_id in number) IS
155: SELECT oel.ship_from_org_id
156: FROM oe_order_lines_all oel,
157: csd_repairs cr
158: WHERE
159: cr.repair_line_id = p_repair_line_id
160: AND cr.original_source_header_id = oel.header_id
161: AND cr.original_source_line_id = oel.line_id;

Line 392: UPDATE CSD_REPAIRS

388: CLOSE c_get_item_org_id;
389:
390: END IF;
391:
392: UPDATE CSD_REPAIRS
393: SET flow_Status_id = decode(status,
394: 'O', FlowStatusIDs(c_open_index),
395: 'C', FlowStatusIDs(c_closed_index),
396: 'H', FlowStatusIDs(c_hold_index),

Line 435: OF CSD.CSD_REPAIRS.inventory_item_id%TYPE;

431: -- Definitions --
432: TYPE REP_LINE_ID_ARRAY_TYPE IS VARRAY (1000)
433: OF CSD.CSD_RO_DIAGNOSTIC_CODES.REPAIR_LINE_ID%TYPE;
434: TYPE INV_ITEM_ID_ARRAY_TYPE IS VARRAY(1000)
435: OF CSD.CSD_REPAIRS.inventory_item_id%TYPE;
436:
437: -- Variables --
438: rep_line_id_arr REP_LINE_ID_ARRAY_TYPE;
439: inv_item_id_arr INV_ITEM_ID_ARRAY_TYPE;

Line 457: CSD_REPAIRS rep

453: SELECT DISTINCT
454: dc.repair_line_id, rep.inventory_item_id
455: FROM
456: CSD_RO_DIAGNOSTIC_CODES dc,
457: CSD_REPAIRS rep
458: WHERE dc.diagnostic_item_id IS NULL
459: AND rep.repair_line_id = dc.repair_line_id;
460:
461: BEGIN

Line 513: OF CSD.CSD_REPAIRS.INVENTORY_ITEM_ID%TYPE;

509: -- Definitions --
510: TYPE REP_LINE_ID_ARRAY_TYPE IS VARRAY (1000)
511: OF CSD.CSD_RO_SERVICE_CODES.REPAIR_LINE_ID%TYPE;
512: TYPE INV_ITEM_ID_ARRAY_TYPE IS VARRAY(1000)
513: OF CSD.CSD_REPAIRS.INVENTORY_ITEM_ID%TYPE;
514:
515: -- Variables --
516: rep_line_id_arr REP_LINE_ID_ARRAY_TYPE;
517: inv_item_id_arr INV_ITEM_ID_ARRAY_TYPE;

Line 535: CSD_REPAIRS rep

531: SELECT DISTINCT
532: sc.repair_line_id, rep.inventory_item_id
533: FROM
534: CSD_RO_SERVICE_CODES sc,
535: CSD_REPAIRS rep
536: WHERE sc.service_item_id IS NULL
537: AND rep.repair_line_id = sc.repair_line_id;
538:
539: BEGIN