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_LINES_ALL

Line 17: -- OE_ORDER_LINES_ALL

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';
19: g_publication_item_name2 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
20: JTM_HOOK_UTIL_PKG.t_publication_item_list('OE_ORDER_LINES_ALL');
21: g_pk1_name2 CONSTANT VARCHAR2(30) := 'LINE_ID';

Line 18: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'JTM_OE_ORDER_LINES_ALL_ACC';

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';
19: g_publication_item_name2 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
20: JTM_HOOK_UTIL_PKG.t_publication_item_list('OE_ORDER_LINES_ALL');
21: g_pk1_name2 CONSTANT VARCHAR2(30) := 'LINE_ID';
22:

Line 20: JTM_HOOK_UTIL_PKG.t_publication_item_list('OE_ORDER_LINES_ALL');

16:
17: -- OE_ORDER_LINES_ALL
18: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'JTM_OE_ORDER_LINES_ALL_ACC';
19: g_publication_item_name2 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
20: JTM_HOOK_UTIL_PKG.t_publication_item_list('OE_ORDER_LINES_ALL');
21: g_pk1_name2 CONSTANT VARCHAR2(30) := 'LINE_ID';
22:
23: g_table_name CONSTANT VARCHAR2(30) := 'CSP_REQUIREMENT_LINES';
24: g_debug_level NUMBER; -- debug level

Line 127: , OE_ORDER_LINES_ALL OL

123: , RH.DESTINATION_ORGANIZATION_ID
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 (+)

Line 144: , oe_order_lines_all ol

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
148: AND crl.requirement_line_id = b_req_line_id

Line 231: -- OE_ORDER_LINES_ALL

227: , P_PK1_NAME => g_pk1_name1
228: , P_PK1_NUM_VALUE => l_header_id
229: , P_RESOURCE_ID => l_resource_id
230: );
231: -- OE_ORDER_LINES_ALL
232: JTM_HOOK_UTIL_PKG.Insert_Acc
233: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name2
234: , P_ACC_TABLE_NAME => g_acc_table_name2
235: , P_PK1_NAME => g_pk1_name2

Line 264: , OE_ORDER_LINES_ALL OL

260: , RH.DESTINATION_ORGANIZATION_ID
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 (+)

Line 281: , oe_order_lines_all ol

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
285: AND crl.requirement_line_id = b_req_line_id

Line 367: -- OE_ORDER_LINES_ALL

363: , P_PK1_NAME => g_pk1_name1
364: , P_PK1_NUM_VALUE => l_header_id
365: , P_RESOURCE_ID => l_resource_id
366: );
367: -- OE_ORDER_LINES_ALL
368: JTM_HOOK_UTIL_PKG.Insert_Acc
369: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name2
370: , P_ACC_TABLE_NAME => g_acc_table_name2
371: , P_PK1_NAME => g_pk1_name2

Line 399: , OE_ORDER_LINES_ALL OL

395: , OH.HEADER_ID
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 (+)