APPS.ASO_OPP_QTE_PUB SQL Statements

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

Line: 108

l_last_update_date           Date;

Line: 159

SELECT offer_id
FROM as_leads_all
WHERE lead_id = p_lead_id;

Line: 167

SELECT lead_line_id,
       inventory_item_id,
       organization_id,
       uom_code,
       NVL(quantity, 1) quantity,
       offer_id,
       forecast_date
FROM as_lead_lines_all
WHERE lead_id = p_lead_id
AND inventory_item_id IS NOT NULL
AND organization_id IS NOT NULL;

Line: 181

SELECT salesforce_id,
       salesgroup_id,
       credit_type_id,
       credit_percent
FROM as_sales_credits
WHERE lead_id = p_lead_id
AND lead_line_id = p_lead_line_id;

Line: 190

SELECT contact_point_id
FROM hz_contact_points
WHERE owner_table_id = p_party_id
AND owner_table_name = 'HZ_PARTIES'
AND contact_point_type = 'PHONE'
AND status = 'A'
AND primary_flag = 'Y';

Line: 199

SELECT source_code_for_id
FROM ams_source_codes
WHERE source_code_id = l_sc_id;

Line: 204

SELECT concatenated_segments
FROM MTL_SYSTEM_ITEMS_VL
WHERE inventory_item_id = l_inventory_item_id;

Line: 209

SELECT salesforce_id,
       sales_group_id,
       request_id,
       program_application_id,
       program_id,
       program_update_date,
       freeze_flag,
       team_leader_flag,
       created_by_tap_flag,
       attribute_category,
       attribute1,
       attribute2,
       attribute3,
       attribute4,
       attribute5,
       attribute6,
       attribute7,
       attribute8,
       attribute9,
       attribute10,
       attribute11,
       attribute12,
       attribute13,
       attribute14,
       attribute15
FROM AS_ACCESSES_ALL
WHERE lead_id = l_lead_id;

Line: 240

SELECT a.freeze_flag,c.access_id
FROM AS_ACCESSES_ALL a, ASO_QUOTE_HEADERS_ALL B,aso_quote_accesses c
WHERE a.lead_id = p_lead_id
AND b.quote_number = p_qte_number
AND a.salesforce_id = c.resource_id
AND b.quote_number =c.quote_number;

Line: 248

SELECT primary_uom_code
FROM MTL_SYSTEM_ITEMS_B
WHERE inventory_item_id = p_item_id
AND organization_id = p_organization_id;

Line: 254

SELECT term_id
FROM   oe_agreements
WHERE  agreement_id = p_agreement_id;

Line: 259

SELECT hcp.standard_terms
FROM hz_cust_accounts hca,hz_customer_profiles hcp
WHERE  hca.cust_account_id = p_cust_account_id
AND hcp.cust_account_id = hca.cust_account_id
AND    nvl(hcp.status,'A') = 'A';

Line: 266

SELECT   hps.party_site_id
FROM     hz_party_sites hps, hz_party_site_uses hpsu
WHERE    hps.party_id= p_party_id
AND      hps.status='A'
AND      hps.party_site_id= hpsu.party_site_id
AND      hpsu.site_use_type= p_site_use_type
AND      hpsu.primary_per_type='Y'
AND      hpsu.status='A';

Line: 276

SELECT party_site_id
FROM   hz_party_sites
WHERE  party_id= p_party_id
AND    status='A'
AND    identifying_address_flag='Y';

Line: 285

SELECT charge_periodicity_code
FROM   mtl_system_items_b
WHERE  inventory_item_id = p_inventory_item_id
AND    organization_id = p_organization_id;

Line: 291

SELECT service_item_flag,service_duration,service_duration_period_code
FROM MTL_SYSTEM_ITEMS_VL
WHERE inventory_item_id = l_inventory_item_id
AND organization_id = l_organization_id
AND customer_order_enabled_flag = 'Y'
AND bom_item_type <> 2
AND NVL(start_date_active, SYSDATE) <= SYSDATE
AND NVL(end_date_active, SYSDATE) >= SYSDATE;

Line: 596

        IF P_OPP_QTE_IN_REC.PRICE_UPDATED_DATE <>  FND_API.G_MISS_DATE THEN
            l_qte_header_rec.PRICE_UPDATED_DATE := P_OPP_QTE_IN_REC.PRICE_UPDATED_DATE;

Line: 600

        IF P_OPP_QTE_IN_REC.TAX_UPDATED_DATE <>  FND_API.G_MISS_DATE THEN
            l_qte_header_rec.TAX_UPDATED_DATE := P_OPP_QTE_IN_REC.TAX_UPDATED_DATE;

Line: 1222

              l_qte_access_rec.LAST_UPDATED_BY := G_USER_ID;

Line: 1223

              l_qte_access_rec.LAST_UPDATE_LOGIN := G_LOGIN_ID;

Line: 1224

              l_qte_access_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1228

              l_qte_access_rec.PROGRAM_UPDATE_DATE := l_sales_team_rec.program_update_date;

Line: 1230

              l_qte_access_rec.UPDATE_ACCESS_FLAG := l_sales_team_rec.team_leader_flag;

Line: 1264

	  aso_debug_pub.add('ASO_OPP_QTE_PUB: before Update_Quote', 1, 'Y');

Line: 1269

        SELECT last_update_date into l_last_update_date
        FROM ASO_QUOTE_HEADERS_ALL
        WHERE quote_header_id = lx_qte_header_rec.quote_header_id;

Line: 1273

        lx_QTE_HEADER_REC.last_update_date  := l_last_update_date;

Line: 1279

	               FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);

Line: 1286

    ASO_QUOTE_PUB.Update_Quote(
          p_api_version_number      => 1.0,
          p_init_msg_list           => fnd_api.g_false,
          p_commit                  => fnd_api.g_false,
          p_control_rec             => p_control_rec,
          p_qte_header_rec          => lx_qte_header_rec,
          p_qte_line_tbl            => l_qte_line_tbl,
		p_qte_line_dtl_tbl        => l_qte_line_dtl_tbl,
          p_ln_Price_Attributes_Tbl => l_ln_price_attributes_tbl,
          p_ln_shipment_tbl         => l_ln_shipment_tbl,
          p_ln_sales_credit_Tbl     => l_ln_sales_credit_tbl,
		P_Qte_Access_Tbl          => l_qte_access_tbl,
		P_Template_Tbl            => P_Template_Tbl,
          X_Qte_Header_Rec          => lx_out_qte_header_rec,
          X_Qte_Line_Tbl            => lx_Qte_Line_Tbl,
          X_Qte_Line_Dtl_Tbl        => lx_Qte_Line_Dtl_Tbl,
          X_hd_Price_Attributes_Tbl => lx_hd_Price_Attributes_Tbl,
          X_hd_Payment_Tbl          => lx_hd_Payment_Tbl,
          X_hd_Shipment_Tbl         => lx_hd_Shipment_Tbl,
          X_hd_Freight_Charge_Tbl   => lx_hd_Freight_Charge_Tbl,
          X_hd_Tax_Detail_Tbl       => lx_hd_Tax_Detail_Tbl,
          X_hd_Attr_Ext_Tbl         => lX_hd_Attr_Ext_Tbl,
          X_hd_Sales_Credit_Tbl     => lx_hd_Sales_Credit_Tbl,
          X_hd_Quote_Party_Tbl      => lx_hd_Quote_Party_Tbl,
          X_Line_Attr_Ext_Tbl       => lx_Line_Attr_Ext_Tbl,
          X_line_rltship_tbl        => lx_line_rltship_tbl,
          X_Price_Adjustment_Tbl    => lx_Price_Adjustment_Tbl,
          X_Price_Adj_Attr_Tbl      => lx_Price_Adj_Attr_Tbl,
          X_Price_Adj_Rltship_Tbl   => lx_Price_Adj_Rltship_Tbl,
          X_ln_Price_Attributes_Tbl => lx_ln_Price_Attributes_Tbl,
          X_ln_Payment_Tbl          => lx_ln_Payment_Tbl,
          X_ln_Shipment_Tbl         => lx_ln_Shipment_Tbl,
          X_ln_Freight_Charge_Tbl   => lx_ln_Freight_Charge_Tbl,
          X_ln_Tax_Detail_Tbl       => lx_ln_Tax_Detail_Tbl,
          X_Ln_Sales_Credit_Tbl     => lX_Ln_Sales_Credit_Tbl,
          X_Ln_Quote_Party_Tbl      => lX_Ln_Quote_Party_Tbl,
		X_Qte_Access_Tbl          => lx_Qte_Access_Tbl,
		X_Template_Tbl            => lx_Qte_Template_Tbl,
		X_Related_Obj_Tbl         => lX_Related_Obj_Tbl,
          X_Return_Status           => x_Return_Status,
          X_Msg_Count               => x_Msg_Count,
          X_Msg_Data                => x_Msg_Data);

Line: 1334

       aso_debug_pub.add('update_quote:X_Return_Status:'||X_Return_Status,1,'N');

Line: 1335

       aso_debug_pub.add('update_quote:X_Msg_Count:'||X_Msg_Count,1,'N');

Line: 1361

           ASO_QUOTE_ACCESSES_PKG.UPDATE_ROW(
               P_ACCESS_ID               =>      l_opp_rec.access_id,
               P_QUOTE_NUMBER            =>      FND_API.G_MISS_NUM,
               P_RESOURCE_ID             =>      FND_API.G_MISS_NUM,
               P_RESOURCE_GRP_ID         =>      FND_API.G_MISS_NUM,
               P_CREATED_BY              =>      FND_API.G_MISS_NUM,
               P_CREATION_DATE           =>      FND_API.G_MISS_DATE,
               P_LAST_UPDATED_BY         =>      G_USER_ID,
               P_LAST_UPDATE_LOGIN       =>      G_LOGIN_ID,
               P_LAST_UPDATE_DATE        =>      SYSDATE,
               P_REQUEST_ID              =>      FND_API.G_MISS_NUM,
               P_PROGRAM_APPLICATION_ID  =>      FND_API.G_MISS_NUM,
               P_PROGRAM_ID              =>      FND_API.G_MISS_NUM,
               P_PROGRAM_UPDATE_DATE     =>      FND_API.G_MISS_DATE,
               P_KEEP_FLAG               =>      l_opp_rec.freeze_flag,
               P_UPDATE_ACCESS_FLAG      =>      FND_API.G_MISS_CHAR,
               P_CREATED_BY_TAP_FLAG     =>      FND_API.G_MISS_CHAR,
               p_TERRITORY_ID            =>      FND_API.G_MISS_NUM,
               p_TERRITORY_SOURCE_FLAG   =>      FND_API.G_MISS_CHAR,
               p_ROLE_ID                 =>      FND_API.G_MISS_NUM,
               P_ATTRIBUTE_CATEGORY      =>      FND_API.G_MISS_CHAR,
               P_ATTRIBUTE1              =>      FND_API.G_MISS_CHAR,
               P_ATTRIBUTE2              =>      FND_API.G_MISS_CHAR,
               P_ATTRIBUTE3              =>      FND_API.G_MISS_CHAR,
               P_ATTRIBUTE4              =>      FND_API.G_MISS_CHAR,
               P_ATTRIBUTE5              =>      FND_API.G_MISS_CHAR,
               P_ATTRIBUTE6              =>      FND_API.G_MISS_CHAR,
               P_ATTRIBUTE7              =>      FND_API.G_MISS_CHAR,
               P_ATTRIBUTE8              =>      FND_API.G_MISS_CHAR,
               P_ATTRIBUTE9              =>      FND_API.G_MISS_CHAR,
               P_ATTRIBUTE10             =>      FND_API.G_MISS_CHAR,
               P_ATTRIBUTE11             =>      FND_API.G_MISS_CHAR,
               P_ATTRIBUTE12             =>      FND_API.G_MISS_CHAR,
               P_ATTRIBUTE13             =>      FND_API.G_MISS_CHAR,
               P_ATTRIBUTE14             =>      FND_API.G_MISS_CHAR,
               P_ATTRIBUTE15             =>      FND_API.G_MISS_CHAR,
               p_ATTRIBUTE16    		  =>      FND_API.G_MISS_CHAR,
               p_ATTRIBUTE17    		  =>      FND_API.G_MISS_CHAR,
               p_ATTRIBUTE18    		  =>      FND_API.G_MISS_CHAR,
               p_ATTRIBUTE19    		  =>      FND_API.G_MISS_CHAR,
               p_ATTRIBUTE20   		  =>      FND_API.G_MISS_CHAR,
		     P_OBJECT_VERSION_NUMBER   =>      FND_API.G_MISS_NUM
           );

Line: 1574

 SELECT concatenated_segments
 FROM MTL_SYSTEM_ITEMS_VL
 WHERE inventory_item_id = l_inventory_item_id;

Line: 1579

 SELECT bom_item_type,
        primary_uom_code,
        service_item_flag
 FROM MTL_SYSTEM_ITEMS_VL
 WHERE inventory_item_id = l_inventory_item_id
 AND organization_id = l_organization_id
 AND customer_order_enabled_flag = 'Y'
 AND bom_item_type <> 2
 AND NVL(start_date_active, SYSDATE) <= SYSDATE
 AND NVL(end_date_active, SYSDATE) >= SYSDATE;

Line: 1591

 select segment1
 from mtl_system_items_vl
 WHERE inventory_item_id = l_inventory_item_id
 AND organization_id = l_organization_id;

Line: 1767

    SELECT jtf_note_id
      FROM jtf_notes_b
     WHERE source_object_id = object_id
       AND source_object_code = 'OPPORTUNITY';

Line: 1773

    SELECT task_id
      FROM jtf_tasks_b
     WHERE source_object_id = object_id
       AND source_object_type_code = 'OPPORTUNITY';

Line: 1779

    SELECT attached_document_id
      FROM fnd_attached_documents
     WHERE pk1_value = TO_CHAR(object_id)
       AND entity_name = 'AS_OPPORTUNITY_ATTCH';

Line: 1816

  SELECT location_id from hz_party_sites
  WHERE party_site_id = p_party_site_id ;

Line: 1820

  SELECT loc_id from hz_loc_assignments
  WHERE location_id = p_location_id ;