DBA Data[Home] [Help]

APPS.OKE_FLOWDOWN_UTILS dependencies on WSH_DELIVERY_DETAILS

Line 60: FROM wsh_delivery_details W , oke_k_deliverables_b D

56: AND L.requisition_line_id = D.requisition_line_id;
57:
58: CURSOR C_Shipping ( C_Delivery_detail_ID NUMBER ) IS
59: SELECT d.k_header_id ,D.k_line_id , d.project_id , d.task_id
60: FROM wsh_delivery_details W , oke_k_deliverables_b D
61: WHERE W.delivery_detail_id = C_Delivery_detail_ID
62: AND W.source_code ='OKE'
63: AND D.deliverable_id = W.source_line_id;
64:

Line 169: ELSIF ( X_Object_Name = 'WSH_DELIVERY_DETAILS' ) THEN

165: OPEN C_Req_Dist ( X_PK1 );
166: FETCH C_Req_Dist INTO L_K_Hdr_ID , L_K_Line_ID , L_Proj_ID , L_Task_ID ;
167: CLOSE C_Req_Dist;
168:
169: ELSIF ( X_Object_Name = 'WSH_DELIVERY_DETAILS' ) THEN
170:
171: OPEN C_Shipping ( X_PK1 );
172: FETCH C_Shipping INTO L_K_Hdr_ID , L_K_Line_ID , L_Proj_ID , L_Task_ID ;
173: CLOSE C_Shipping;