VIEW: APPS.OKS_CONTRACT_DTLS_V

Source

View Text - Preformatted

SELECT a.contract_id contract_id ,a.contract_number contract_number ,a.contract_number_modifier contract_number_modifier ,a.start_date start_date ,a.end_date end_date ,a.status status ,a.short_description short_description ,a.party_id party_id ,a.party_number party_number ,a.party_name party_name ,a.header_bto_address header_bto_address ,a.currency currency ,a.org_id org_id ,a.inv_org_id inv_org_id ,a.last_update_date last_update_date ,a.estimated_amount estimated_amount ,b.line_id line_id ,b.line_reference line_reference ,b.service_line_number service_line_number ,b.service_name service_name ,b.service_start_date service_start_date ,b.service_end_date service_end_date ,b.customer_account_name customer_account_name ,b.line_bto_address line_bto_address ,b.line_sto_address line_sto_address ,c.covd_line_id covd_line_id ,c.covd_line_number covd_line_number ,c.covd_line_lse_id covd_line_lse_id ,c.covered_level covered_level ,c.covered_system covered_system ,c.covered_serial_no covered_serial_no ,c.covd_description covd_description ,c.object_id object_id ,c.quantity quantity ,c.qty_uom qty_uom ,c.price price ,d.invoice_number ,d.invoice_date ,d.invoice_line_tax_amount ,d.invoice_line_amount ,d.bill_instance_number ,d.bill_from_date ,d.bill_to_date from oks_header_details_v a ,oks_line_details_v b ,oks_prod_details_v c ,oks_billing_dtls_v d WHERE a.contract_id = b.contract_id AND b.line_id = c.line_id AND c.covd_line_id = d.cle_id(+)

View Text - HTML Formatted

SELECT A.CONTRACT_ID CONTRACT_ID
, A.CONTRACT_NUMBER CONTRACT_NUMBER
, A.CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER_MODIFIER
, A.START_DATE START_DATE
, A.END_DATE END_DATE
, A.STATUS STATUS
, A.SHORT_DESCRIPTION SHORT_DESCRIPTION
, A.PARTY_ID PARTY_ID
, A.PARTY_NUMBER PARTY_NUMBER
, A.PARTY_NAME PARTY_NAME
, A.HEADER_BTO_ADDRESS HEADER_BTO_ADDRESS
, A.CURRENCY CURRENCY
, A.ORG_ID ORG_ID
, A.INV_ORG_ID INV_ORG_ID
, A.LAST_UPDATE_DATE LAST_UPDATE_DATE
, A.ESTIMATED_AMOUNT ESTIMATED_AMOUNT
, B.LINE_ID LINE_ID
, B.LINE_REFERENCE LINE_REFERENCE
, B.SERVICE_LINE_NUMBER SERVICE_LINE_NUMBER
, B.SERVICE_NAME SERVICE_NAME
, B.SERVICE_START_DATE SERVICE_START_DATE
, B.SERVICE_END_DATE SERVICE_END_DATE
, B.CUSTOMER_ACCOUNT_NAME CUSTOMER_ACCOUNT_NAME
, B.LINE_BTO_ADDRESS LINE_BTO_ADDRESS
, B.LINE_STO_ADDRESS LINE_STO_ADDRESS
, C.COVD_LINE_ID COVD_LINE_ID
, C.COVD_LINE_NUMBER COVD_LINE_NUMBER
, C.COVD_LINE_LSE_ID COVD_LINE_LSE_ID
, C.COVERED_LEVEL COVERED_LEVEL
, C.COVERED_SYSTEM COVERED_SYSTEM
, C.COVERED_SERIAL_NO COVERED_SERIAL_NO
, C.COVD_DESCRIPTION COVD_DESCRIPTION
, C.OBJECT_ID OBJECT_ID
, C.QUANTITY QUANTITY
, C.QTY_UOM QTY_UOM
, C.PRICE PRICE
, D.INVOICE_NUMBER
, D.INVOICE_DATE
, D.INVOICE_LINE_TAX_AMOUNT
, D.INVOICE_LINE_AMOUNT
, D.BILL_INSTANCE_NUMBER
, D.BILL_FROM_DATE
, D.BILL_TO_DATE
FROM OKS_HEADER_DETAILS_V A
, OKS_LINE_DETAILS_V B
, OKS_PROD_DETAILS_V C
, OKS_BILLING_DTLS_V D
WHERE A.CONTRACT_ID = B.CONTRACT_ID
AND B.LINE_ID = C.LINE_ID
AND C.COVD_LINE_ID = D.CLE_ID(+)