SELECT jtfrs.GROUP_ID , jtfrs.PARENT_GROUP_ID , jtfrs.DENORM_LEVEL , OCR.CHR_ID , OCR.COMPLETE_K_NUMBER , OCR.CONTRACT_NUMBER , OCR.CONTRACT_NUMBER_MODIFIER FROM OKI_SRM_006_V OCR , JTF_RS_GROUPS_DENORM jtfrs WHERE jtfrs.GROUP_ID = OCR.RESOURCE_GROUP_ID AND jtfrs.LATEST_RELATIONSHIP_FLAG = 'Y'
SELECT JTFRS.GROUP_ID
, JTFRS.PARENT_GROUP_ID
, JTFRS.DENORM_LEVEL
, OCR.CHR_ID
, OCR.COMPLETE_K_NUMBER
, OCR.CONTRACT_NUMBER
, OCR.CONTRACT_NUMBER_MODIFIER
FROM OKI_SRM_006_V OCR
, JTF_RS_GROUPS_DENORM JTFRS
WHERE JTFRS.GROUP_ID = OCR.RESOURCE_GROUP_ID
AND JTFRS.LATEST_RELATIONSHIP_FLAG = 'Y'
|
|
|