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.

VIEW: APPS.OKL_AM_RMK_BILLING_UV

Source

View Text - Preformatted


SELECT ART.ID ART_ID, ART.KLE_ID KLE_ID, ORH.ORDER_NUMBER ORDER_NUMBER, ORH.ORDERED_DATE ORDERED_DATE, ORL.LINE_NUMBER LINE_NUMBER, ORL.INVENTORY_ITEM_ID INVENTORY_ITEM_ID, KLE.NAME ASSET_NUMBER, KLE.ITEM_DESCRIPTION ASSET_DESCRIPTION, KLE.STS_CODE STATUS, KHR.CONTRACT_NUMBER CONTRACT_NUMBER, MSI.CONCATENATED_SEGMENTS ITEM_NUMBER, TLD_NEW.CONSOLIDATED_INVOICE_NUMBER INVOICE_NUMBER, TLD_NEW.AMOUNT INVOICE_AMOUNT, TLD_NEW.DATE_INVOICED INVOICE_DATE, TLD_NEW.DATE_ENTERED BILL_DATE, LOC.ADDRESS1 BILL_TO_ADDRESS1, LOC.ADDRESS2 BILL_TO_ADDRESS2, LOC.ADDRESS3 BILL_TO_ADDRESS3, LOC.ADDRESS4 BILL_TO_ADDRESS4, LOC.CITY BILL_TO_CITY, LOC.POSTAL_CODE BILL_TO_POSTAL_CODE, LOC.STATE BILL_TO_STATE, LOC.PROVINCE BILL_TO_PROVINCE, LOC.COUNTY BILL_TO_COUNTY, LOC.COUNTRY BILL_TO_COUNTRY, SUBSTR(ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS( NULL, LOC.ADDRESS1, LOC.ADDRESS2, LOC.ADDRESS3, LOC.ADDRESS4, LOC.CITY, LOC.COUNTY, LOC.STATE, LOC.PROVINCE, LOC.POSTAL_CODE, NULL, LOC.COUNTRY, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'N', 'N', 80, 1, 1), 1, 80) BILL_TO_FULL_ADDRESS, MSI.CONCATENATED_SEGMENTS ITEM_NAME, MSI.DESCRIPTION ITEM_DESCRIPTION, TLD_NEW.TAX_AMOUNT TAX_AMOUNT, TLD_NEW.LINE_AMOUNT ORIGINAL_INVOICE_AMOUNT, TLD_NEW.TLD_ID LSM_ID, TLD_NEW.AMOUNT TOTAL_INVOICE_AMOUNT, TLD_NEW.STY_ID STY_ID, PLS.AMOUNT_LINE_ITEMS_REMAINING OUTSTANDING_INVOICE_AMOUNT, TLD_NEW.CUSTOMER_TRX_ID TRX_ID, TLD_NEW.CUSTOMER_TRX_LINE_ID TRX_LINE_ID FROM OKL_ASSET_RETURNS_ALL_B ART,OE_ORDER_HEADERS_ALL ORH,OE_ORDER_LINES_ALL ORL,OKL_K_LINES_FULL_V KLE,OKC_K_HEADERS_B KHR,MTL_SYSTEM_ITEMS_B_KFV MSI,OKL_BPD_TLD_AR_LINES_V TLD_NEW,HZ_CUST_ACCT_SITES_ALL CAS,HZ_PARTY_SITES PST,HZ_LOCATIONS LOC,AR_PAYMENT_SCHEDULES_ALL PLS WHERE ORH.HEADER_ID = ORL.HEADER_ID AND ORL.INVENTORY_ITEM_ID = ART.IMR_ID AND ART.KLE_ID = KLE.ID AND KLE.CHR_ID = KHR.ID AND ORL.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND ORL.SHIP_FROM_ORG_ID = MSI.ORGANIZATION_ID AND TLD_NEW.ISL_ID = ORL.LINE_ID AND CAS.CUST_ACCT_SITE_ID = TLD_NEW.IBT_ID AND PST.PARTY_SITE_ID = CAS.PARTY_SITE_ID AND LOC.LOCATION_ID = PST.LOCATION_ID AND PLS.CUSTOMER_TRX_ID = TLD_NEW.CUSTOMER_TRX_ID

View Text - HTML Formatted

SELECT ART.ID ART_ID
, ART.KLE_ID KLE_ID
, ORH.ORDER_NUMBER ORDER_NUMBER
, ORH.ORDERED_DATE ORDERED_DATE
, ORL.LINE_NUMBER LINE_NUMBER
, ORL.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, KLE.NAME ASSET_NUMBER
, KLE.ITEM_DESCRIPTION ASSET_DESCRIPTION
, KLE.STS_CODE STATUS
, KHR.CONTRACT_NUMBER CONTRACT_NUMBER
, MSI.CONCATENATED_SEGMENTS ITEM_NUMBER
, TLD_NEW.CONSOLIDATED_INVOICE_NUMBER INVOICE_NUMBER
, TLD_NEW.AMOUNT INVOICE_AMOUNT
, TLD_NEW.DATE_INVOICED INVOICE_DATE
, TLD_NEW.DATE_ENTERED BILL_DATE
, LOC.ADDRESS1 BILL_TO_ADDRESS1
, LOC.ADDRESS2 BILL_TO_ADDRESS2
, LOC.ADDRESS3 BILL_TO_ADDRESS3
, LOC.ADDRESS4 BILL_TO_ADDRESS4
, LOC.CITY BILL_TO_CITY
, LOC.POSTAL_CODE BILL_TO_POSTAL_CODE
, LOC.STATE BILL_TO_STATE
, LOC.PROVINCE BILL_TO_PROVINCE
, LOC.COUNTY BILL_TO_COUNTY
, LOC.COUNTRY BILL_TO_COUNTRY
, SUBSTR(ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS( NULL
, LOC.ADDRESS1
, LOC.ADDRESS2
, LOC.ADDRESS3
, LOC.ADDRESS4
, LOC.CITY
, LOC.COUNTY
, LOC.STATE
, LOC.PROVINCE
, LOC.POSTAL_CODE
, NULL
, LOC.COUNTRY
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'N'
, 'N'
, 80
, 1
, 1)
, 1
, 80) BILL_TO_FULL_ADDRESS
, MSI.CONCATENATED_SEGMENTS ITEM_NAME
, MSI.DESCRIPTION ITEM_DESCRIPTION
, TLD_NEW.TAX_AMOUNT TAX_AMOUNT
, TLD_NEW.LINE_AMOUNT ORIGINAL_INVOICE_AMOUNT
, TLD_NEW.TLD_ID LSM_ID
, TLD_NEW.AMOUNT TOTAL_INVOICE_AMOUNT
, TLD_NEW.STY_ID STY_ID
, PLS.AMOUNT_LINE_ITEMS_REMAINING OUTSTANDING_INVOICE_AMOUNT
, TLD_NEW.CUSTOMER_TRX_ID TRX_ID
, TLD_NEW.CUSTOMER_TRX_LINE_ID TRX_LINE_ID
FROM OKL_ASSET_RETURNS_ALL_B ART
, OE_ORDER_HEADERS_ALL ORH
, OE_ORDER_LINES_ALL ORL
, OKL_K_LINES_FULL_V KLE
, OKC_K_HEADERS_B KHR
, MTL_SYSTEM_ITEMS_B_KFV MSI
, OKL_BPD_TLD_AR_LINES_V TLD_NEW
, HZ_CUST_ACCT_SITES_ALL CAS
, HZ_PARTY_SITES PST
, HZ_LOCATIONS LOC
, AR_PAYMENT_SCHEDULES_ALL PLS
WHERE ORH.HEADER_ID = ORL.HEADER_ID
AND ORL.INVENTORY_ITEM_ID = ART.IMR_ID
AND ART.KLE_ID = KLE.ID
AND KLE.CHR_ID = KHR.ID
AND ORL.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND ORL.SHIP_FROM_ORG_ID = MSI.ORGANIZATION_ID
AND TLD_NEW.ISL_ID = ORL.LINE_ID
AND CAS.CUST_ACCT_SITE_ID = TLD_NEW.IBT_ID
AND PST.PARTY_SITE_ID = CAS.PARTY_SITE_ID
AND LOC.LOCATION_ID = PST.LOCATION_ID
AND PLS.CUSTOMER_TRX_ID = TLD_NEW.CUSTOMER_TRX_ID