VIEW: APPS.EAM_WORK_ORDER_BILL_DETAILS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'