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_XML_REPORTS dependencies on FND_DATE

Line 9: RETURN FND_DATE.CALENDAR_AWARE_ALT;

5:
6: --#11703502 Character date international calendar support to add calendar_aware in date function arguments created new function.
7: FUNCTION C_CALENDAR_VALUE RETURN NUMBER IS
8: BEGIN
9: RETURN FND_DATE.CALENDAR_AWARE_ALT;
10: END C_CALENDAR_VALUE;
11:
12: PROCEDURE lot_inventory_report (
13: errbuf OUT NOCOPY VARCHAR2

Line 34: , fnd_date.date_to_displayDT(mln.origination_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE ) ORIG_DATE

30: , cursor(select mss.secondary_inventory_name SUBINV
31: ,cursor(select msi.concatenated_segments ITEM_NO
32: , msi.description ITEM_DESC
33: ,cursor(select mln.lot_number LOT
34: , fnd_date.date_to_displayDT(mln.origination_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE ) ORIG_DATE
35: , fnd_date.date_to_displayDT(mln.expiration_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) EXP_DATE
36: , mil.concatenated_segments LOCATOR
37: , sum(ohd.primary_transaction_quantity) QTY
38: , msi.primary_uom_code UOM

Line 35: , fnd_date.date_to_displayDT(mln.expiration_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) EXP_DATE

31: ,cursor(select msi.concatenated_segments ITEM_NO
32: , msi.description ITEM_DESC
33: ,cursor(select mln.lot_number LOT
34: , fnd_date.date_to_displayDT(mln.origination_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE ) ORIG_DATE
35: , fnd_date.date_to_displayDT(mln.expiration_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) EXP_DATE
36: , mil.concatenated_segments LOCATOR
37: , sum(ohd.primary_transaction_quantity) QTY
38: , msi.primary_uom_code UOM
39: , sum(nvl(ohd.secondary_transaction_quantity,0)) SEC_QTY

Line 71: , fnd_date.date_to_displayDT(mln.origination_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) ORIG_DATE

67:
68: -- For the bug 10236246 query the on hand material status tracked org.
69: union
70: select mln.lot_number LOT
71: , fnd_date.date_to_displayDT(mln.origination_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) ORIG_DATE
72: , fnd_date.date_to_displayDT(mln.expiration_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) EXP_DATE
73: , mil.concatenated_segments LOCATOR
74: , sum(ohd.primary_transaction_quantity) QTY
75: , msi.primary_uom_code UOM

Line 72: , fnd_date.date_to_displayDT(mln.expiration_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) EXP_DATE

68: -- For the bug 10236246 query the on hand material status tracked org.
69: union
70: select mln.lot_number LOT
71: , fnd_date.date_to_displayDT(mln.origination_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) ORIG_DATE
72: , fnd_date.date_to_displayDT(mln.expiration_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) EXP_DATE
73: , mil.concatenated_segments LOCATOR
74: , sum(ohd.primary_transaction_quantity) QTY
75: , msi.primary_uom_code UOM
76: , sum(nvl(ohd.secondary_transaction_quantity,0)) SEC_QTY

Line 200: , fnd_date.date_to_displayDT(mln.expiration_action_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) expiration_action_date

196: , cursor(select mln.lot_number
197: , mln.description
198: , mln.grade_code
199: , mln.expiration_action_code
200: , fnd_date.date_to_displayDT(mln.expiration_action_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) expiration_action_date
201: , mln.origination_type
202: , mfgl.meaning lot_origination
203: , fnd_date.date_to_displayDT(mln.origination_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) origination_date
204: , fnd_date.date_to_displayDT(mln.expiration_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) expiration_date

Line 203: , fnd_date.date_to_displayDT(mln.origination_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) origination_date

199: , mln.expiration_action_code
200: , fnd_date.date_to_displayDT(mln.expiration_action_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) expiration_action_date
201: , mln.origination_type
202: , mfgl.meaning lot_origination
203: , fnd_date.date_to_displayDT(mln.origination_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) origination_date
204: , fnd_date.date_to_displayDT(mln.expiration_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) expiration_date
205: , fnd_date.date_to_displayDT(mln.retest_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) retest_date
206: , fnd_date.date_to_displayDT(mln.maturity_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) maturity_date
207: , fnd_date.date_to_displayDT(mln.hold_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) hold_date

Line 204: , fnd_date.date_to_displayDT(mln.expiration_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) expiration_date

200: , fnd_date.date_to_displayDT(mln.expiration_action_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) expiration_action_date
201: , mln.origination_type
202: , mfgl.meaning lot_origination
203: , fnd_date.date_to_displayDT(mln.origination_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) origination_date
204: , fnd_date.date_to_displayDT(mln.expiration_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) expiration_date
205: , fnd_date.date_to_displayDT(mln.retest_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) retest_date
206: , fnd_date.date_to_displayDT(mln.maturity_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) maturity_date
207: , fnd_date.date_to_displayDT(mln.hold_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) hold_date
208: , mln.parent_lot_number

Line 205: , fnd_date.date_to_displayDT(mln.retest_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) retest_date

201: , mln.origination_type
202: , mfgl.meaning lot_origination
203: , fnd_date.date_to_displayDT(mln.origination_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) origination_date
204: , fnd_date.date_to_displayDT(mln.expiration_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) expiration_date
205: , fnd_date.date_to_displayDT(mln.retest_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) retest_date
206: , fnd_date.date_to_displayDT(mln.maturity_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) maturity_date
207: , fnd_date.date_to_displayDT(mln.hold_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) hold_date
208: , mln.parent_lot_number
209: , mln.vendor_name

Line 206: , fnd_date.date_to_displayDT(mln.maturity_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) maturity_date

202: , mfgl.meaning lot_origination
203: , fnd_date.date_to_displayDT(mln.origination_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) origination_date
204: , fnd_date.date_to_displayDT(mln.expiration_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) expiration_date
205: , fnd_date.date_to_displayDT(mln.retest_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) retest_date
206: , fnd_date.date_to_displayDT(mln.maturity_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) maturity_date
207: , fnd_date.date_to_displayDT(mln.hold_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) hold_date
208: , mln.parent_lot_number
209: , mln.vendor_name
210: , mln.supplier_lot_number

Line 207: , fnd_date.date_to_displayDT(mln.hold_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) hold_date

203: , fnd_date.date_to_displayDT(mln.origination_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) origination_date
204: , fnd_date.date_to_displayDT(mln.expiration_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) expiration_date
205: , fnd_date.date_to_displayDT(mln.retest_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) retest_date
206: , fnd_date.date_to_displayDT(mln.maturity_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) maturity_date
207: , fnd_date.date_to_displayDT(mln.hold_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) hold_date
208: , mln.parent_lot_number
209: , mln.vendor_name
210: , mln.supplier_lot_number
211: FROM mtl_lot_numbers mln

Line 410: p_from_dt DATE := fnd_date.canonical_to_date(p_from_date);

406:
407: qryctx DBMS_XMLGEN.ctxhandle;
408: v_result CLOB;
409: QUERY VARCHAR2 (32000);
410: p_from_dt DATE := fnd_date.canonical_to_date(p_from_date);
411: p_to_dt DATE := fnd_date.canonical_to_date(p_to_date);
412: BEGIN
413: /* Jalaj Srivastava Bug 4998256
414: get the meaning of update_method and not the code */

Line 411: p_to_dt DATE := fnd_date.canonical_to_date(p_to_date);

407: qryctx DBMS_XMLGEN.ctxhandle;
408: v_result CLOB;
409: QUERY VARCHAR2 (32000);
410: p_from_dt DATE := fnd_date.canonical_to_date(p_from_date);
411: p_to_dt DATE := fnd_date.canonical_to_date(p_to_date);
412: BEGIN
413: /* Jalaj Srivastava Bug 4998256
414: get the meaning of update_method and not the code */
415: --#11703502 Character date international calendar support Added calendar_aware in date function arguments

Line 428: , fnd_date.date_to_displayDT(mlgh.grade_update_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) upd_date

424: , msi.default_grade def_grade
425: , mlgh.old_grade_code old_grade
426: , mlgh.new_grade_code new_grade
427: , DECODE (mlgh.from_mobile_apps_flag, ''Y'', ''Mobile'', ''N'', ''Desktop'') updated_from
428: , fnd_date.date_to_displayDT(mlgh.grade_update_date,calendar_aware=>inv_xml_reports.C_CALENDAR_VALUE) upd_date
429: , fnd.user_name user_name
430: , ml.meaning upd_method
431: , mlgh.primary_quantity pri_qty
432: , mlgh.secondary_quantity sec_qty