51: NULL,
52: 1,
53: 1,
54: SYSDATE,
55: FND_GLOBAL.USER_ID,
56: FND_GLOBAL.LOGIN_ID,
57: SYSDATE,
58: FND_GLOBAL.USER_ID,
59: FND_GLOBAL.CONC_REQUEST_ID,
52: 1,
53: 1,
54: SYSDATE,
55: FND_GLOBAL.USER_ID,
56: FND_GLOBAL.LOGIN_ID,
57: SYSDATE,
58: FND_GLOBAL.USER_ID,
59: FND_GLOBAL.CONC_REQUEST_ID,
60: FND_GLOBAL.PROG_APPL_ID,
54: SYSDATE,
55: FND_GLOBAL.USER_ID,
56: FND_GLOBAL.LOGIN_ID,
57: SYSDATE,
58: FND_GLOBAL.USER_ID,
59: FND_GLOBAL.CONC_REQUEST_ID,
60: FND_GLOBAL.PROG_APPL_ID,
61: FND_GLOBAL.CONC_PROGRAM_ID,
62: SYSDATE
55: FND_GLOBAL.USER_ID,
56: FND_GLOBAL.LOGIN_ID,
57: SYSDATE,
58: FND_GLOBAL.USER_ID,
59: FND_GLOBAL.CONC_REQUEST_ID,
60: FND_GLOBAL.PROG_APPL_ID,
61: FND_GLOBAL.CONC_PROGRAM_ID,
62: SYSDATE
63: FROM WIP_OPERATIONS
56: FND_GLOBAL.LOGIN_ID,
57: SYSDATE,
58: FND_GLOBAL.USER_ID,
59: FND_GLOBAL.CONC_REQUEST_ID,
60: FND_GLOBAL.PROG_APPL_ID,
61: FND_GLOBAL.CONC_PROGRAM_ID,
62: SYSDATE
63: FROM WIP_OPERATIONS
64: WHERE WIP_ENTITY_ID = P_WIP_ENTITY_ID
57: SYSDATE,
58: FND_GLOBAL.USER_ID,
59: FND_GLOBAL.CONC_REQUEST_ID,
60: FND_GLOBAL.PROG_APPL_ID,
61: FND_GLOBAL.CONC_PROGRAM_ID,
62: SYSDATE
63: FROM WIP_OPERATIONS
64: WHERE WIP_ENTITY_ID = P_WIP_ENTITY_ID
65: AND ORGANIZATION_ID = P_ORGANIZATION_ID);
105: usage_rate_or_amount,
106: 1,
107: 1,
108: SYSDATE,
109: FND_GLOBAL.USER_ID,
110: FND_GLOBAL.LOGIN_ID,
111: SYSDATE,
112: FND_GLOBAL.USER_ID,
113: FND_GLOBAL.CONC_REQUEST_ID,
106: 1,
107: 1,
108: SYSDATE,
109: FND_GLOBAL.USER_ID,
110: FND_GLOBAL.LOGIN_ID,
111: SYSDATE,
112: FND_GLOBAL.USER_ID,
113: FND_GLOBAL.CONC_REQUEST_ID,
114: FND_GLOBAL.PROG_APPL_ID,
108: SYSDATE,
109: FND_GLOBAL.USER_ID,
110: FND_GLOBAL.LOGIN_ID,
111: SYSDATE,
112: FND_GLOBAL.USER_ID,
113: FND_GLOBAL.CONC_REQUEST_ID,
114: FND_GLOBAL.PROG_APPL_ID,
115: FND_GLOBAL.CONC_PROGRAM_ID,
116: SYSDATE
109: FND_GLOBAL.USER_ID,
110: FND_GLOBAL.LOGIN_ID,
111: SYSDATE,
112: FND_GLOBAL.USER_ID,
113: FND_GLOBAL.CONC_REQUEST_ID,
114: FND_GLOBAL.PROG_APPL_ID,
115: FND_GLOBAL.CONC_PROGRAM_ID,
116: SYSDATE
117: FROM WIP_OPERATION_RESOURCES
110: FND_GLOBAL.LOGIN_ID,
111: SYSDATE,
112: FND_GLOBAL.USER_ID,
113: FND_GLOBAL.CONC_REQUEST_ID,
114: FND_GLOBAL.PROG_APPL_ID,
115: FND_GLOBAL.CONC_PROGRAM_ID,
116: SYSDATE
117: FROM WIP_OPERATION_RESOURCES
118: WHERE WIP_ENTITY_ID = P_WIP_ENTITY_ID
111: SYSDATE,
112: FND_GLOBAL.USER_ID,
113: FND_GLOBAL.CONC_REQUEST_ID,
114: FND_GLOBAL.PROG_APPL_ID,
115: FND_GLOBAL.CONC_PROGRAM_ID,
116: SYSDATE
117: FROM WIP_OPERATION_RESOURCES
118: WHERE WIP_ENTITY_ID = P_WIP_ENTITY_ID
119: AND ORGANIZATION_ID = P_ORGANIZATION_ID);
160: NULL,
161: 1,
162: 1,
163: SYSDATE,
164: FND_GLOBAL.USER_ID,
165: FND_GLOBAL.LOGIN_ID,
166: SYSDATE,
167: FND_GLOBAL.USER_ID,
168: FND_GLOBAL.CONC_REQUEST_ID,
161: 1,
162: 1,
163: SYSDATE,
164: FND_GLOBAL.USER_ID,
165: FND_GLOBAL.LOGIN_ID,
166: SYSDATE,
167: FND_GLOBAL.USER_ID,
168: FND_GLOBAL.CONC_REQUEST_ID,
169: FND_GLOBAL.PROG_APPL_ID,
163: SYSDATE,
164: FND_GLOBAL.USER_ID,
165: FND_GLOBAL.LOGIN_ID,
166: SYSDATE,
167: FND_GLOBAL.USER_ID,
168: FND_GLOBAL.CONC_REQUEST_ID,
169: FND_GLOBAL.PROG_APPL_ID,
170: FND_GLOBAL.CONC_PROGRAM_ID,
171: SYSDATE
164: FND_GLOBAL.USER_ID,
165: FND_GLOBAL.LOGIN_ID,
166: SYSDATE,
167: FND_GLOBAL.USER_ID,
168: FND_GLOBAL.CONC_REQUEST_ID,
169: FND_GLOBAL.PROG_APPL_ID,
170: FND_GLOBAL.CONC_PROGRAM_ID,
171: SYSDATE
172: FROM WIP_OPERATIONS
165: FND_GLOBAL.LOGIN_ID,
166: SYSDATE,
167: FND_GLOBAL.USER_ID,
168: FND_GLOBAL.CONC_REQUEST_ID,
169: FND_GLOBAL.PROG_APPL_ID,
170: FND_GLOBAL.CONC_PROGRAM_ID,
171: SYSDATE
172: FROM WIP_OPERATIONS
173: WHERE (WIP_ENTITY_ID, ORGANIZATION_ID) IN
166: SYSDATE,
167: FND_GLOBAL.USER_ID,
168: FND_GLOBAL.CONC_REQUEST_ID,
169: FND_GLOBAL.PROG_APPL_ID,
170: FND_GLOBAL.CONC_PROGRAM_ID,
171: SYSDATE
172: FROM WIP_OPERATIONS
173: WHERE (WIP_ENTITY_ID, ORGANIZATION_ID) IN
174: (SELECT WIP_ENTITY_ID,
219: USAGE_RATE_OR_AMOUNT,
220: 1,
221: 1,
222: SYSDATE,
223: FND_GLOBAL.USER_ID,
224: FND_GLOBAL.LOGIN_ID,
225: SYSDATE,
226: FND_GLOBAL.USER_ID,
227: FND_GLOBAL.CONC_REQUEST_ID,
220: 1,
221: 1,
222: SYSDATE,
223: FND_GLOBAL.USER_ID,
224: FND_GLOBAL.LOGIN_ID,
225: SYSDATE,
226: FND_GLOBAL.USER_ID,
227: FND_GLOBAL.CONC_REQUEST_ID,
228: FND_GLOBAL.PROG_APPL_ID,
222: SYSDATE,
223: FND_GLOBAL.USER_ID,
224: FND_GLOBAL.LOGIN_ID,
225: SYSDATE,
226: FND_GLOBAL.USER_ID,
227: FND_GLOBAL.CONC_REQUEST_ID,
228: FND_GLOBAL.PROG_APPL_ID,
229: FND_GLOBAL.CONC_PROGRAM_ID,
230: SYSDATE
223: FND_GLOBAL.USER_ID,
224: FND_GLOBAL.LOGIN_ID,
225: SYSDATE,
226: FND_GLOBAL.USER_ID,
227: FND_GLOBAL.CONC_REQUEST_ID,
228: FND_GLOBAL.PROG_APPL_ID,
229: FND_GLOBAL.CONC_PROGRAM_ID,
230: SYSDATE
231: FROM WIP_OPERATION_RESOURCES
224: FND_GLOBAL.LOGIN_ID,
225: SYSDATE,
226: FND_GLOBAL.USER_ID,
227: FND_GLOBAL.CONC_REQUEST_ID,
228: FND_GLOBAL.PROG_APPL_ID,
229: FND_GLOBAL.CONC_PROGRAM_ID,
230: SYSDATE
231: FROM WIP_OPERATION_RESOURCES
232: WHERE (WIP_ENTITY_ID, ORGANIZATION_ID) IN
225: SYSDATE,
226: FND_GLOBAL.USER_ID,
227: FND_GLOBAL.CONC_REQUEST_ID,
228: FND_GLOBAL.PROG_APPL_ID,
229: FND_GLOBAL.CONC_PROGRAM_ID,
230: SYSDATE
231: FROM WIP_OPERATION_RESOURCES
232: WHERE (WIP_ENTITY_ID, ORGANIZATION_ID) IN
233: (SELECT WIP_ENTITY_ID,