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.ASL_INV_ITEM_SUMM_PUB dependencies on QP_LIST_HEADERS_B

Line 757: FROM QP_LIST_HEADERS_B QH

753:
754:
755: CURSOR list_hdr_id(p_currency_code VARCHAR2) IS
756: SELECT QH.LIST_HEADER_ID
757: FROM QP_LIST_HEADERS_B QH
758: WHERE QH.LIST_TYPE_CODE = 'PRL'
759: AND nvl(QH.start_date_active, SYSDATE) <= SYSDATE
760: AND nvl(QH.end_date_active, SYSDATE) >= SYSDATE
761: AND QH.mobile_download = 'Y'

Line 828: QP_LIST_HEADERS_B QH

824: l_currency_code
825: FROM QP_PRICING_ATTRIBUTES QPA,
826: QP_LIST_LINES QL,
827: ASL_INVENTORY_ITEM_DENORM ITEM ,
828: QP_LIST_HEADERS_B QH
829: WHERE QPA.LIST_HEADER_ID = QH.LIST_HEADER_ID
830: AND QH.LIST_TYPE_CODE = 'PRL'
831: AND nvl(QH.start_date_active, SYSDATE) <= SYSDATE
832: AND nvl(QH.end_date_active, SYSDATE) >= SYSDATE

Line 970: FROM QP_LIST_HEADERS_B QH

966:
967:
968: CURSOR list_hdr_id(p_currency_code VARCHAR2) IS
969: SELECT QH.LIST_HEADER_ID
970: FROM QP_LIST_HEADERS_B QH
971: WHERE QH.LIST_TYPE_CODE = 'PRL'
972: AND nvl(QH.start_date_active, SYSDATE) <= SYSDATE
973: AND nvl(QH.end_date_active, SYSDATE) >= SYSDATE
974: AND QH.mobile_download = 'Y'