[Home] [Help]
View: 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
Name |
CONTRACT |
AUTHORING_ORG_ID |
BILLING_RULE_HEADER_ID |
RULE_NAME |
CONTRACT_NUMBER |
ID |