APPS.AP_GENERATE_DISTRIBUTIONS_PKG SQL Statements

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

Line: 26

  SELECT INVOICE_ID,
         LINE_NUMBER,
         LINE_TYPE_LOOKUP_CODE,
         REQUESTER_ID,
         DESCRIPTION,
         LINE_SOURCE,
         ORG_ID,
         LINE_GROUP_NUMBER,
         INVENTORY_ITEM_ID,
         ITEM_DESCRIPTION,
         SERIAL_NUMBER,
         MANUFACTURER,
         MODEL_NUMBER,
         WARRANTY_NUMBER,
         GENERATE_DISTS,
         MATCH_TYPE,
         DISTRIBUTION_SET_ID,
         ACCOUNT_SEGMENT,
         BALANCING_SEGMENT,
         COST_CENTER_SEGMENT,
         OVERLAY_DIST_CODE_CONCAT,
         DEFAULT_DIST_CCID,
         PRORATE_ACROSS_ALL_ITEMS,
         ACCOUNTING_DATE,
         PERIOD_NAME ,
         DEFERRED_ACCTG_FLAG ,
         DEF_ACCTG_START_DATE ,
         DEF_ACCTG_END_DATE,
         DEF_ACCTG_NUMBER_OF_PERIODS,
         DEF_ACCTG_PERIOD_TYPE ,
         SET_OF_BOOKS_ID,
         AMOUNT,
         BASE_AMOUNT,
         ROUNDING_AMT,
         QUANTITY_INVOICED,
         UNIT_MEAS_LOOKUP_CODE ,
         UNIT_PRICE,
         WFAPPROVAL_STATUS,
         DISCARDED_FLAG,
         ORIGINAL_AMOUNT,
         ORIGINAL_BASE_AMOUNT ,
         ORIGINAL_ROUNDING_AMT ,
         CANCELLED_FLAG ,
         INCOME_TAX_REGION,
         TYPE_1099   ,
         STAT_AMOUNT  ,
         PREPAY_INVOICE_ID ,
         PREPAY_LINE_NUMBER  ,
         INVOICE_INCLUDES_PREPAY_FLAG ,
         CORRECTED_INV_ID ,
         CORRECTED_LINE_NUMBER ,
         PO_HEADER_ID,
         PO_LINE_ID  ,
         PO_RELEASE_ID ,
         PO_LINE_LOCATION_ID ,
         PO_DISTRIBUTION_ID,
         RCV_TRANSACTION_ID,
         FINAL_MATCH_FLAG,
         ASSETS_TRACKING_FLAG ,
         ASSET_BOOK_TYPE_CODE ,
         ASSET_CATEGORY_ID ,
         PROJECT_ID ,
         TASK_ID ,
         EXPENDITURE_TYPE ,
         EXPENDITURE_ITEM_DATE ,
         EXPENDITURE_ORGANIZATION_ID ,
         PA_QUANTITY,
         PA_CC_AR_INVOICE_ID ,
         PA_CC_AR_INVOICE_LINE_NUM ,
         PA_CC_PROCESSED_CODE ,
         AWARD_ID,
         AWT_GROUP_ID ,
         REFERENCE_1 ,
         REFERENCE_2 ,
         RECEIPT_VERIFIED_FLAG  ,
         RECEIPT_REQUIRED_FLAG ,
         RECEIPT_MISSING_FLAG ,
         JUSTIFICATION  ,
         EXPENSE_GROUP ,
         START_EXPENSE_DATE ,
         END_EXPENSE_DATE ,
         RECEIPT_CURRENCY_CODE  ,
         RECEIPT_CONVERSION_RATE,
         RECEIPT_CURRENCY_AMOUNT ,
         DAILY_AMOUNT ,
         WEB_PARAMETER_ID ,
         ADJUSTMENT_REASON ,
         MERCHANT_DOCUMENT_NUMBER ,
         MERCHANT_NAME ,
         MERCHANT_REFERENCE ,
         MERCHANT_TAX_REG_NUMBER,
         MERCHANT_TAXPAYER_ID  ,
         COUNTRY_OF_SUPPLY,
         CREDIT_CARD_TRX_ID ,
         COMPANY_PREPAID_INVOICE_ID,
         CC_REVERSAL_FLAG ,
         CREATION_DATE ,
         CREATED_BY,
         LAST_UPDATED_BY ,
         LAST_UPDATE_DATE ,
         LAST_UPDATE_LOGIN ,
         PROGRAM_APPLICATION_ID ,
         PROGRAM_ID ,
         PROGRAM_UPDATE_DATE,
         REQUEST_ID ,
         ATTRIBUTE_CATEGORY,
         ATTRIBUTE1,
         ATTRIBUTE2,
         ATTRIBUTE3,
         ATTRIBUTE4,
         ATTRIBUTE5,
         ATTRIBUTE6,
         ATTRIBUTE7,
         ATTRIBUTE8,
         ATTRIBUTE9,
         ATTRIBUTE10,
         ATTRIBUTE11,
         ATTRIBUTE12,
         ATTRIBUTE13,
         ATTRIBUTE14,
         ATTRIBUTE15,
         GLOBAL_ATTRIBUTE_CATEGORY,
         GLOBAL_ATTRIBUTE1,
         GLOBAL_ATTRIBUTE2,
         GLOBAL_ATTRIBUTE3,
         GLOBAL_ATTRIBUTE4,
         GLOBAL_ATTRIBUTE5,
         GLOBAL_ATTRIBUTE6,
         GLOBAL_ATTRIBUTE7,
         GLOBAL_ATTRIBUTE8,
         GLOBAL_ATTRIBUTE9,
         GLOBAL_ATTRIBUTE10,
         GLOBAL_ATTRIBUTE11,
         GLOBAL_ATTRIBUTE12,
         GLOBAL_ATTRIBUTE13,
         GLOBAL_ATTRIBUTE14,
         GLOBAL_ATTRIBUTE15,
         GLOBAL_ATTRIBUTE16,
         GLOBAL_ATTRIBUTE17,
         GLOBAL_ATTRIBUTE18,
         GLOBAL_ATTRIBUTE19,
         GLOBAL_ATTRIBUTE20,
	 --ETAX: Invwkb
	 INCLUDED_TAX_AMOUNT,
	 PRIMARY_INTENDED_USE,
	 --Bugfix:4673607
	 APPLICATION_ID,
	 PRODUCT_TABLE,
	 REFERENCE_KEY1,
	 REFERENCE_KEY2,
	 REFERENCE_KEY3,
	 REFERENCE_KEY4,
	 REFERENCE_KEY5,
	 --bugfix:4674194
	 SHIP_TO_LOCATION_ID,
	 --bug7022001
	 PAY_AWT_GROUP_ID
  FROM AP_INVOICE_LINES AIL
  WHERE AIL.INVOICE_ID = P_INVOICE_ID
  AND AIL.LINE_NUMBER = NVL(P_INVOICE_LINE_NUMBER,AIL.LINE_NUMBER)
  AND LINE_TYPE_LOOKUP_CODE IN ('ITEM','FREIGHT','MISCELLANEOUS')
  AND NVL(AIL.GENERATE_DISTS,'N') = 'Y'
  ORDER BY DECODE(AIL.LINE_TYPE_LOOKUP_CODE,'ITEM',1,2), LINE_NUMBER;

Line: 211

SELECT 'Tax Lines not fully distributed'
  FROM AP_INVOICE_LINES_ALL AIL
  WHERE AIL.INVOICE_ID = P_INVOICE_ID
  AND AIL.LINE_TYPE_LOOKUP_CODE = 'TAX'
  AND AIL.amount <>
	(SELECT nvl(sum(amount),0)
	   FROM AP_INVOICE_DISTRIBUTIONS_ALL AID
	  WHERE AID.INVOICE_ID = AIL.INVOICE_ID
	    AND AID.INVOICE_LINE_NUMBER = AIL.LINE_NUMBER);

Line: 330

			SELECT rule_type, status
			INTO l_allocation_rule_type, l_allocation_status
			FROM ap_allocation_rules
			WHERE invoice_id = p_invoice_id
			AND chrg_invoice_line_number = t_inv_lines_table(i).line_number;

Line: 580

     FND_MESSAGE.SET_NAME('SQLAP', 'AP_INVOICE_UPDATED_REQUERY');

Line: 711

		SELECT rule_type, status
		INTO l_allocation_rule_type, l_allocation_status
		FROM ap_allocation_rules
		WHERE invoice_id = p_invoice_id
		AND chrg_invoice_line_number = t_inv_lines_table(i).line_number;

Line: 818

	SELECT nvl(included_tax_amount,0)
	INTO l_included_tax_amount
	FROM ap_invoice_lines
	WHERE invoice_id = p_invoice_id
	AND line_number = p_invoice_line_number;

Line: 884

     FND_MESSAGE.SET_NAME('SQLAP', 'AP_INVOICE_UPDATED_REQUERY');