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 24: , fnd_date.date_to_displayDT(mln.origination_date) ORIG_DATE

20: , cursor(select mss.secondary_inventory_name SUBINV
21: ,cursor(select msi.concatenated_segments ITEM_NO
22: , msi.description ITEM_DESC
23: ,cursor(select mln.lot_number LOT
24: , fnd_date.date_to_displayDT(mln.origination_date) ORIG_DATE
25: , fnd_date.date_to_displayDT(mln.expiration_date) EXP_DATE
26: , mil.concatenated_segments LOCATOR
27: , sum(ohd.primary_transaction_quantity) QTY
28: , msi.primary_uom_code UOM

Line 25: , fnd_date.date_to_displayDT(mln.expiration_date) EXP_DATE

21: ,cursor(select msi.concatenated_segments ITEM_NO
22: , msi.description ITEM_DESC
23: ,cursor(select mln.lot_number LOT
24: , fnd_date.date_to_displayDT(mln.origination_date) ORIG_DATE
25: , fnd_date.date_to_displayDT(mln.expiration_date) EXP_DATE
26: , mil.concatenated_segments LOCATOR
27: , sum(ohd.primary_transaction_quantity) QTY
28: , msi.primary_uom_code UOM
29: , sum(nvl(ohd.secondary_transaction_quantity,0)) SEC_QTY

Line 151: , fnd_date.date_to_displayDT(mln.expiration_action_date) expiration_action_date

147: , cursor(select mln.lot_number
148: , mln.description
149: , mln.grade_code
150: , mln.expiration_action_code
151: , fnd_date.date_to_displayDT(mln.expiration_action_date) expiration_action_date
152: , mln.origination_type
153: , mfgl.meaning lot_origination
154: , fnd_date.date_to_displayDT(mln.origination_date) origination_date
155: , fnd_date.date_to_displayDT(mln.expiration_date) expiration_date

Line 154: , fnd_date.date_to_displayDT(mln.origination_date) origination_date

150: , mln.expiration_action_code
151: , fnd_date.date_to_displayDT(mln.expiration_action_date) expiration_action_date
152: , mln.origination_type
153: , mfgl.meaning lot_origination
154: , fnd_date.date_to_displayDT(mln.origination_date) origination_date
155: , fnd_date.date_to_displayDT(mln.expiration_date) expiration_date
156: , fnd_date.date_to_displayDT(mln.retest_date) retest_date
157: , fnd_date.date_to_displayDT(mln.maturity_date) maturity_date
158: , fnd_date.date_to_displayDT(mln.hold_date) hold_date

Line 155: , fnd_date.date_to_displayDT(mln.expiration_date) expiration_date

151: , fnd_date.date_to_displayDT(mln.expiration_action_date) expiration_action_date
152: , mln.origination_type
153: , mfgl.meaning lot_origination
154: , fnd_date.date_to_displayDT(mln.origination_date) origination_date
155: , fnd_date.date_to_displayDT(mln.expiration_date) expiration_date
156: , fnd_date.date_to_displayDT(mln.retest_date) retest_date
157: , fnd_date.date_to_displayDT(mln.maturity_date) maturity_date
158: , fnd_date.date_to_displayDT(mln.hold_date) hold_date
159: , mln.parent_lot_number

Line 156: , fnd_date.date_to_displayDT(mln.retest_date) retest_date

152: , mln.origination_type
153: , mfgl.meaning lot_origination
154: , fnd_date.date_to_displayDT(mln.origination_date) origination_date
155: , fnd_date.date_to_displayDT(mln.expiration_date) expiration_date
156: , fnd_date.date_to_displayDT(mln.retest_date) retest_date
157: , fnd_date.date_to_displayDT(mln.maturity_date) maturity_date
158: , fnd_date.date_to_displayDT(mln.hold_date) hold_date
159: , mln.parent_lot_number
160: , mln.vendor_name

Line 157: , fnd_date.date_to_displayDT(mln.maturity_date) maturity_date

153: , mfgl.meaning lot_origination
154: , fnd_date.date_to_displayDT(mln.origination_date) origination_date
155: , fnd_date.date_to_displayDT(mln.expiration_date) expiration_date
156: , fnd_date.date_to_displayDT(mln.retest_date) retest_date
157: , fnd_date.date_to_displayDT(mln.maturity_date) maturity_date
158: , fnd_date.date_to_displayDT(mln.hold_date) hold_date
159: , mln.parent_lot_number
160: , mln.vendor_name
161: , mln.supplier_lot_number

Line 158: , fnd_date.date_to_displayDT(mln.hold_date) hold_date

154: , fnd_date.date_to_displayDT(mln.origination_date) origination_date
155: , fnd_date.date_to_displayDT(mln.expiration_date) expiration_date
156: , fnd_date.date_to_displayDT(mln.retest_date) retest_date
157: , fnd_date.date_to_displayDT(mln.maturity_date) maturity_date
158: , fnd_date.date_to_displayDT(mln.hold_date) hold_date
159: , mln.parent_lot_number
160: , mln.vendor_name
161: , mln.supplier_lot_number
162: FROM mtl_lot_numbers mln

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

353:
354: qryctx DBMS_XMLGEN.ctxhandle;
355: v_result CLOB;
356: QUERY VARCHAR2 (32000);
357: p_from_dt DATE := fnd_date.canonical_to_date(p_from_date);
358: p_to_dt DATE := fnd_date.canonical_to_date(p_to_date);
359: BEGIN
360: /* Jalaj Srivastava Bug 4998256
361: get the meaning of update_method and not the code */

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

354: qryctx DBMS_XMLGEN.ctxhandle;
355: v_result CLOB;
356: QUERY VARCHAR2 (32000);
357: p_from_dt DATE := fnd_date.canonical_to_date(p_from_date);
358: p_to_dt DATE := fnd_date.canonical_to_date(p_to_date);
359: BEGIN
360: /* Jalaj Srivastava Bug 4998256
361: get the meaning of update_method and not the code */
362: QUERY :=

Line 374: , fnd_date.date_to_displayDT(mlgh.grade_update_date) upd_date

370: , msi.default_grade def_grade
371: , mlgh.old_grade_code old_grade
372: , mlgh.new_grade_code new_grade
373: , DECODE (mlgh.from_mobile_apps_flag, ''Y'', ''Mobile'', ''N'', ''Desktop'') updated_from
374: , fnd_date.date_to_displayDT(mlgh.grade_update_date) upd_date
375: , fnd.user_name user_name
376: , ml.meaning upd_method
377: , mlgh.primary_quantity pri_qty
378: , mlgh.secondary_quantity sec_qty