View: INV_3PL_CONTRACTS_V

Product:	INV - Inventory
Description:
Implementation/DBA Data:	APPS.INV_3PL_CONTRACTS_V

View Text

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

Columns