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.INV_LABEL_PVT13 dependencies on FND_DATE

Line 114: l_calendar_aware NUMBER := FND_DATE.calendar_aware_alt;

110: l_print_count NUMBER;
111: l_temp_print_count NUMBER;
112: l_temp_transaction_id NUMBER;
113: l_reprint VARCHAR2(10);
114: l_calendar_aware NUMBER := FND_DATE.calendar_aware_alt;
115:
116: ---------------------------------------------------------------------------------------------
117: -- Project: 'Custom Labels' (A 11i10+ Project) |
118: ---------------------------------------------------------------------------------------------

Line 149: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.creation_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) creation_date,

145: bh.batch_no batch_no,
146: bh.formula_no formula_no,
147: bh.routing_no routing_no,
148: -- character date international calendar support project
149: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.creation_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) creation_date,
150: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_start_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_start_date,
151: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_start_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_start_date,
152: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.due_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) due_date,
153: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_cmplt_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_completion_date,

Line 150: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_start_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_start_date,

146: bh.formula_no formula_no,
147: bh.routing_no routing_no,
148: -- character date international calendar support project
149: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.creation_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) creation_date,
150: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_start_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_start_date,
151: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_start_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_start_date,
152: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.due_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) due_date,
153: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_cmplt_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_completion_date,
154: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_cmplt_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_completion_date,

Line 151: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_start_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_start_date,

147: bh.routing_no routing_no,
148: -- character date international calendar support project
149: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.creation_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) creation_date,
150: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_start_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_start_date,
151: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_start_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_start_date,
152: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.due_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) due_date,
153: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_cmplt_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_completion_date,
154: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_cmplt_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_completion_date,
155: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.batch_close_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) batch_close_date,

Line 152: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.due_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) due_date,

148: -- character date international calendar support project
149: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.creation_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) creation_date,
150: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_start_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_start_date,
151: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_start_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_start_date,
152: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.due_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) due_date,
153: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_cmplt_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_completion_date,
154: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_cmplt_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_completion_date,
155: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.batch_close_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) batch_close_date,
156: msi.CONCATENATED_SEGMENTS item,

Line 153: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_cmplt_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_completion_date,

149: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.creation_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) creation_date,
150: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_start_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_start_date,
151: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_start_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_start_date,
152: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.due_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) due_date,
153: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_cmplt_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_completion_date,
154: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_cmplt_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_completion_date,
155: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.batch_close_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) batch_close_date,
156: msi.CONCATENATED_SEGMENTS item,
157: bl.inventory_item_id item_id,

Line 154: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_cmplt_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_completion_date,

150: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_start_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_start_date,
151: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_start_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_start_date,
152: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.due_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) due_date,
153: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_cmplt_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_completion_date,
154: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_cmplt_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_completion_date,
155: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.batch_close_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) batch_close_date,
156: msi.CONCATENATED_SEGMENTS item,
157: bl.inventory_item_id item_id,
158: bl.material_detail_id,

Line 155: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.batch_close_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) batch_close_date,

151: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_start_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_start_date,
152: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.due_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) due_date,
153: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_cmplt_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_completion_date,
154: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_cmplt_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_completion_date,
155: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.batch_close_date,new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) batch_close_date,
156: msi.CONCATENATED_SEGMENTS item,
157: bl.inventory_item_id item_id,
158: bl.material_detail_id,
159: decode(bh.batch_status, 1, bl.plan_qty, -1, bl.plan_qty, bl.wip_plan_qty) planned_quantity,

Line 209: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.creation_date, new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) creation_date,

205: bh.batch_id,
206: bh.formula_no formula_no,
207: bh.routing_no routing_no,
208: --character date international calendar support project
209: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.creation_date, new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) creation_date,
210: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_start_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_start_date,
211: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_start_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_start_date,
212: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.due_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) due_date,
213: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_cmplt_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_completion_date,

Line 210: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_start_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_start_date,

206: bh.formula_no formula_no,
207: bh.routing_no routing_no,
208: --character date international calendar support project
209: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.creation_date, new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) creation_date,
210: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_start_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_start_date,
211: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_start_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_start_date,
212: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.due_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) due_date,
213: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_cmplt_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_completion_date,
214: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_cmplt_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_completion_date,

Line 211: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_start_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_start_date,

207: bh.routing_no routing_no,
208: --character date international calendar support project
209: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.creation_date, new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) creation_date,
210: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_start_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_start_date,
211: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_start_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_start_date,
212: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.due_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) due_date,
213: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_cmplt_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_completion_date,
214: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_cmplt_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_completion_date,
215: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.batch_close_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) batch_close_date,

Line 212: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.due_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) due_date,

208: --character date international calendar support project
209: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.creation_date, new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) creation_date,
210: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_start_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_start_date,
211: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_start_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_start_date,
212: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.due_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) due_date,
213: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_cmplt_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_completion_date,
214: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_cmplt_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_completion_date,
215: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.batch_close_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) batch_close_date,
216: bl.material_detail_id,

Line 213: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_cmplt_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_completion_date,

209: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.creation_date, new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) creation_date,
210: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_start_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_start_date,
211: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_start_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_start_date,
212: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.due_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) due_date,
213: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_cmplt_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_completion_date,
214: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_cmplt_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_completion_date,
215: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.batch_close_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) batch_close_date,
216: bl.material_detail_id,
217: bl.plan_qty planned_quantity,

Line 214: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_cmplt_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_completion_date,

210: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_start_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_start_date,
211: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_start_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_start_date,
212: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.due_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) due_date,
213: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_cmplt_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_completion_date,
214: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_cmplt_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_completion_date,
215: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.batch_close_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) batch_close_date,
216: bl.material_detail_id,
217: bl.plan_qty planned_quantity,
218: bl.dtl_um item_uom,

Line 215: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.batch_close_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) batch_close_date,

211: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_start_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_start_date,
212: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.due_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) due_date,
213: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_cmplt_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_completion_date,
214: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_cmplt_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_completion_date,
215: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.batch_close_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) batch_close_date,
216: bl.material_detail_id,
217: bl.plan_qty planned_quantity,
218: bl.dtl_um item_uom,
219: bl.actual_qty actual_quantity ,

Line 276: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.creation_date, new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) creation_date,

272: bh.batch_id,
273: bh.formula_no formula_no,
274: bh.routing_no routing_no,
275: --character date international calendar support project
276: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.creation_date, new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) creation_date,
277: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_start_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_start_date,
278: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_start_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_start_date,
279: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.due_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) due_date,
280: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_cmplt_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_completion_date,

Line 277: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_start_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_start_date,

273: bh.formula_no formula_no,
274: bh.routing_no routing_no,
275: --character date international calendar support project
276: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.creation_date, new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) creation_date,
277: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_start_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_start_date,
278: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_start_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_start_date,
279: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.due_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) due_date,
280: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_cmplt_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_completion_date,
281: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_cmplt_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_completion_date,

Line 278: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_start_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_start_date,

274: bh.routing_no routing_no,
275: --character date international calendar support project
276: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.creation_date, new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) creation_date,
277: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_start_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_start_date,
278: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_start_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_start_date,
279: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.due_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) due_date,
280: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_cmplt_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_completion_date,
281: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_cmplt_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_completion_date,
282: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.batch_close_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) batch_close_date,

Line 279: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.due_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) due_date,

275: --character date international calendar support project
276: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.creation_date, new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) creation_date,
277: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_start_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_start_date,
278: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_start_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_start_date,
279: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.due_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) due_date,
280: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_cmplt_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_completion_date,
281: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_cmplt_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_completion_date,
282: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.batch_close_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) batch_close_date,
283: bl.material_detail_id,

Line 280: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_cmplt_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_completion_date,

276: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.creation_date, new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) creation_date,
277: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_start_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_start_date,
278: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_start_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_start_date,
279: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.due_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) due_date,
280: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_cmplt_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_completion_date,
281: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_cmplt_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_completion_date,
282: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.batch_close_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) batch_close_date,
283: bl.material_detail_id,
284: bl.plan_qty planned_quantity,

Line 281: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_cmplt_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_completion_date,

277: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_start_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_start_date,
278: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_start_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_start_date,
279: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.due_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) due_date,
280: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_cmplt_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_completion_date,
281: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_cmplt_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_completion_date,
282: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.batch_close_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) batch_close_date,
283: bl.material_detail_id,
284: bl.plan_qty planned_quantity,
285: bl.dtl_um item_uom,

Line 282: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.batch_close_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) batch_close_date,

278: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_start_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_start_date,
279: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.due_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) due_date,
280: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.plan_cmplt_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) planned_completion_date,
281: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.actual_cmplt_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) actual_completion_date,
282: FND_DATE.DATE_TO_DISPLAYDT(dateval=>bh.batch_close_date,new_client_tz_code=> FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) batch_close_date,
283: bl.material_detail_id,
284: bl.plan_qty planned_quantity,
285: bl.dtl_um item_uom,
286: bl.actual_qty actual_quantity ,

Line 500: FND_DATE.DATE_TO_DISPLAYDT(dateval=>mln.creation_date, new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) creation_date,

496: IF (l_batch_table_type(j).lot_number is not null)
497: THEN
498: --character date international calendar support project
499: SELECT mln.parent_lot_number, mln.grade_code,
500: FND_DATE.DATE_TO_DISPLAYDT(dateval=>mln.creation_date, new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) creation_date,
501: FND_DATE.DATE_TO_DISPLAYDT(dateval=>mln.expiration_date, new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) expiration_date,
502: mms.status_code
503: INTO l_parent_lot_number, l_grade_code, l_lot_creation_date,
504: l_lot_expiration_date, l_status

Line 501: FND_DATE.DATE_TO_DISPLAYDT(dateval=>mln.expiration_date, new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) expiration_date,

497: THEN
498: --character date international calendar support project
499: SELECT mln.parent_lot_number, mln.grade_code,
500: FND_DATE.DATE_TO_DISPLAYDT(dateval=>mln.creation_date, new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) creation_date,
501: FND_DATE.DATE_TO_DISPLAYDT(dateval=>mln.expiration_date, new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) expiration_date,
502: mms.status_code
503: INTO l_parent_lot_number, l_grade_code, l_lot_creation_date,
504: l_lot_expiration_date, l_status
505: FROM mtl_lot_numbers mln, MTL_MATERIAL_STATUSES mms

Line 566: FND_DATE.DATE_TO_DISPLAYDT(dateval=>mln.creation_date, new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) creation_date,

562: THEN
563: --character date international calendar support project
564: begin
565: SELECT mln.parent_lot_number, mln.grade_code,
566: FND_DATE.DATE_TO_DISPLAYDT(dateval=>mln.creation_date, new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) creation_date,
567: FND_DATE.DATE_TO_DISPLAYDT(dateval=>mln.expiration_date, new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) expiration_date,
568: mms.status_code
569: INTO l_parent_lot_number, l_grade_code, l_lot_creation_date,
570: l_lot_expiration_date, l_status

Line 567: FND_DATE.DATE_TO_DISPLAYDT(dateval=>mln.expiration_date, new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) expiration_date,

563: --character date international calendar support project
564: begin
565: SELECT mln.parent_lot_number, mln.grade_code,
566: FND_DATE.DATE_TO_DISPLAYDT(dateval=>mln.creation_date, new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) creation_date,
567: FND_DATE.DATE_TO_DISPLAYDT(dateval=>mln.expiration_date, new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) expiration_date,
568: mms.status_code
569: INTO l_parent_lot_number, l_grade_code, l_lot_creation_date,
570: l_lot_expiration_date, l_status
571: FROM mtl_lot_numbers mln, MTL_MATERIAL_STATUSES mms