[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
SUM(NVL(WRITE_OFF_AMOUNT
,0))
FROM
JAI_CMN_BOE_WRITEOFFS
WHERE BOE_ID = V_BOE_ID
AND TRUNC(WRITE_OFF_DATE) < TRUNC(P_START_DATE)
ORDER BY
WRITE_OFF_DATE;
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
HDR.BOE_TYPE,
HDR.BOE_ID,
HDR.BOE_AMOUNT,
HDR.AMOUNT_APPLIED,
WRT.WRITE_OFF_AMOUNT,
WRT.WRITE_OFF_DATE,
WRT.WRITE_OFF_REASON,
ORG.ORGANIZATION_NAME,
ORG.ORGANIZATION_NAME HDR_ORG,
LOC.LOCATION_CODE,
JHOU.CUSTOMS_WRITE_OFF_ACCOUNT,
LOC.ADDRESS_LINE_1,
LOC.ADDRESS_LINE_2,
LOC.ADDRESS_LINE_3,
GCC.CHART_OF_ACCOUNTS_ID
FROM
JAI_CMN_BOE_HDRS HDR,
JAI_CMN_BOE_WRITEOFFS WRT,
ORG_ORGANIZATION_DEFINITIONS ORG,
HR_LOCATIONS LOC,
JAI_CMN_INVENTORY_ORGS JHOU,
GL_CODE_COMBINATIONS GCC
WHERE HDR.BOE_ID = WRT.BOE_ID
AND HDR.ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND HDR.LOCATION_ID = LOC.LOCATION_ID
AND HDR.ORGANIZATION_ID = JHOU.ORGANIZATION_ID
AND HDR.LOCATION_ID = JHOU.LOCATION_ID
AND HDR.BOE_ID = NVL(P_BOE_NO
,HDR.BOE_ID)
AND HDR.BOE_TYPE = NVL(P_BOE_TYPE
,HDR.BOE_TYPE)
AND TRUNC(WRT.WRITE_OFF_DATE) BETWEEN TRUNC(P_START_DATE)
AND TRUNC(P_END_DATE)
AND GCC.CODE_COMBINATION_ID = JHOU.CUSTOMS_WRITE_OFF_ACCOUNT
ORDER BY
HDR.BOE_ID,
WRT.WRITE_OFF_DATE,
HDR.BOE_TYPE;
SELECT
CONCURRENT_PROGRAM_ID,
NVL(ENABLE_TRACE
,'N')
FROM
FND_CONCURRENT_REQUESTS
WHERE REQUEST_ID = P_REQUEST_ID;
INSERT INTO JAI_CMN_WRITEOFFS_T
(CUSTOMS_WRITE_OFF_ACCOUNT
,ADDRESS_LINE_1
,ADDRESS_LINE_2
,ADDRESS_LINE_3
,ORGANIZATION_NAME
,CHART_OF_ACCOUNTS_ID
,BOE_TYPE
,BOE_ID
,BOE_AMOUNT
,LOCATION_CODE
,AMOUNT_APPLIED
,WRITE_OFF_AMOUNT
,WRITE_OFF_DATE
,WRITE_OFF_REASON
,EARLIER_WRITTEN_OFF_AMOUNT
,CREATED_BY
,CREATION_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_DATE)
VALUES (I.CUSTOMS_WRITE_OFF_ACCOUNT
,I.ADDRESS_LINE_1
,I.ADDRESS_LINE_2
,I.ADDRESS_LINE_3
,I.ORGANIZATION_NAME
,I.CHART_OF_ACCOUNTS_ID
,I.BOE_TYPE
,I.BOE_ID
,I.BOE_AMOUNT
,I.LOCATION_CODE
,I.AMOUNT_APPLIED
,I.WRITE_OFF_AMOUNT
,I.WRITE_OFF_DATE
,I.WRITE_OFF_REASON
,V_EARLIER_WRITTEN_OFF_AMOUNT
,FND_GLOBAL.USER_ID
,SYSDATE
,FND_GLOBAL.USER_ID
,SYSDATE);
DELETE FROM JAI_CMN_WRITEOFFS_T;