VIEW: APPS.INV_3PL_CONTRACTS_V

Source

View Text - Preformatted

SELECT contracts.contract_number||'-'||contracts.object_version_number||'-'||parties.party_name||'-'|| hr.name Contract , contracts.authoring_org_id , mbrh.billing_rule_header_id , mbrh.name rule_name , contracts.contract_number , contracts.id FROM mtl_billing_rule_headers_vl mbrh , mtl_service_contracts_v contracts , okc_k_party_roles_b cont_party , hz_parties parties , hr_operating_units hr WHERE contracts.id = mbrh.service_agreement_id AND cont_party.OBJECT1_ID1 = parties.party_id AND cont_party.CHR_ID = contracts.id AND hr.organization_id = contracts.authoring_org_id

View Text - HTML Formatted

SELECT CONTRACTS.CONTRACT_NUMBER||'-'||CONTRACTS.OBJECT_VERSION_NUMBER||'-'||PARTIES.PARTY_NAME||'-'|| HR.NAME CONTRACT
, CONTRACTS.AUTHORING_ORG_ID
, MBRH.BILLING_RULE_HEADER_ID
, MBRH.NAME RULE_NAME
, CONTRACTS.CONTRACT_NUMBER
, CONTRACTS.ID
FROM MTL_BILLING_RULE_HEADERS_VL MBRH
, MTL_SERVICE_CONTRACTS_V CONTRACTS
, OKC_K_PARTY_ROLES_B CONT_PARTY
, HZ_PARTIES PARTIES
, HR_OPERATING_UNITS HR
WHERE CONTRACTS.ID = MBRH.SERVICE_AGREEMENT_ID
AND CONT_PARTY.OBJECT1_ID1 = PARTIES.PARTY_ID
AND CONT_PARTY.CHR_ID = CONTRACTS.ID
AND HR.ORGANIZATION_ID = CONTRACTS.AUTHORING_ORG_ID