[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
CONCURRENT_PROGRAM_ID,
NVL(ENABLE_TRACE
,'N')
FROM
FND_CONCURRENT_REQUESTS
WHERE REQUEST_ID = P_REQUEST_ID;
,'Report Version -> 115.2, Last Updated Date -> 17/11/2004')*/NULL;
SELECT
SET_OF_BOOKS_ID
FROM
ORG_ORGANIZATION_DEFINITIONS
WHERE CHART_OF_ACCOUNTS_ID = COA_ID;
SELECT
NAME
FROM
GL_SETS_OF_BOOKS
WHERE SET_OF_BOOKS_ID = SOB_ID;
SELECT
DISTINCT
APPLICATION_COLUMN_NAME
FROM
FND_SEGMENT_ATTRIBUTE_VALUES
WHERE APPLICATION_ID = 101
AND ID_FLEX_CODE = CP_ID_FLEX_CODE
AND ID_FLEX_NUM = P_CHART_OF_ACCTS_ID
AND SEGMENT_ATTRIBUTE_TYPE = CP_SEG_ATT_TYPE
AND ATTRIBUTE_VALUE = 'Y';
SELECT
A.FLEX_VALUE_SET_ID
FROM
FND_ID_FLEX_SEGMENTS A
WHERE A.APPLICATION_COLUMN_NAME = V_COLUMN_NAME
AND A.APPLICATION_ID = 101
AND A.ID_FLEX_CODE = CP_ID_FLEX_CODE
AND A.ID_FLEX_NUM = P_CHART_OF_ACCTS_ID;
SELECT
SUBSTR(DESCRIPTION
,1
,50)
FROM
FND_FLEX_VALUES_VL
WHERE FLEX_VALUE_SET_ID = V_FLEX_ID
AND FLEX_VALUE = V_COLUMN_VALUE;
'select ' || V_COLUMN_NAME || ' into :p_column_value from gl_code_combinations
where chart_of_accounts_id = :P_CHART_OF_ACCTS_ID AND code_combination_id = :account_code';*/
'select ' || V_COLUMN_NAME || ' from gl_code_combinations
where chart_of_accounts_id = :P_CHART_OF_ACCTS_ID AND code_combination_id = :account_code'
INTO p_column_value
USING P_CHART_OF_ACCTS_ID,account_code ;
SELECT
DECODE(P_BALANCE_TYPE
,'CR'
,SUM(ACCOUNTED_DR)
,'DR'
,SUM(ACCOUNTED_CR)
,0)
INTO V_AMOUNT2
FROM
GL_JE_HEADERS GLH,
GL_JE_LINES GLL,
CE_BANK_ACCOUNTS CBA
WHERE GLH.JE_HEADER_ID = GLL.JE_HEADER_ID
AND GLH.LEDGER_ID = GLL.LEDGER_ID
AND GLL.LEDGER_ID = LP_SET_OF_BOOKS_ID
AND CBA.ASSET_CODE_COMBINATION_ID = GLL.CODE_COMBINATION_ID
AND CBA.BANK_ACCOUNT_ID = P_BANK_ACCOUNT_ID
AND GLH.JE_SOURCE NOT IN ( LV_PAY_SOURCE , LV_RCV_SOURCE , LV_PAY_SOURCE1 , LV_RCV_SOURCE1 )
AND GLH.DEFAULT_EFFECTIVE_DATE < V_BASE_DATE
AND ( CBA.ACCOUNT_OWNER_ORG_ID IS NULL
OR CBA.ACCOUNT_OWNER_ORG_ID = P_ORG_ID );
SELECT
SUM(DECODE(ACRH.STATUS
,'REVERSED'
,(ACRH.AMOUNT * NVL(ACRH.EXCHANGE_RATE
,1)) * -1
,NVL(ACRH.AMOUNT
,0) * NVL(ACRH.EXCHANGE_RATE
,1)))
INTO V_AMOUNT1
FROM
AR_CASH_RECEIPT_HISTORY_ALL ACRH,
AR_CASH_RECEIPTS_ALL ACR,
HZ_PARTIES HP,
HZ_CUST_ACCOUNTS HCA,
CE_BANK_ACCOUNTS CBA
WHERE ACRH.CASH_RECEIPT_ID = ACR.CASH_RECEIPT_ID
AND ACR.REMITTANCE_BANK_ACCOUNT_ID = CBA.BANK_ACCOUNT_ID
AND HCA.PARTY_ID = hp.party_id (+)
AND ACR.PAY_FROM_CUSTOMER = hca.cust_account_id (+)
AND ACRH.STATUS IN ( LV_CLEAR_STATUS , LV_REMIT_STATUS , LV_CONFIRM_STATUS , LV_REV_STATUS )
AND ( ( ACRH.STATUS = LV_REV_STATUS
AND ACR.REVERSAL_DATE is not null )
OR ( ACRH.CASH_RECEIPT_HISTORY_ID IN (
SELECT
MIN(INCRH.CASH_RECEIPT_HISTORY_ID)
FROM
AR_CASH_RECEIPT_HISTORY_ALL INCRH
WHERE INCRH.CASH_RECEIPT_ID = ACR.CASH_RECEIPT_ID
AND INCRH.STATUS <> LV_REV_STATUS ) ) )
AND CBA.BANK_ACCOUNT_ID = P_BANK_ACCOUNT_ID
AND ACRH.GL_DATE < V_BASE_DATE
AND ( ACR.ORG_ID IS NULL
OR ACR.ORG_ID = P_ORG_ID );
SELECT
SUM(API.INVOICE_AMOUNT * NVL(API.EXCHANGE_RATE
,1))
INTO V_AMOUNT3
FROM
AP_INVOICE_DISTRIBUTIONS_ALL APID,
AP_INVOICE_LINES_ALL APLA,
AP_INVOICES_ALL API,
PO_VENDORS POV,
CE_BANK_ACCOUNTS CBA
WHERE API.INVOICE_ID = APID.INVOICE_ID
AND APLA.INVOICE_ID = APID.INVOICE_ID
AND APLA.LINE_NUMBER = APID.INVOICE_LINE_NUMBER
AND API.VENDOR_ID = POV.VENDOR_ID
AND CBA.BANK_ACCOUNT_ID = P_BANK_ACCOUNT_ID
AND CBA.ASSET_CODE_COMBINATION_ID = APID.DIST_CODE_COMBINATION_ID
AND APID.MATCH_STATUS_FLAG = 'A'
AND APID.ACCOUNTING_DATE < V_BASE_DATE
AND ( CBA.ACCOUNT_OWNER_ORG_ID IS NULL
OR CBA.ACCOUNT_OWNER_ORG_ID = P_ORG_ID );
SELECT
SUM(NVL(AIP.AMOUNT
,0) * NVL(AIP.EXCHANGE_RATE
,1))
INTO V_AMOUNT1
FROM
AP_INVOICE_PAYMENTS_ALL AIP,
AP_CHECKS_ALL APC,
CE_BANK_ACCOUNTS CBA
WHERE AIP.CHECK_ID = APC.CHECK_ID
AND APC.BANK_ACCOUNT_ID = CBA.BANK_ACCOUNT_ID
AND APC.STATUS_LOOKUP_CODE IN ( LV_NEGOT_LOOKUP , LV_CLEAR_LOOKUP , LV_VOIDED_LOOKUP , LV_REC_UNACC_LOOKUP , LV_REC_LOOKUP , LV_CLEAR_UNACC_LOOKUP )
AND CBA.BANK_ACCOUNT_ID = P_BANK_ACCOUNT_ID
AND AIP.ACCOUNTING_DATE < V_BASE_DATE
AND ( CBA.ACCOUNT_OWNER_ORG_ID IS NULL
OR CBA.ACCOUNT_OWNER_ORG_ID = P_ORG_ID );