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.MTL_CROSS_REFERENCES_PVT dependencies on DUAL

Line 428: FROM dual

424: ELSE /*bug 14138918 start */
425: BEGIN
426:
427: SELECT 'x' INTO l_uom_code_valid
428: FROM dual
429: WHERE
430: l_Xref_Rec.Uom_Code IN (
431: select Uom_code
432: from mtl_uom_conversions_view

Line 482: FROM dual

478: RAISE VALIDATION_ERROR;
479: ELSE /*bug 14138918 start */
480: BEGIN
481: SELECT 'x' INTO l_rev_id_invalid
482: FROM dual
483: WHERE
484: l_Xref_Rec.Revision_Id IN (
485: select item_rev.revision_id
486: from mtl_item_revisions_vl item_rev

Line 616: FROM dual;

612: l_XRef_Rec.Program_Update_Date,l_XRef_Rec.Attribute1,l_XRef_Rec.Attribute2,l_XRef_Rec.Attribute3,l_XRef_Rec.Attribute4,
613: l_XRef_Rec.Attribute5,l_XRef_Rec.Attribute6,l_XRef_Rec.Attribute7,l_XRef_Rec.Attribute8,l_XRef_Rec.Attribute9,l_XRef_Rec.Attribute10,
614: l_XRef_Rec.Attribute11,l_XRef_Rec.Attribute12,l_XRef_Rec.Attribute13,l_XRef_Rec.Attribute14,l_XRef_Rec.Attribute15,
615: l_XRef_Rec.Attribute_category,l_XRef_Rec.Uom_Code,l_XRef_Rec.Revision_Id, l_XRef_Rec.Epc_Gtin_Serial
616: FROM dual;
617:
618: MTL_CROSS_REFERENCES_PKG.INSERT_ROW(
619: P_UOM_CODE => l_XRef_Rec.Uom_Code /*bug 14138918 */
620: ,P_REVISION_ID => l_Xref_Rec.Revision_Id /*bug 14138918 */

Line 780: FROM dual;

776: l_XRef_Rec.Attribute5,l_XRef_Rec.Attribute6,l_XRef_Rec.Attribute7,l_XRef_Rec.Attribute8,l_XRef_Rec.Attribute9,l_XRef_Rec.Attribute10,
777: l_XRef_Rec.Attribute11,l_XRef_Rec.Attribute12,l_XRef_Rec.Attribute13,l_XRef_Rec.Attribute14,l_XRef_Rec.Attribute15,
778: l_XRef_Rec.Attribute_category,l_XRef_Rec.Uom_Code,l_XRef_Rec.Revision_Id,l_XRef_Rec.Epc_Gtin_Serial
779:
780: FROM dual;
781:
782: -- organization validation -- both org_indp_flag and org_id NOT NULL
783: IF l_XRef_Rec.Organization_Id IS NOT NULL THEN
784:

Line 866: FROM dual

862: RAISE VALIDATION_ERROR;
863: ELSE /*bug 14138918 start */
864: BEGIN
865: SELECT 'x' INTO l_uom_code_valid
866: FROM dual
867: WHERE
868: l_Xref_Rec.Uom_Code IN (
869: select Uom_code
870: from mtl_uom_conversions_view

Line 919: FROM dual

915: RAISE VALIDATION_ERROR;
916: ELSE /*bug 14138918 start */
917: BEGIN
918: SELECT 'x' INTO l_rev_id_invalid
919: FROM dual
920: WHERE
921: l_Xref_Rec.Revision_Id IN (
922: select item_rev.revision_id
923: from mtl_item_revisions_vl item_rev