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.CSL_CSP_REQ_LINES_ACC_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 11: -- OE_ORDER_HEADERS_ALL

7: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
8: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSP_REQUIREMENT_LINES');
9: g_pk1_name CONSTANT VARCHAR2(30) := 'REQUIREMENT_LINE_ID';
10:
11: -- OE_ORDER_HEADERS_ALL
12: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'JTM_OE_ORDER_HEADERS_ALL_ACC';
13: g_publication_item_name1 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
14: JTM_HOOK_UTIL_PKG.t_publication_item_list('OE_ORDER_HEADERS_ALL');
15: g_pk1_name1 CONSTANT VARCHAR2(30) := 'HEADER_ID';

Line 12: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'JTM_OE_ORDER_HEADERS_ALL_ACC';

8: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSP_REQUIREMENT_LINES');
9: g_pk1_name CONSTANT VARCHAR2(30) := 'REQUIREMENT_LINE_ID';
10:
11: -- OE_ORDER_HEADERS_ALL
12: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'JTM_OE_ORDER_HEADERS_ALL_ACC';
13: g_publication_item_name1 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
14: JTM_HOOK_UTIL_PKG.t_publication_item_list('OE_ORDER_HEADERS_ALL');
15: g_pk1_name1 CONSTANT VARCHAR2(30) := 'HEADER_ID';
16:

Line 14: JTM_HOOK_UTIL_PKG.t_publication_item_list('OE_ORDER_HEADERS_ALL');

10:
11: -- OE_ORDER_HEADERS_ALL
12: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'JTM_OE_ORDER_HEADERS_ALL_ACC';
13: g_publication_item_name1 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
14: JTM_HOOK_UTIL_PKG.t_publication_item_list('OE_ORDER_HEADERS_ALL');
15: g_pk1_name1 CONSTANT VARCHAR2(30) := 'HEADER_ID';
16:
17: -- OE_ORDER_LINES_ALL
18: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'JTM_OE_ORDER_LINES_ALL_ACC';

Line 128: , OE_ORDER_HEADERS_ALL OH

124: , RL.INVENTORY_ITEM_ID
125: FROM CSP_REQUIREMENT_HEADERS RH
126: , CSP_REQUIREMENT_LINES RL
127: , OE_ORDER_LINES_ALL OL
128: , OE_ORDER_HEADERS_ALL OH
129: WHERE RH.REQUIREMENT_HEADER_ID = RL.REQUIREMENT_HEADER_ID
130: AND RL.REQUIREMENT_LINE_ID = b_req_line_id
131: AND RL.ORDER_LINE_ID = OL.LINE_ID (+)
132: AND OL.HEADER_ID = OH.HEADER_ID (+);

Line 143: , oe_order_headers_all oh

139: , ol.line_id
140: FROM jtf.jtf_task_assignments jta
141: , csp_requirement_headers crh
142: , csp_requirement_lines crl
143: , oe_order_headers_all oh
144: , oe_order_lines_all ol
145: WHERE crh.task_assignment_id = jta.task_assignment_id
146: AND jta.assignee_role = 'ASSIGNEE'
147: AND crh.requirement_header_id = crl.requirement_header_id

Line 223: -- OE_ORDER_HEADERS_ALL

219: , P_RESOURCE_ID => l_resource_id
220: );
221:
222: IF (l_header_id IS NOT NULL) THEN
223: -- OE_ORDER_HEADERS_ALL
224: JTM_HOOK_UTIL_PKG.Insert_Acc
225: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
226: , P_ACC_TABLE_NAME => g_acc_table_name1
227: , P_PK1_NAME => g_pk1_name1

Line 265: , OE_ORDER_HEADERS_ALL OH

261: , RL.INVENTORY_ITEM_ID
262: FROM CSP_REQUIREMENT_HEADERS RH
263: , CSP_REQUIREMENT_LINES RL
264: , OE_ORDER_LINES_ALL OL
265: , OE_ORDER_HEADERS_ALL OH
266: WHERE RH.REQUIREMENT_HEADER_ID = RL.REQUIREMENT_HEADER_ID
267: AND RL.REQUIREMENT_LINE_ID = b_req_line_id
268: AND RL.ORDER_LINE_ID = OL.LINE_ID (+)
269: AND OL.HEADER_ID = OH.HEADER_ID (+);

Line 280: , oe_order_headers_all oh

276: , ol.line_id
277: FROM jtf.jtf_task_assignments jta
278: , csp_requirement_headers crh
279: , csp_requirement_lines crl
280: , oe_order_headers_all oh
281: , oe_order_lines_all ol
282: WHERE crh.task_assignment_id = jta.task_assignment_id
283: AND jta.assignee_role = 'ASSIGNEE'
284: AND crh.requirement_header_id = crl.requirement_header_id

Line 359: -- OE_ORDER_HEADERS_ALL

355: ,p_req_line_id
356: );
357:
358: IF (l_header_id IS NOT NULL) THEN
359: -- OE_ORDER_HEADERS_ALL
360: JTM_HOOK_UTIL_PKG.Insert_Acc
361: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
362: , P_ACC_TABLE_NAME => g_acc_table_name1
363: , P_PK1_NAME => g_pk1_name1

Line 400: , OE_ORDER_HEADERS_ALL OH

396: , OL.LINE_ID
397: FROM CSP_REQUIREMENT_HEADERS RH
398: , CSP_REQUIREMENT_LINES RL
399: , OE_ORDER_LINES_ALL OL
400: , OE_ORDER_HEADERS_ALL OH
401: WHERE RH.REQUIREMENT_HEADER_ID = RL.REQUIREMENT_HEADER_ID
402: AND RL.REQUIREMENT_LINE_ID = b_req_line_id
403: AND RL.ORDER_LINE_ID = OL.LINE_ID (+)
404: AND OL.HEADER_ID = OH.HEADER_ID (+);