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 INV_XML_REPORTS

Line 1: PACKAGE BODY inv_xml_reports AS

1: PACKAGE BODY inv_xml_reports AS
2: /* $Header: INVXREPB.pls 120.12 2011/02/04 10:19:18 ksivasa ship $ */
3: -- Bug 8425698: store XML encoding specification
4: g_xml_encoding VARCHAR2(100) := '-9999';
5:

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 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

Line 571: END inv_xml_reports;

567: WHEN OTHERS THEN
568: fnd_file.put_line (fnd_file.LOG, 'Exception in procedure XML_TRANSFER ' || SQLCODE || ' ' || SQLERRM);
569: END xml_transfer;
570:
571: END inv_xml_reports;