[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Select Name
From okx_locations_v
Where Id1 = P_Id;
Select Name
From okx_vendor_sites_v
Where Id1 = P_Id;
Select Name
From oke_cust_site_uses_v
Where Id1 = P_Id;
select sts_code from okc_k_lines_b
where id = p_id;
select 'x' from okc_assents
where opn_code = 'INITIATE_DELV'
and sts_code = p_sts_code
and scs_code = 'PROJECT'
and allowed_yn = 'Y';
SELECT NAME
FROM HR_ALL_ORGANIZATION_UNITS
WHERE ORGANIZATION_ID = P_ORG_ID;
SELECT D.K_HEADER_ID
, D.DELIVERABLE_ID
, D.DELIVERABLE_NUM
, DECODE(D.ITEM_ID, NULL, NULL, I.NAME) ITEM_NUMBER
, B.CONTRACT_NUMBER
, S.LINE_NUMBER
, W.SOURCE_CODE
, W.USAGE_CODE
, D.DESCRIPTION
, H.K_TYPE
, W.WF_ITEM_TYPE
, W.WF_PROCESS
FROM OKE_K_DELIVERABLES_VL D
, OKE_WORKFLOWS W
, OKC_K_HEADERS_B B
, OKE_K_HEADERS_FULL_V H
, OKC_K_LINES_B S
, OKE_SYSTEM_ITEMS_V I
WHERE D.DELIVERABLE_ID = P_DELIVERABLE_ID
AND W.SOURCE_CODE = 'DTS'
AND W.USAGE_CODE =
DECODE(D.DIRECTION,'IN','INBOUND','OUT','OUTBOUND',NULL)
AND B.ID = D.K_HEADER_ID
AND H.K_HEADER_ID = D.K_HEADER_ID
AND S.ID = D.K_LINE_ID
AND I.ID1 (+)= D.ITEM_ID
AND I.ID2 (+)= D.INVENTORY_ORG_ID
;
select authoring_org_id from oke_k_headers_v where
k_header_id=p_k_header_id;
update oke_k_deliverables_b
set wf_item_key = L_WF_Item_Key
where deliverable_id = P_DELIVERABLE_ID
;
SELECT ID
,SOURCE_CODE
,USAGE_CODE
,TARGET_DATE
,BEFORE_AFTER
,DURATION_DAYS
,RECIPIENT
,ROLE_ID
FROM OKE_NOTIFICATIONS
WHERE SOURCE_CODE = P_SOURCE_CODE
AND USAGE_CODE = P_USAGE_CODE
AND TARGET_DATE = P_TARGET_DATE
AND BEFORE_AFTER = 'BEFORE'
AND (P_DUE_NTF_ID IS NULL OR DURATION_DAYS < P_DURATION_DAYS)
ORDER BY DURATION_DAYS DESC
;
SELECT ID
,SOURCE_CODE
,USAGE_CODE
,TARGET_DATE
,BEFORE_AFTER
,DURATION_DAYS
,RECIPIENT
,ROLE_ID
FROM OKE_NOTIFICATIONS
WHERE SOURCE_CODE = P_SOURCE_CODE
AND USAGE_CODE = P_USAGE_CODE
AND TARGET_DATE = P_TARGET_DATE
AND BEFORE_AFTER = 'AFTER'
AND (P_DUE_NTF_ID IS NULL OR DURATION_DAYS > P_DURATION_DAYS)
ORDER BY DURATION_DAYS ASC
;
PROCEDURE SELECT_DATE
( ItemType IN VARCHAR2
, ItemKey IN VARCHAR2
, ActID IN NUMBER
, FuncMode IN VARCHAR2
, ResultOut OUT NOCOPY VARCHAR2
)
IS
L_Deliverable_ID NUMBER;
SELECT DELIVERY_DATE
,DELIVERABLE_NUM
,DESCRIPTION
INTO L_Delivery_Date
,L_Deliverable_Num
,L_Description
FROM OKE_K_DELIVERABLES_VL
WHERE DELIVERABLE_ID=L_Deliverable_ID;
, 'SELECT_DATE'
, ItemType
, ItemKey
, to_char(ActID)
, FuncMode
, ResultOut );
END SELECT_DATE;
SELECT AVAILABLE_FOR_SHIP_FLAG
,ITEM_ID
,DESCRIPTION
,QUANTITY
,UOM_CODE
,SHIP_TO_LOCATION_ID
,SHIP_FROM_LOCATION_ID
,EXPECTED_SHIPMENT_DATE
INTO L_Available_For_Ship_Flag
,l_item_id
,l_description
,l_quantity
,l_uom_code
,l_ship_to_location_id
,l_ship_from_location_id
,l_expected_date
FROM OKE_K_DELIVERABLES_VL
WHERE DELIVERABLE_ID=L_Deliverable_ID;
SELECT K_HEADER_ID
,K_LINE_ID
INTO L_K_HEADER_ID
,L_K_LINE_ID
FROM OKE_K_DELIVERABLES_VL
WHERE DELIVERABLE_ID = L_Deliverable_ID;
SELECT CREATE_DEMAND
,ITEM_ID
,INVENTORY_ORG_ID
,NDB_SCHEDULE_DESIGNATOR
,QUANTITY
,UOM_CODE
,EXPECTED_SHIPMENT_DATE
INTO L_Create_Demand
,l_item_id
,l_inventory_org_id
,l_ndb_schedule_designator
,l_quantity
,l_uom_code
,l_expected_date
FROM OKE_K_DELIVERABLES_VL
WHERE DELIVERABLE_ID=L_Deliverable_ID;
SELECT K_HEADER_ID
,K_LINE_ID
INTO L_K_HEADER_ID
,L_K_LINE_ID
FROM OKE_K_DELIVERABLES_VL
WHERE DELIVERABLE_ID = L_Deliverable_ID;
SELECT READY_TO_PROCURE
INTO L_Ready_To_Procure
FROM OKE_K_DELIVERABLES_VL
WHERE DELIVERABLE_ID=L_Deliverable_ID;
SELECT K_HEADER_ID
,K_LINE_ID
INTO L_K_HEADER_ID
,L_K_LINE_ID
FROM OKE_K_DELIVERABLES_VL
WHERE DELIVERABLE_ID = L_Deliverable_ID;
Select B.Contract_Number
, B.Currency_Code
, B.Buy_Or_Sell
, H.Country_Of_Origin_Code
, Deliverable_Id
, Deliverable_Num
, D.Inspection_Req_Flag
, D.Item_Id
, Decode(D.Item_Id, Null, Null, I.Name) Item
, Decode(D.Item_Id, Null, Null, I.Description) Item_Description
, D.Inventory_Org_Id
, D.Project_Id
, P.Segment1 Project_Number
, D.Quantity
, D.Expected_Shipment_Date
, D.Ndb_Schedule_Designator
, D.ship_to_location_id
, D.Task_Id
, T.Task_Number
, S.Sts_Code
, D.Unit_Number
, D.Uom_Code
, D.Dependency_Flag
, D.K_Line_Id
, D.Mps_Transaction_Id
, D.Ship_From_Org_Id
, D.Ship_To_Org_Id
, D.Direction
From oke_k_deliverables_b d
, pa_projects_all p
, pa_tasks t
, oke_system_items_v i
, oke_k_headers h
, okc_k_headers_b b
, okc_k_lines_b s
Where D.Deliverable_Id = P_Id
And B.Id = D.K_Header_Id
And H.K_Header_Id = B.Id
And D.Project_Id = P.Project_Id(+)
And D.Task_Id = T.Task_Id(+)
And D.Item_Id = I.Id1(+)
And D.Inventory_Org_Id = I.Id2(+)
And D.K_Line_Id = S.Id
And D.Available_For_Ship_Flag = 'Y';
Select Name
From hr_all_organization_units
Where Organization_Id = P_Id;
Select B.Contract_Number
, B.Currency_Code
, B.Buy_Or_Sell
, H.Country_Of_Origin_Code
, Deliverable_Id
, Deliverable_Num
, D.Inspection_Req_Flag
, I.Description Item_Description
, D.Item_Id
, I.Name Item
, D.Inventory_Org_Id
, D.Project_Id
, P.Segment1 Project_Number
, D.Quantity
, D.Expected_Shipment_Date
, D.Ndb_Schedule_Designator
, D.ship_to_location_id
, D.Task_Id
, T.Task_Number
, S.Sts_Code
, D.Unit_Number
, D.Uom_Code
, D.Dependency_Flag
, D.K_Line_Id
, D.Mps_Transaction_Id
, D.Ship_From_Org_Id
, D.Ship_To_Org_Id
, D.Direction
From oke_k_deliverables_b d
, pa_projects_all p
, pa_tasks t
, oke_system_items_v i
, oke_k_headers h
, okc_k_headers_b b
, okc_k_lines_b s
Where D.Deliverable_Id = P_Id
And B.Id = D.K_Header_Id
And H.K_Header_Id = B.Id
And D.Project_Id = P.Project_Id(+)
And D.Task_Id = T.Task_Id(+)
And D.Item_Id = I.Id1
And D.Inventory_Org_Id = I.Id2
And D.K_Line_Id = S.Id
And D.Create_Demand = 'Y';
Select Name
From hr_all_organization_units
Where Organization_Id = P_Id;
Select B.Contract_Number
, B.Currency_Code
, B.Buy_Or_Sell
, H.Country_Of_Origin_Code
, Deliverable_Id
, Deliverable_Num
, D.Inspection_Req_Flag
, D.Item_Id
, Decode(D.Item_Id, Null, Null, I.Name) Item
, Decode(D.Item_Id, Null, Null, I.Description) Item_Description
, D.Inventory_Org_Id
, D.Project_Id
, P.Segment1 Project_Number
, D.Quantity
, D.Expected_Shipment_Date
, D.Ndb_Schedule_Designator
, D.ship_to_location_id
, D.Task_Id
, T.Task_Number
, S.Sts_Code
, D.Unit_Number
, D.Uom_Code
, D.Dependency_Flag
, D.K_Line_Id
, D.Mps_Transaction_Id
, D.Ship_From_Org_Id
, D.Ship_To_Org_Id
, D.Direction
From oke_k_deliverables_b d
, pa_projects_all p
, pa_tasks t
, oke_system_items_v i
, oke_k_headers h
, okc_k_headers_b b
, okc_k_lines_b s
Where D.Deliverable_Id = P_Id
And B.Id = D.K_Header_Id
And H.K_Header_Id = B.Id
And D.Project_Id = P.Project_Id(+)
And D.Task_Id = T.Task_Id(+)
And D.Item_Id = I.Id1(+)
And D.Inventory_Org_Id = I.Id2(+)
And D.K_Line_Id = S.Id
And D.Ready_To_Procure = 'Y';
Select Name
From hr_all_organization_units
Where Organization_Id = P_Id;
SELECT COMPLETED_FLAG
INTO L_Completed_Flag
FROM OKE_K_DELIVERABLES_VL
WHERE DELIVERABLE_ID=L_Deliverable_ID;
SELECT SHIP_TO_LOCATION_ID
FROM OKE_K_DELIVERABLES_B
WHERE Deliverable_ID = L_Deliverable_ID;
SELECT PO_Ref_1
FROM OKE_K_DELIVERABLES_B
WHERE Deliverable_ID = L_Deliverable_ID
AND NOT EXISTS ( SELECT 1
FROM po_requisitions_interface_all
WHERE deliver_to_location_id = l_ship_to_location_id
AND oke_contract_deliverable_id = l_deliverable_id
AND process_flag = 'ERROR' );
SELECT Shipping_Request_ID
FROM OKE_K_DELIVERABLES_B
WHERE Deliverable_ID = L_Deliverable_ID;
SELECT Mps_Transaction_ID
FROM OKE_K_DELIVERABLES_B
WHERE Deliverable_ID = L_Deliverable_ID;
SELECT WF_ITEM_KEY
FROM OKE_K_DELIVERABLES_B
WHERE Deliverable_ID = P_Deliverable_ID;
SELECT ID
,SOURCE_CODE
,USAGE_CODE
,TARGET_DATE
,BEFORE_AFTER
,DURATION_DAYS
,RECIPIENT
,ROLE_ID
FROM OKE_NOTIFICATIONS
WHERE ID=P_DUE_NTF_ID
;