View: EAM_WORK_ORDER_BILL_DETAILS_V

Product:	EAM - Enterprise Asset Management
Description:	An internal view used to simplify forms coding.
Implementation/DBA Data:	APPS.EAM_WORK_ORDER_BILL_DETAILS_V

View Text

SELECT EWOB.ORGANIZATION_ID
, EWOB.CUSTOMER_ID
, HP.PARTY_NAME AS CUSTOMER_NAME
, EWOB.BILL_TO_ADDRESS_ID
, EWOB.WIP_ENTITY_ID
, WE.WIP_ENTITY_NAME
, EWOB.OPERATION_SEQ_NUM
, EWOB.LAST_UPDATE_DATE
, EWOB.LAST_UPDATED_BY
, EWOB.CREATION_DATE
, EWOB.CREATED_BY
, EWOB.LAST_UPDATE_LOGIN
, EWOB.INVENTORY_ITEM_ID
, EWOB.RESOURCE_ID
, EWOB.BILLED_INVENTORY_ITEM_ID
, EWOB.BILLED_UOM_CODE
, EWOB.BILLED_QUANTITY
, EWOB.BILLING_BASIS
, EWOB.PRICE_LIST_HEADER_ID
, EWOB.COST_TYPE_ID
, EWOB.COST_OR_LISTPRICE
, EWOB.COSTPLUS_PERCENTAGE
, EWOB.BILLED_AMOUNT
, EWOB.INVOICE_TRX_NUMBER REF_INVOICE_TRX_NUMBER
, EWOB.INVOICE_LINE_NUMBER REF_INVOICE_LINE_NUMBER
, EWOB.CURRENCY_CODE
, EWOB.CONVERSION_RATE
, EWOB.CONVERSION_TYPE_CODE
, EWOB.CONVERSION_RATE_DATE
, EWOB.PROJECT_ID
, PPA.NAME PROJECT_NAME
, EWOB.TASK_ID
, PT.TASK_NAME
, EWOB.WORK_REQUEST_ID
, EWOB.PA_EVENT_ID
, EWOB.CREATION_DATE BILLED_DATE
, RCTA.TRX_DATE INVOICE_DATE
, RCTA.TRX_NUMBER
, RCTLA.LINE_NUMBER
FROM EAM_WORK_ORDER_BILLS EWOB
, WIP_ENTITIES WE
, PA_PROJECTS_ALL PPA
, PA_TASKS PT
, HZ_PARTIES HP
, HZ_CUST_ACCOUNTS HCA
, RA_CUSTOMER_TRX_ALL RCTA
, RA_CUSTOMER_TRX_LINES_ALL RCTLA
WHERE WE.WIP_ENTITY_ID = EWOB.WIP_ENTITY_ID
AND WE.ORGANIZATION_ID = EWOB.ORGANIZATION_ID
AND EWOB.PROJECT_ID = PPA.PROJECT_ID(+)
AND EWOB.PROJECT_ID = PT.PROJECT_ID(+)
AND EWOB.TASK_ID = PT.TASK_ID(+)
AND EWOB.CUSTOMER_ID = HCA.CUST_ACCOUNT_ID(+)
AND HCA.PARTY_ID = HP.PARTY_ID
AND TO_CHAR(EWOB.INVOICE_TRX_NUMBER) = RCTLA.INTERFACE_LINE_ATTRIBUTE3(+)
AND RCTLA.INTERFACE_LINE_ATTRIBUTE4(+) = EWOB.INVOICE_LINE_NUMBER
AND RCTLA.CUSTOMER_TRX_ID = RCTA.CUSTOMER_TRX_ID(+)
AND RCTLA.INTERFACE_LINE_CONTEXT(+) = 'WORK ORDER BILLING'
AND RCTA.INTERFACE_HEADER_CONTEXT(+) = 'WORK ORDER BILLING'

Columns