VIEW: APPS.MTL_AGREEMENT_DETAILS_V

Source

View Text - Preformatted

SELECT contract_header.contract_number , mcp.client_code , mcp.client_id , mcp.client_number , msib.concatenated_segments segment1 , msib.primary_uom_code , contract_lines.start_date Service_line_start_date , contract_lines.end_date Service_line_end_date , msib.inventory_item_id , oki.cle_id , oki.dnz_chr_id , contract_lines.cust_acct_id , contract_header.id FROM mtl_system_items_b_kfv msib , okc_k_items oki , okc_k_headers_all_b contract_header , okc_k_lines_b contract_lines , mtl_client_parameters mcp WHERE msib.inventory_item_id = To_number(oki.OBJECT1_ID1) AND msib.organization_id = To_number(oki.OBJECT1_ID2) AND oki.dnz_chr_id = contract_header.id AND oki.JTOT_OBJECT1_CODE = 'OKX_USAGE' AND contract_lines.chr_id = oki.dnz_chr_id AND contract_lines.id = oki.cle_id AND mcp.client_id = contract_lines.cust_acct_id

View Text - HTML Formatted

SELECT CONTRACT_HEADER.CONTRACT_NUMBER
, MCP.CLIENT_CODE
, MCP.CLIENT_ID
, MCP.CLIENT_NUMBER
, MSIB.CONCATENATED_SEGMENTS SEGMENT1
, MSIB.PRIMARY_UOM_CODE
, CONTRACT_LINES.START_DATE SERVICE_LINE_START_DATE
, CONTRACT_LINES.END_DATE SERVICE_LINE_END_DATE
, MSIB.INVENTORY_ITEM_ID
, OKI.CLE_ID
, OKI.DNZ_CHR_ID
, CONTRACT_LINES.CUST_ACCT_ID
, CONTRACT_HEADER.ID
FROM MTL_SYSTEM_ITEMS_B_KFV MSIB
, OKC_K_ITEMS OKI
, OKC_K_HEADERS_ALL_B CONTRACT_HEADER
, OKC_K_LINES_B CONTRACT_LINES
, MTL_CLIENT_PARAMETERS MCP
WHERE MSIB.INVENTORY_ITEM_ID = TO_NUMBER(OKI.OBJECT1_ID1)
AND MSIB.ORGANIZATION_ID = TO_NUMBER(OKI.OBJECT1_ID2)
AND OKI.DNZ_CHR_ID = CONTRACT_HEADER.ID
AND OKI.JTOT_OBJECT1_CODE = 'OKX_USAGE'
AND CONTRACT_LINES.CHR_ID = OKI.DNZ_CHR_ID
AND CONTRACT_LINES.ID = OKI.CLE_ID
AND MCP.CLIENT_ID = CONTRACT_LINES.CUST_ACCT_ID