APPS.ASO_SHIPMENT_PVT SQL Statements

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

Line: 12

PROCEDURE Delete_shipment(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2     := FND_API.G_FALSE,
    P_Commit                     IN   VARCHAR2     := FND_API.G_FALSE,
    p_qte_line_rec               IN   aso_quote_pub.qte_line_rec_type
				:= ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC,
    p_shipment_rec               IN   aso_quote_pub.shipment_rec_type,
    X_Return_Status              OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
    X_Msg_Count                  OUT NOCOPY /* file.sql.39 change */ NUMBER,
    X_Msg_Data                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
    )
IS
    l_api_name                CONSTANT VARCHAR2(30) := 'Delete_quote';

Line: 28

	SELECT FREIGHT_CHARGE_ID FROM aso_freight_charges
	WHERE QUOTE_SHIPMENT_ID = p_shipment_rec.shipment_id;

Line: 34

      SAVEPOINT DELETE_SHIPMENT_PVT;

Line: 61

        ASO_RESERVATION_INT.Delete_Reservation(
		P_Api_Version_Number	=> 1.0,
		P_Init_Msg_List         => FND_API.G_FALSE,
		P_Commit                => FND_API.G_FALSE,
		P_line_Rec		=> p_qte_line_rec,
		p_shipment_rec		=> p_shipment_rec,
		X_Return_Status         => l_Return_Status,
		X_Msg_Count             => X_Msg_Count,
		X_Msg_Data              => X_Msg_Data);

Line: 72

	    FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_DELETE_RSV');

Line: 79

	ASO_FREIGHT_CHARGES_PKG.Delete_Row(
		p_FREIGHT_CHARGE_ID => freight_rec.FREIGHT_CHARGE_ID);

Line: 83

      ASO_SHIPMENTS_PKG.Delete_Row(
          p_SHIPMENT_ID  => p_shipment_rec.shipment_id);

Line: 136

End Delete_Shipment;

Line: 145

	SELECT invoice_to_party_site_id FROM ASO_quote_lines_All
	WHERE	quote_line_id = p_qte_line_id
    AND quote_header_id = p_qte_header_id;

Line: 150

	SELECT invoice_to_party_site_id FROM ASO_quote_headers_All
	WHERE	quote_header_id = p_qte_header_id;

Line: 156

  select quote_line_id
  from aso_quote_line_details
  where (config_header_id, config_revision_num) = (select config_header_id,config_revision_num
                                                   from aso_quote_line_details
                                                   where quote_line_id = p_qte_line_id)
  and ref_type_code = 'CONFIG'
  and ref_line_id  is null;

Line: 165

  select item_type_code
  from aso_quote_lines_all
  where quote_line_id = p_qte_line_id;

Line: 246

    SELECT invoice_to_party_site_id FROM ASO_quote_lines_All
    WHERE	quote_line_id = p_qte_line_id
    AND quote_header_id = p_qte_header_id;

Line: 251

    SELECT invoice_to_party_site_id FROM ASO_quote_headers_All
    WHERE	quote_header_id = p_qte_header_id;

Line: 259

    SELECT cust_account_id FROM ASO_QUOTE_HEADERS_ALL
    WHERE quote_header_id = p_qte_header_id;

Line: 263

    SELECT site_use_id
    FROM hz_cust_site_uses b,hz_cust_acct_sites a
    WHERE b.cust_acct_site_id = a.cust_acct_site_id
    AND b.site_use_code = 'BILL_TO' --and b.primary_flag = 'Y'
    AND a.party_site_id = l_inv_site_id
    AND a.cust_account_id = l_cust_id;

Line: 271

   SELECT INVOICE_TO_CUST_ACCOUNT_ID FROM ASO_QUOTE_LINES_ALL
   WHERE quote_header_id = p_qte_header_id and quote_line_id =p_qte_line_id ;

Line: 275

    SELECT INVOICE_TO_CUST_ACCOUNT_ID FROM ASO_QUOTE_HEADERS_ALL
    WHERE quote_header_id = p_qte_header_id ;

Line: 282

  select item_type_code
  from aso_quote_lines_all
  where quote_line_id = p_qte_line_id;

Line: 287

  select quote_line_id
  from aso_quote_line_details
  where (config_header_id, config_revision_num) = (select config_header_id,config_revision_num
                                                   from aso_quote_line_details
                                                   where quote_line_id = p_qte_line_id)
  and ref_type_code = 'CONFIG'
  and ref_line_id  is null;

Line: 473

	SELECT ship_to_party_site_id, SHIP_TO_CUST_ACCOUNT_ID  FROM ASO_SHIPMENTS
	WHERE	shipment_id = p_shipment_id AND quote_line_id =
p_qte_line_id AND quote_header_id = p_qte_header_id;

Line: 480

	SELECT ship_to_party_site_id , SHIP_TO_CUST_ACCOUNT_ID
	FROM ASO_SHIPMENTS
     WHERE quote_header_id = p_qte_header_id
     and shipment_id =p_shipment_id
     AND   quote_line_id IS NULL;

Line: 489

	SELECT ship_to_party_site_id , SHIP_TO_CUST_ACCOUNT_ID
	FROM   ASO_SHIPMENTS
	WHERE  quote_header_id = p_qte_header_id
	AND    shipment_id     = p_ship_id
	AND    quote_line_id IS NULL;

Line: 499

    SELECT cust_account_id  FROM ASO_QUOTE_HEADERS_ALL
    WHERE quote_header_id = p_qte_header_id;

Line: 503

    SELECT SHIP_TO_CUST_ACCOUNT_ID FROM ASO_SHIPMENTS
    WHERE quote_header_id = p_qte_header_id and quote_line_id =p_qte_line_id and shipment_id =p_shipment_id;

Line: 509

    SELECT SHIP_TO_CUST_ACCOUNT_ID
    FROM ASO_SHIPMENTS
    WHERE quote_header_id = p_qte_header_id
    and shipment_id =p_shipment_id
    and quote_line_id IS NULL;

Line: 518

    SELECT SHIP_TO_CUST_ACCOUNT_ID
    FROM ASO_SHIPMENTS
    WHERE quote_header_id = p_qte_header_id
    and shipment_id       = p_ship_id
    and quote_line_id IS NULL;

Line: 525

         SELECT site_use_id
         FROM hz_cust_site_uses b,hz_cust_acct_sites a
         WHERE b.cust_acct_site_id = a.cust_acct_site_id
         AND b.site_use_code = 'SHIP_TO' --and b.primary_flag = 'Y'
         AND a.party_site_id = l_ship_site_id
         AND a.cust_account_id = l_cust_id;

Line: 533

  select quote_line_id
  from aso_quote_line_details
  where (config_header_id, config_revision_num) = (select config_header_id,config_revision_num
                                                   from aso_quote_line_details
                                                   where quote_line_id = p_qte_line_id)
  and ref_type_code = 'CONFIG'
  and ref_line_id  is null;

Line: 542

  select item_type_code
  from aso_quote_lines_all
  where quote_line_id = p_qte_line_id;

Line: 547

  select shipment_id
  from aso_shipments
  where quote_line_id = p_line_id
  and quote_header_id = p_qte_header_id;

Line: 564

    SELECT SHIPMENT_ID
    FROM   ASO_SHIPMENTS
    WHERE quote_header_id = p_qte_header_id
    AND quote_line_id IS NULL;

Line: 840

    SELECT ship_to_party_site_id FROM ASO_SHIPMENTS
    WHERE  shipment_id = p_shipment_id
	AND quote_line_id = p_qte_line_id
	AND quote_header_id = p_qte_header_id;

Line: 846

	SELECT ship_to_party_site_id FROM ASO_SHIPMENTS
	WHERE  quote_line_id IS NULL AND quote_header_id = p_qte_header_id;

Line: 852

  select quote_line_id
  from aso_quote_line_details
  where (config_header_id, config_revision_num) = (select config_header_id,config_revision_num
                                                   from aso_quote_line_details
                                                   where quote_line_id = p_qte_line_id)
  and ref_type_code = 'CONFIG'
  and ref_line_id  is null;

Line: 861

  select item_type_code
  from aso_quote_lines_all
  where quote_line_id = p_qte_line_id;

Line: 866

  select shipment_id
  from aso_shipments
  where quote_line_id = p_line_id
  and quote_header_id = p_qte_header_id;

Line: 964

 select HP.party_id,HP.party_name
  from hz_relationships HPR,hz_parties HP where  hpr.party_id = p_party_id
  and hp.party_id=HPR.object_id
  and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
  and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
  and HPR.directional_flag = 'B'; -- Added for bug 8634067

Line: 972

   select party_id,party_name
  from hz_parties HP where  party_id = p_party_id;

Line: 1007

 select HP.party_id,HP.person_first_name
  from hz_relationships HPR,hz_parties HP where  hpr.party_id = p_party_id
  and hp.party_id=HPR.subject_id
  and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
  and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
  and HPR.directional_flag = 'F'; -- 8634067

Line: 1015

   select party_id,person_first_name
  from hz_parties HP where  party_id = p_party_id;

Line: 1050

 select HP.party_id,HP.person_middle_name
  from hz_relationships HPR,hz_parties HP where  hpr.party_id = p_party_id
  and hp.party_id=HPR.subject_id
  and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
  and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
  and HPR.directional_flag = 'F'; -- 8634067

Line: 1058

   select party_id,person_middle_name
  from hz_parties HP where  party_id = p_party_id;

Line: 1092

 select HP.party_id,HP.person_last_name
  from hz_relationships HPR,hz_parties HP where  hpr.party_id = p_party_id
  and hp.party_id=HPR.subject_id
  and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
  and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
  and HPR.directional_flag = 'F'; -- 8634067

Line: 1100

   select party_id,person_last_name
  from hz_parties HP where  party_id = p_party_id;

Line: 1137

SELECT ship_from_org_id FROM ASO_shipments
WHERE	quote_line_id = p_qte_line_id
AND quote_header_id = p_qte_header_id;

Line: 1143

SELECT ship_from_org_id FROM ASO_shipments
WHERE	quote_header_id = p_qte_header_id
AND quote_line_id IS NULL;

Line: 1188

SELECT ship_method_code FROM ASO_shipments
WHERE quote_line_id = p_qte_line_id
AND quote_header_id = p_qte_header_id;

Line: 1194

SELECT ship_method_code FROM ASO_shipments
WHERE quote_header_id = p_qte_header_id
AND quote_line_id IS NULL;

Line: 1258

SELECT demand_class_code FROM ASO_shipments
WHERE quote_line_id = p_qte_line_id
AND quote_header_id = p_qte_header_id;

Line: 1264

SELECT demand_class_code FROM ASO_shipments
WHERE quote_header_id = p_qte_header_id
AND quote_line_id IS NULL;

Line: 1328

SELECT ship_to_party_site_id FROM ASO_shipments
WHERE quote_line_id = p_qte_line_id
AND quote_header_id = p_qte_header_id;

Line: 1334

SELECT ship_to_party_site_id FROM ASO_shipments
WHERE quote_header_id = p_qte_header_id
AND quote_line_id IS NULL;

Line: 1398

SELECT ship_to_cust_account_id FROM ASO_shipments
WHERE quote_line_id = p_qte_line_id
AND quote_header_id = p_qte_header_id;

Line: 1404

SELECT ship_to_cust_account_id FROM ASO_shipments
WHERE quote_header_id = p_qte_header_id
AND quote_line_id IS NULL;