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.AHL_DI_SUBSCRIPTION_PUB dependencies on PO_HEADERS_V

Line 94: FROM PO_HEADERS_V

90: -- Get Puchase Order Number from PO_PURCHASE_ORDER_V
91: CURSOR for_ponumber_id(c_ponumber IN VARCHAR2)
92: IS
93: SELECT distinct segment1
94: FROM PO_HEADERS_V
95: WHERE nvl(approved_flag, 'N')='Y' and upper(segment1) = upper(c_ponumber);
96:
97: -- Used to retrieve vendor id from po vendors
98: CURSOR for_vendor_id(c_vendor_name IN VARCHAR2)

Line 729: FROM PO_HEADERS_V

725: -- Get Puchase Order Number from PO_PURCHASE_ORDER_V
726: CURSOR for_ponumber_id(c_ponumber IN VARCHAR2)
727: IS
728: SELECT distinct segment1
729: FROM PO_HEADERS_V
730: WHERE nvl(approved_flag, 'N')='Y' and upper(segment1) = upper(c_ponumber);
731:
732: -- Used to retrieve vendor id from po vendors
733: CURSOR for_vendor_id(c_vendor_name IN VARCHAR2)