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.OE_ERROR_WF dependencies on OE_GLOBALS

Line 1830: AND IAS.ITEM_TYPE = OE_GLOBALS.G_WFI_LIN

1826: WF_ACTIVITIES WA
1827: WHERE IAS.ITEM_TYPE = I.ITEM_TYPE
1828: AND IAS.ITEM_KEY = I.ITEM_KEY
1829: AND IAS.PROCESS_ACTIVITY = PA.INSTANCE_ID
1830: AND IAS.ITEM_TYPE = OE_GLOBALS.G_WFI_LIN
1831: AND I.PARENT_ITEM_KEY = p_item_key
1832: AND I.PARENT_ITEM_TYPE = OE_GLOBALS.G_WFI_HDR
1833: AND PA.PROCESS_ITEM_TYPE = OE_GLOBALS.G_WFI_LIN
1834: AND IAS.ACTIVITY_STATUS = l_error_status

Line 1832: AND I.PARENT_ITEM_TYPE = OE_GLOBALS.G_WFI_HDR

1828: AND IAS.ITEM_KEY = I.ITEM_KEY
1829: AND IAS.PROCESS_ACTIVITY = PA.INSTANCE_ID
1830: AND IAS.ITEM_TYPE = OE_GLOBALS.G_WFI_LIN
1831: AND I.PARENT_ITEM_KEY = p_item_key
1832: AND I.PARENT_ITEM_TYPE = OE_GLOBALS.G_WFI_HDR
1833: AND PA.PROCESS_ITEM_TYPE = OE_GLOBALS.G_WFI_LIN
1834: AND IAS.ACTIVITY_STATUS = l_error_status
1835: AND I.END_DATE IS NULL
1836: AND WAT.ITEM_TYPE = IAS.ITEM_TYPE

Line 1833: AND PA.PROCESS_ITEM_TYPE = OE_GLOBALS.G_WFI_LIN

1829: AND IAS.PROCESS_ACTIVITY = PA.INSTANCE_ID
1830: AND IAS.ITEM_TYPE = OE_GLOBALS.G_WFI_LIN
1831: AND I.PARENT_ITEM_KEY = p_item_key
1832: AND I.PARENT_ITEM_TYPE = OE_GLOBALS.G_WFI_HDR
1833: AND PA.PROCESS_ITEM_TYPE = OE_GLOBALS.G_WFI_LIN
1834: AND IAS.ACTIVITY_STATUS = l_error_status
1835: AND I.END_DATE IS NULL
1836: AND WAT.ITEM_TYPE = IAS.ITEM_TYPE
1837: AND WAT.ITEM_KEY = IAS.ITEM_KEY

Line 1856: AND IAS.ITEM_TYPE = OE_GLOBALS.G_WFI_HDR

1852: WF_ACTIVITIES WA
1853: WHERE IAS.ITEM_TYPE = I.ITEM_TYPE
1854: AND IAS.ITEM_KEY = I.ITEM_KEY
1855: AND IAS.PROCESS_ACTIVITY = PA.INSTANCE_ID
1856: AND IAS.ITEM_TYPE = OE_GLOBALS.G_WFI_HDR
1857: AND IAS.ITEM_KEY = p_item_key
1858: AND PA.PROCESS_ITEM_TYPE = OE_GLOBALS.G_WFI_HDR
1859: AND IAS.ACTIVITY_STATUS = l_error_status
1860: AND I.END_DATE IS NULL

Line 1858: AND PA.PROCESS_ITEM_TYPE = OE_GLOBALS.G_WFI_HDR

1854: AND IAS.ITEM_KEY = I.ITEM_KEY
1855: AND IAS.PROCESS_ACTIVITY = PA.INSTANCE_ID
1856: AND IAS.ITEM_TYPE = OE_GLOBALS.G_WFI_HDR
1857: AND IAS.ITEM_KEY = p_item_key
1858: AND PA.PROCESS_ITEM_TYPE = OE_GLOBALS.G_WFI_HDR
1859: AND IAS.ACTIVITY_STATUS = l_error_status
1860: AND I.END_DATE IS NULL
1861: AND WAT.ITEM_TYPE = IAS.ITEM_TYPE
1862: AND WAT.ITEM_KEY = IAS.ITEM_KEY

Line 2550: WHERE name = OE_GLOBALS.G_WFI_LIN;

2546: IF p_item_key IS NOT NULL OR p_item_type = 'OEOL' THEN
2547: SELECT display_name
2548: INTO l_item_type_display_name2
2549: FROM wf_item_types_vl
2550: WHERE name = OE_GLOBALS.G_WFI_LIN;
2551: END IF;
2552:
2553: IF l_debug_level > 0 THEN
2554: oe_debug_pub.add('Item Type Display Name: ' || l_item_type_display_name);