APPS.ASO_DEFAULTING_UTIL SQL Statements

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

Line: 44

  SELECT Party_Type
  FROM HZ_PARTIES
  WHERE Party_Id = lc_party_id;

Line: 49

  SELECT pty.Party_Type
  FROM HZ_PARTIES pty, ASO_QUOTE_HEADERS_ALL hdr
  WHERE pty.Party_Id = hdr.cust_party_id
  AND hdr.quote_header_id = lc_quote_header_id;

Line: 55

  SELECT Segment1
  FROM mtl_system_items_vl
  WHERE inventory_item_id = lc_inv_item_id
  AND organization_id = lc_organization_id;

Line: 321

           P_Quote_Header_Rec.LAST_UPDATE_DATE IS NULL THEN
          X_Qte_Header_Row_Rec.Q_LAST_UPDATE_DATE := FND_API.G_MISS_DATE;

Line: 324

          X_Qte_Header_Row_Rec.Q_LAST_UPDATE_DATE := P_Quote_Header_Rec.LAST_UPDATE_DATE;

Line: 921

           P_Quote_Header_Rec.LAST_UPDATE_DATE IS NULL THEN
          X_Qte_Opportunity_Row_Rec.O_LAST_UPDATE_DATE := FND_API.G_MISS_DATE;

Line: 924

          X_Qte_Opportunity_Row_Rec.O_LAST_UPDATE_DATE := P_Quote_Header_Rec.LAST_UPDATE_DATE;

Line: 1351

           P_Quote_Line_Rec.LAST_UPDATE_DATE IS NULL THEN
          X_Qte_Line_Row_Rec.L_LAST_UPDATE_DATE := FND_API.G_MISS_DATE;

Line: 1354

          X_Qte_Line_Row_Rec.L_LAST_UPDATE_DATE := P_Quote_Line_Rec.LAST_UPDATE_DATE;

Line: 1851

          X_Quote_Header_Rec.LAST_UPDATE_DATE := P_Qte_Header_Row_Rec.Q_LAST_UPDATE_DATE;

Line: 1927

          X_Quote_Header_Rec.LAST_UPDATE_DATE := P_Qte_Opportunity_Row_Rec.O_LAST_UPDATE_DATE;

Line: 1980

          X_Quote_Line_Rec.LAST_UPDATE_DATE := P_Qte_Line_Row_Rec.L_LAST_UPDATE_DATE;

Line: 2105

          P_Qte_Header_Row_Rec.Q_LAST_UPDATE_DATE := FND_API.G_MISS_DATE;

Line: 2183

          P_Qte_Opportunity_Row_Rec.O_LAST_UPDATE_DATE := FND_API.G_MISS_DATE;

Line: 2240

          P_Qte_Line_Row_Rec.L_LAST_UPDATE_DATE :=  FND_API.G_MISS_DATE;