APPS.OKE_DTS_ACTION_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 24

    Select Allowed_YN
    From okc_assents
    Where Sts_Code = P_Sts_Code
    And Opn_Code = P_Opn_Code;

Line: 51

    Select 'x'
    From dual
    Where exists( Select 1
		  From oke_dependencies
	          Where Dependent_Id = P_Deliverable_Id);

Line: 86

    Select 'x'
    From oke_system_items_v
    Where Organization_Id = P_Inventory_Org_Id
    And Inventory_Item_Id = P_Item_Id;

Line: 116

    Select Name
    From okx_locations_v
    Where Id1 = P_Id;

Line: 121

    Select Name
    From okx_vendor_sites_v
    Where Id1 = P_Id;

Line: 126

    Select Name
    From oke_cust_site_uses_v
    Where Id1 = P_Id;

Line: 190

    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.K_Header_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'
--bug 8320909 start
   And Not Exists
 	     (SELECT Schedule_quantity
 	     FROM mrp_schedule_dates
 	     WHERE Mps_Transaction_ID =D. Mps_Transaction_Id
 	     AND Schedule_Level = 2
 	     AND Supply_Demand_Type = 1
 	     AND Schedule_quantity=0);

Line: 244

    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.K_Line_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'
--bug 8320909 start
And Not Exists
 	     (SELECT Schedule_quantity
 	     FROM mrp_schedule_dates
 	     WHERE Mps_Transaction_ID =D. Mps_Transaction_Id
 	     AND Schedule_Level = 2
 	     AND Supply_Demand_Type = 1
 	     AND Schedule_quantity=0);

Line: 298

    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';

Line: 344

    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.K_Header_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'
    And ( D.Po_Ref_1 Is Null
    Or Exists ( Select 'X' From po_requisitions_interface_all p
		    Where P.Oke_Contract_Deliverable_ID = D.Deliverable_ID
		    And Nvl(P.Process_Flag, 'S') = 'ERROR'
		    And Nvl(P.Batch_ID, 0) = Nvl(D.Po_Ref_1, 0)));

Line: 395

    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.K_Line_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'
    And ( D.Po_Ref_1 Is Null
    Or Exists ( Select 'X' From po_requisitions_interface_all p
		    Where P.Oke_Contract_Deliverable_ID = D.Deliverable_ID
		    And Nvl(P.Process_Flag, 'S') = 'ERROR'
		    And Nvl(P.Batch_ID, 0) = Nvl(D.Po_Ref_1, 0)));

Line: 446

    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';

Line: 492

    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.K_Header_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'
    And D.Shipping_Request_Id Is Null;

Line: 539

    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.K_Line_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'
    And D.Shipping_Request_Id Is Null;

Line: 586

    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';

Line: 632

    Select Name
    From hr_all_organization_units
    Where Organization_Id = P_Id;

Line: 637

    Select Line_Number
    From okc_k_lines_b
    Where Id = P_Id;