APPS.OKE_CHG_REQ_UTILS dependencies on OKE_CHG_REQUESTS

Line 425: FROM oke_chg_requests CRQ1

421:
422: CURSOR crq IS
423: SELECT CRQ2.Chg_Request_Num
424: , CS.Chg_Status_Type_Code
425: FROM oke_chg_requests CRQ1
426: , oke_chg_requests CRQ2
427: , oke_chg_statuses_b CS
428: WHERE CRQ1.Chg_Request_ID = X_Chg_Request_ID
429: AND CRQ2.K_Header_ID = CRQ1.K_Header_ID

Line 426: , oke_chg_requests CRQ2

422: CURSOR crq IS
423: SELECT CRQ2.Chg_Request_Num
424: , CS.Chg_Status_Type_Code
425: FROM oke_chg_requests CRQ1
426: , oke_chg_requests CRQ2
427: , oke_chg_statuses_b CS
428: WHERE CRQ1.Chg_Request_ID = X_Chg_Request_ID
429: AND CRQ2.K_Header_ID = CRQ1.K_Header_ID
430: AND CRQ2.Chg_Request_ID <> CRQ1.Chg_Request_ID

Line 501: FROM oke_chg_requests CRQ1

497: ) RETURN VARCHAR2 IS
498:
499: CURSOR crq IS
500: SELECT COUNT(CRQ2.Chg_Request_Num) ChgReq_Count
501: FROM oke_chg_requests CRQ1
502: , oke_chg_requests CRQ2
503: , oke_chg_statuses_b CS
504: WHERE CRQ1.Chg_Request_ID = X_Chg_Request_ID
505: AND CRQ2.K_Header_ID = CRQ1.K_Header_ID

Line 502: , oke_chg_requests CRQ2

498:
499: CURSOR crq IS
500: SELECT COUNT(CRQ2.Chg_Request_Num) ChgReq_Count
501: FROM oke_chg_requests CRQ1
502: , oke_chg_requests CRQ2
503: , oke_chg_statuses_b CS
504: WHERE CRQ1.Chg_Request_ID = X_Chg_Request_ID
505: AND CRQ2.K_Header_ID = CRQ1.K_Header_ID
506: AND CRQ2.Chg_Request_ID <> CRQ1.Chg_Request_ID

Line 573: , oke_chg_requests CR

569: SELECT CR.Chg_Request_Num
570: , CS.Chg_Status_Name
571: , H.Version_Reason_Code
572: FROM oke_k_vers_numbers_h H
573: , oke_chg_requests CR
574: , oke_chg_statuses_tl CS
575: , ( SELECT K_Header_ID
576: , Chg_Request_ID
577: , max(Major_Version) Last_Version