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;
SELECT
A.SID,
A.SERIAL#,
B.SPID
FROM
V$SESSION A,
V$PROCESS B
WHERE AUDSID = USERENV('SESSIONID')
AND A.PADDR = B.ADDR;
SELECT
NAME
FROM
V$DATABASE;
SELECT
*
FROM
JAI_CMN_RG_PERIOD_BALS
WHERE ORGANIZATION_ID = CP_ORGANIZATION_ID
AND LOCATION_ID = CP_LOCATION_ID
AND REGISTER_TYPE = CP_REGISTER_TYPE
AND CP_START_DATE BETWEEN START_DATE
AND END_DATE;
SELECT
*
FROM
JAI_CMN_RG_PERIOD_BALS
WHERE ORGANIZATION_ID = CP_ORGANIZATION_ID
AND LOCATION_ID = CP_LOCATION_ID
AND REGISTER_TYPE = CP_REGISTER_TYPE
AND ( START_DATE , END_DATE ) = (
SELECT
MAX(START_DATE),
MAX(END_DATE)
FROM
JAI_CMN_RG_PERIOD_BALS
WHERE ORGANIZATION_ID = CP_ORGANIZATION_ID
AND LOCATION_ID = CP_LOCATION_ID
AND REGISTER_TYPE = CP_REGISTER_TYPE );
SELECT
SUM(NVL(CREDIT
,0) - NVL(DEBIT
,0))
FROM
JAI_CMN_RG_23AC_II_TRXS A,
JAI_CMN_RG_OTHERS B
WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
AND LOCATION_ID = P_LOCATION_ID
AND REGISTER_TYPE = P_REGISTER_TYPE
AND TRUNC(A.CREATION_DATE) > CP_DELTA_START_DATE
AND TRUNC(A.CREATION_DATE) < P_TRN_FROM_DATE
AND A.REGISTER_ID = B.SOURCE_REGISTER_ID
AND B.SOURCE_TYPE = 1
AND B.TAX_TYPE = CP_TAX_TYPE;
SELECT
SUM(NVL(CR_BASIC_ED
,0) + NVL(CR_ADDITIONAL_ED
,0) + NVL(CR_ADDITIONAL_CVD
,0) + NVL(CR_OTHER_ED
,0) - NVL(DR_BASIC_ED
,0) - NVL(DR_ADDITIONAL_ED
,0) - NVL(DR_ADDITIONAL_CVD
,0) - NVL(DR_OTHER_ED
,0))
INTO LN_DELTA_AMOUNT
FROM
JAI_CMN_RG_23AC_II_TRXS
WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
AND LOCATION_ID = P_LOCATION_ID
AND REGISTER_TYPE = P_REGISTER_TYPE
AND TRUNC(CREATION_DATE) > LD_DELTA_START_DATE
AND TRUNC(CREATION_DATE) < P_TRN_FROM_DATE;
SELECT
B.NAME,
C.DESCRIPTION,
C.ADDRESS_LINE_1,
C.ADDRESS_LINE_2,
C.ADDRESS_LINE_3,
D.EXCISE_DUTY_RANGE,
D.EXCISE_DUTY_DIVISION,
D.EXCISE_DUTY_COMM,
D.EXCISE_DUTY_CIRCLE,
D.EC_CODE
FROM
JAI_CMN_INVENTORY_ORGS D,
HR_ALL_ORGANIZATION_UNITS B,
HR_LOCATIONS C
WHERE D.ORGANIZATION_ID = CP_ORGANIZATION_ID
AND D.LOCATION_ID = CP_LOCATION_ID
AND D.ORGANIZATION_ID = B.ORGANIZATION_ID
AND D.LOCATION_ID = C.LOCATION_ID;
SELECT
EXCISE_DUTY_DIVISION
FROM
JAI_CMN_INVENTORY_ORGS
WHERE ORGANIZATION_ID = ABS(VENDOR_ID)
AND LOCATION_ID = ABS(VENDOR_SITE_ID);
SELECT
DISTINCT
JU.EXCISE_DUTY_DIVISION
FROM
RCV_TRANSACTIONS RCVT,
RCV_SHIPMENT_HEADERS RCVSH,
JAI_CMN_INVENTORY_ORGS JU
WHERE RCVT.TRANSACTION_ID = P_RECEIPT_ID
AND RCVT.TRANSACTION_TYPE = CP_TRANSACTION_TYPE
AND RCVT.SHIPMENT_HEADER_ID = RCVSH.SHIPMENT_HEADER_ID
AND RCVSH.RECEIPT_SOURCE_CODE = CP_RCPT_SRC_CODE
AND RCVSH.ORGANIZATION_ID = JU.ORGANIZATION_ID;
SELECT
EXCISE_DUTY_RANGE
FROM
JAI_CMN_INVENTORY_ORGS
WHERE ORGANIZATION_ID = ABS(VENDOR_ID)
AND LOCATION_ID = ABS(VENDOR_SITE_ID);
SELECT
DISTINCT
JU.EXCISE_DUTY_RANGE
FROM
RCV_TRANSACTIONS RCVT,
RCV_SHIPMENT_HEADERS RCVSH,
JAI_CMN_INVENTORY_ORGS JU
WHERE RCVT.TRANSACTION_ID = P_RECEIPT_ID
AND RCVT.TRANSACTION_TYPE = CP_TRANSACTION_TYPE
AND RCVT.SHIPMENT_HEADER_ID = RCVSH.SHIPMENT_HEADER_ID
AND RCVSH.RECEIPT_SOURCE_CODE = CP_RCPT_SRC_CODE
AND RCVSH.ORGANIZATION_ID = JU.ORGANIZATION_ID;
SELECT
EC_CODE
FROM
JAI_CMN_VENDOR_SITES
WHERE VENDOR_ID = VENDOR_ID
AND VENDOR_SITE_ID = VENDOR_SITE_ID;
SELECT
EC_CODE
FROM
JAI_CMN_INVENTORY_ORGS
WHERE ORGANIZATION_ID = ABS(VENDOR_ID)
AND LOCATION_ID = ABS(VENDOR_SITE_ID);
SELECT
DISTINCT
JU.EC_CODE
FROM
RCV_TRANSACTIONS RCVT,
RCV_SHIPMENT_HEADERS RCVSH,
JAI_CMN_INVENTORY_ORGS JU
WHERE RCVT.TRANSACTION_ID = P_RECEIPT_ID
AND RCVT.TRANSACTION_TYPE = CP_TRANSACTION_TYPE
AND RCVT.SHIPMENT_HEADER_ID = RCVSH.SHIPMENT_HEADER_ID
AND RCVSH.RECEIPT_SOURCE_CODE = CP_RCPT_SRC_CODE
AND RCVSH.ORGANIZATION_ID = JU.ORGANIZATION_ID;
SELECT
EC_CODE
FROM
JAI_CMN_CUS_ADDRESSES
WHERE CUSTOMER_ID = CUSTOMER_ID_1
AND ADDRESS_ID = CUSTOMER_SITE_ID;
SELECT
COUNT(1)
FROM
JAI_CMN_RG_23AC_II_TRXS A
WHERE A.ORGANIZATION_ID = P_ORGANIZATION_ID
AND A.LOCATION_ID = P_LOCATION_ID
AND REGISTER_TYPE = P_REGISTER_TYPE
AND A.INVENTORY_ITEM_ID <> 0
AND REGISTER_ID = P_REGISTER_ID
AND TRUNC(CREATION_DATE) BETWEEN P_TRN_FROM_DATE
AND P_TRN_TO_DATE;
SELECT
NVL(DEBIT
,0) - NVL(CREDIT
,0)
FROM
JAI_CMN_RG_OTHERS
WHERE SOURCE_REGISTER_ID = CP_REGISTER_ID
AND SOURCE_TYPE = 1
AND TAX_TYPE = CP_TAX_TYPE;
SELECT
NVL(DEBIT
,0) - NVL(CREDIT
,0)
FROM
JAI_CMN_RG_OTHERS
WHERE SOURCE_REGISTER_ID = CP_REGISTER_ID
AND SOURCE_TYPE = 1
AND TAX_TYPE = CP_TAX_TYPE;
SELECT
TRANSACTION_TYPE,
PARENT_TRANSACTION_TYPE
FROM
JAI_RCV_TRANSACTIONS
WHERE TRANSACTION_ID = CP_TRANSACTION_ID;
FOR rnd_rec IN (SELECT
REGISTER_ID,
NVL(CR_BASIC_ED
,0) - NVL(DR_BASIC_ED
,0) AMOUNT,
NVL(CR_ADDITIONAL_ED
,0) - NVL(DR_ADDITIONAL_ED
,0) ADDITIONAL_AMOUNT,
NVL(CR_ADDITIONAL_CVD
,0) - NVL(DR_ADDITIONAL_CVD
,0) ADDITIONALCVD_AMOUNT,
NVL(CR_OTHER_ED
,0) - NVL(DR_OTHER_ED
,0) OTHER_AMOUNT
FROM
JAI_CMN_RG_23AC_II_TRXS
WHERE EXCISE_INVOICE_NO = CF_ROUNDING_AMOUNTFORMULA.EXCISE_INVOICE_NO
AND EXCISE_INVOICE_DATE = CF_ROUNDING_AMOUNTFORMULA.EXCISE_INVOICE_DATE
AND INVENTORY_ITEM_ID = 0
AND TRANSACTION_SOURCE_NUM = 18
AND REGISTER_TYPE = P_REGISTER_TYPE) LOOP
V_PARENT_INCLUDED_CNT := 0;
SELECT
REMARKS
FROM
JAI_CMN_RG_23AC_II_TRXS
WHERE ( EXCISE_INVOICE_NO IS NULL
OR EXCISE_INVOICE_NO = EXCISE_INVOICE_NO_1 )
AND ( EXCISE_INVOICE_DATE IS NULL
OR EXCISE_INVOICE_DATE = EXCISE_INVOICE_DATE_1 )
AND REGISTER_TYPE = P_REGISTER_TYPE
AND ORGANIZATION_ID = P_ORGANIZATION_ID
AND LOCATION_ID = P_LOCATION_ID
AND INVENTORY_ITEM_ID <> 0
AND RECEIPT_REF = CF_RECEIPT_NUMFORMULA.RECEIPT_ID
AND TRUNC(CREATION_DATE) between NVL(P_TRN_FROM_DATE
,TRUNC(CREATION_DATE))
AND NVL(P_TRN_TO_DATE
,TRUNC(CREATION_DATE))
AND TRANSACTION_SOURCE_NUM = CF_RECEIPT_NUMFORMULA.TRANSACTION_ID;
SELECT
RCV.RECEIPT_NUM
FROM
RCV_SHIPMENT_HEADERS RCV,
RCV_TRANSACTIONS RTRAN
WHERE rtran.transaction_id (+) = RECEIPT_ID
AND rcv.shipment_header_id (+) = RTRAN.SHIPMENT_HEADER_ID;
SELECT
RG23_1.INVENTORY_ITEM_ID || '-' || RG23_1.SLNO FOLIO
FROM
JAI_CMN_RG_23AC_II_TRXS RG23_2,
JAI_CMN_RG_23AC_I_TRXS RG23_1
WHERE RG23_2.ORGANIZATION_ID = P_ORGANIZATION_ID
AND RG23_2.LOCATION_ID = P_LOCATION_ID
AND RG23_2.EXCISE_INVOICE_NO = P_EXCISE_INVOICE_NO
AND RG23_2.EXCISE_INVOICE_DATE = P_EXCISE_INVOICE_DATE
AND rg23_2.register_id_part_i (+) = RG23_1.REGISTER_ID
AND RG23_2.INVENTORY_ITEM_ID = RG23_1.INVENTORY_ITEM_ID
AND RG23_2.INVENTORY_ITEM_ID <> 0
UNION
SELECT
(RG_1.INVENTORY_ITEM_ID || '-' || RG_1.SLNO) FOLIO
FROM
JAI_CMN_RG_23AC_II_TRXS RG23_2,
JAI_CMN_RG_I_TRXS RG_1
WHERE RG23_2.ORGANIZATION_ID = P_ORGANIZATION_ID
AND RG23_2.LOCATION_ID = P_LOCATION_ID
AND RG23_2.EXCISE_INVOICE_NO = P_EXCISE_INVOICE_NO
AND RG23_2.EXCISE_INVOICE_DATE = P_EXCISE_INVOICE_DATE
AND rg23_2.register_id_part_i (+) = RG_1.REGISTER_ID
AND RG23_2.INVENTORY_ITEM_ID = RG_1.INVENTORY_ITEM_ID
AND RG23_2.INVENTORY_ITEM_ID <> 0;
SELECT
SUM(NVL(CREDIT
,0))
FROM
JAI_CMN_RG_OTHERS
WHERE SOURCE_REGISTER = DECODE(P_REGISTER_TYPE
,'A'
,'RG23A_P2'
,'C'
,'RG23C_P2')
AND TAX_TYPE = CP_TAX_TYPE
AND SOURCE_REGISTER_ID IN (
SELECT
REGISTER_ID
FROM
JAI_CMN_RG_23AC_II_TRXS
WHERE ( ( EXCISE_INVOICE_NO IS NULL
AND EXCISE_INVOICE_NO IS NULL )
OR ( EXCISE_INVOICE_NO = EXCISE_INVOICE_NO_1 ) )
AND ( ( EXCISE_INVOICE_DATE IS NULL
AND EXCISE_INVOICE_DATE IS NULL )
OR ( EXCISE_INVOICE_DATE = EXCISE_INVOICE_DATE_1 ) )
AND ( ( VENDOR_ID IS NULL
AND VENDOR_ID IS NULL )
OR ( VENDOR_ID = VENDOR_ID_1 ) )
AND ( ( VENDOR_SITE_ID IS NULL
AND VENDOR_SITE_ID IS NULL )
OR ( VENDOR_SITE_ID = VENDOR_SITE_ID_1 ) )
AND ( ( CUSTOMER_ID IS NULL
AND CUSTOMER_ID IS NULL )
OR ( CUSTOMER_ID = CUSTOMER_ID_1 ) )
AND ( ( CUSTOMER_SITE_ID IS NULL
AND CUSTOMER_SITE_ID IS NULL )
OR ( CUSTOMER_SITE_ID = CUSTOMER_SITE_ID_1 ) )
AND REGISTER_TYPE = P_REGISTER_TYPE
AND ORGANIZATION_ID = P_ORGANIZATION_ID
AND LOCATION_ID = P_LOCATION_ID );
SELECT
SUM(NVL(CREDIT
,0))
FROM
JAI_CMN_RG_OTHERS
WHERE SOURCE_REGISTER = DECODE(P_REGISTER_TYPE
,'A'
,'RG23A_P2'
,'C'
,'RG23C_P2')
AND TAX_TYPE = CP_TAX_TYPE
AND SOURCE_REGISTER_ID IN (
SELECT
REGISTER_ID
FROM
JAI_CMN_RG_23AC_II_TRXS
WHERE ( ( EXCISE_INVOICE_NO IS NULL
AND EXCISE_INVOICE_NO IS NULL )
OR ( EXCISE_INVOICE_NO = EXCISE_INVOICE_NO_1 ) )
AND ( ( EXCISE_INVOICE_DATE IS NULL
AND EXCISE_INVOICE_DATE IS NULL )
OR ( EXCISE_INVOICE_DATE = EXCISE_INVOICE_DATE_1 ) )
AND ( ( VENDOR_ID IS NULL
AND VENDOR_ID IS NULL )
OR ( VENDOR_ID = VENDOR_ID_1 ) )
AND ( ( VENDOR_SITE_ID IS NULL
AND VENDOR_SITE_ID IS NULL )
OR ( VENDOR_SITE_ID = VENDOR_SITE_ID_1 ) )
AND ( ( CUSTOMER_ID IS NULL
AND CUSTOMER_ID IS NULL )
OR ( CUSTOMER_ID = CUSTOMER_ID_1 ) )
AND ( ( CUSTOMER_SITE_ID IS NULL
AND CUSTOMER_SITE_ID IS NULL )
OR ( CUSTOMER_SITE_ID = CUSTOMER_SITE_ID_1 ) )
AND REGISTER_TYPE = P_REGISTER_TYPE
AND ORGANIZATION_ID = P_ORGANIZATION_ID
AND LOCATION_ID = P_LOCATION_ID );
SELECT
REGISTER_ID
FROM
JAI_CMN_RG_23AC_II_TRXS
WHERE RECEIPT_REF = RECEIPT_ID;
SELECT
SUM(NVL(CREDIT
,0))
FROM
JAI_CMN_RG_OTHERS
WHERE SOURCE_REGISTER = DECODE(P_REGISTER_TYPE
,'A'
,'RG23A_P2'
,'C'
,'RG23C_P2')
AND TAX_TYPE = 'CVD_SH_EDU_CESS'
AND SOURCE_TYPE = 1
AND SOURCE_REGISTER_ID IN (
SELECT
REGISTER_ID
FROM
JAI_CMN_RG_23AC_II_TRXS
WHERE ( ( EXCISE_INVOICE_NO IS NULL
AND EXCISE_INVOICE_NO IS NULL )
OR ( EXCISE_INVOICE_NO = EXCISE_INVOICE_NO_1 ) )
AND ( ( EXCISE_INVOICE_DATE IS NULL
AND EXCISE_INVOICE_DATE IS NULL )
OR ( EXCISE_INVOICE_DATE = EXCISE_INVOICE_DATE_1 ) )
AND ( ( VENDOR_ID IS NULL
AND VENDOR_ID IS NULL )
OR ( VENDOR_ID = VENDOR_ID_1 ) )
AND ( ( VENDOR_SITE_ID IS NULL
AND VENDOR_SITE_ID IS NULL )
OR ( VENDOR_SITE_ID = VENDOR_SITE_ID_1 ) )
AND ( ( CUSTOMER_ID IS NULL
AND CUSTOMER_ID IS NULL )
OR ( CUSTOMER_ID = CUSTOMER_ID_1 ) )
AND ( ( CUSTOMER_SITE_ID IS NULL
AND CUSTOMER_SITE_ID IS NULL )
OR ( CUSTOMER_SITE_ID = CUSTOMER_SITE_ID_1 ) )
AND REGISTER_TYPE = P_REGISTER_TYPE
AND ORGANIZATION_ID = P_ORGANIZATION_ID
AND LOCATION_ID = P_LOCATION_ID
AND INVENTORY_ITEM_ID <> 0
AND TRUNC(CREATION_DATE) between NVL(P_TRN_FROM_DATE
,TRUNC(CREATION_DATE))
AND NVL(P_TRN_TO_DATE
,TRUNC(CREATION_DATE))
AND ( ( TRANSACTION_SOURCE_NUM IS NULL
AND TRANSACTION_ID IS NULL )
OR ( TRANSACTION_SOURCE_NUM = TRANSACTION_ID ) ) );
SELECT
SUM(NVL(CREDIT
,0))
FROM
JAI_CMN_RG_OTHERS
WHERE SOURCE_REGISTER = DECODE(P_REGISTER_TYPE
,'A'
,'RG23A_P2'
,'C'
,'RG23C_P2')
AND TAX_TYPE = 'EXCISE_SH_EDU_CESS'
AND SOURCE_TYPE = 1
AND SOURCE_REGISTER_ID IN (
SELECT
REGISTER_ID
FROM
JAI_CMN_RG_23AC_II_TRXS
WHERE ( ( EXCISE_INVOICE_NO IS NULL
AND EXCISE_INVOICE_NO IS NULL )
OR ( EXCISE_INVOICE_NO = EXCISE_INVOICE_NO_1 ) )
AND ( ( EXCISE_INVOICE_DATE IS NULL
AND EXCISE_INVOICE_DATE IS NULL )
OR ( EXCISE_INVOICE_DATE = EXCISE_INVOICE_DATE_1 ) )
AND ( ( VENDOR_ID IS NULL
AND VENDOR_ID IS NULL )
OR ( VENDOR_ID = VENDOR_ID_1 ) )
AND ( ( VENDOR_SITE_ID IS NULL
AND VENDOR_SITE_ID IS NULL )
OR ( VENDOR_SITE_ID = VENDOR_SITE_ID_1 ) )
AND ( ( CUSTOMER_ID IS NULL
AND CUSTOMER_ID IS NULL )
OR ( CUSTOMER_ID = CUSTOMER_ID_1 ) )
AND ( ( CUSTOMER_SITE_ID IS NULL
AND CUSTOMER_SITE_ID IS NULL )
OR ( CUSTOMER_SITE_ID = CUSTOMER_SITE_ID_1 ) )
AND REGISTER_TYPE = P_REGISTER_TYPE
AND ORGANIZATION_ID = P_ORGANIZATION_ID
AND LOCATION_ID = P_LOCATION_ID
AND INVENTORY_ITEM_ID <> 0
AND TRUNC(CREATION_DATE) between NVL(P_TRN_FROM_DATE
,TRUNC(CREATION_DATE))
AND NVL(P_TRN_TO_DATE
,TRUNC(CREATION_DATE))
AND ( ( TRANSACTION_SOURCE_NUM IS NULL
AND TRANSACTION_ID IS NULL )
OR ( TRANSACTION_SOURCE_NUM = TRANSACTION_ID ) ) );
SELECT
SUM(NVL(DEBIT
,0))
FROM
JAI_CMN_RG_OTHERS
WHERE SOURCE_REGISTER = DECODE(P_REGISTER_TYPE
,'A'
,'RG23A_P2'
,'C'
,'RG23C_P2')
AND TAX_TYPE = 'EXCISE_SH_EDU_CESS'
AND SOURCE_TYPE = 1
AND SOURCE_REGISTER_ID IN (
SELECT
REGISTER_ID
FROM
JAI_CMN_RG_23AC_II_TRXS
WHERE ( ( EXCISE_INVOICE_NO IS NULL
AND EXCISE_INVOICE_NO IS NULL )
OR ( EXCISE_INVOICE_NO = EXCISE_INVOICE_NO_1 ) )
AND ( ( EXCISE_INVOICE_DATE IS NULL
AND EXCISE_INVOICE_DATE IS NULL )
OR ( EXCISE_INVOICE_DATE = EXCISE_INVOICE_DATE_1 ) )
AND ( ( VENDOR_ID IS NULL
AND VENDOR_ID IS NULL )
OR ( VENDOR_ID = VENDOR_ID_1 ) )
AND ( ( VENDOR_SITE_ID IS NULL
AND VENDOR_SITE_ID IS NULL )
OR ( VENDOR_SITE_ID = VENDOR_SITE_ID_1 ) )
AND ( ( CUSTOMER_ID IS NULL
AND CUSTOMER_ID IS NULL )
OR ( CUSTOMER_ID = CUSTOMER_ID ) )
AND ( ( CUSTOMER_SITE_ID IS NULL
AND CUSTOMER_SITE_ID IS NULL )
OR ( CUSTOMER_SITE_ID = CUSTOMER_SITE_ID_1 ) )
AND REGISTER_TYPE = P_REGISTER_TYPE
AND ORGANIZATION_ID = P_ORGANIZATION_ID
AND LOCATION_ID = P_LOCATION_ID
AND INVENTORY_ITEM_ID <> 0
AND TRUNC(CREATION_DATE) between NVL(P_TRN_FROM_DATE
,TRUNC(CREATION_DATE))
AND NVL(P_TRN_TO_DATE
,TRUNC(CREATION_DATE))
AND ( ( TRANSACTION_SOURCE_NUM IS NULL
AND TRANSACTION_ID IS NULL )
OR ( TRANSACTION_SOURCE_NUM = TRANSACTION_ID ) ) );
SELECT
SUM(NVL(DEBIT
,0))
FROM
JAI_CMN_RG_OTHERS
WHERE SOURCE_REGISTER = DECODE(P_REGISTER_TYPE
,'A'
,'RG23A_P2'
,'C'
,'RG23C_P2')
AND TAX_TYPE = 'CVD_SH_EDU_CESS'
AND SOURCE_TYPE = 1
AND SOURCE_REGISTER_ID IN (
SELECT
REGISTER_ID
FROM
JAI_CMN_RG_23AC_II_TRXS
WHERE ( ( EXCISE_INVOICE_NO IS NULL
AND EXCISE_INVOICE_NO IS NULL )
OR ( EXCISE_INVOICE_NO = EXCISE_INVOICE_NO_1 ) )
AND ( ( EXCISE_INVOICE_DATE IS NULL
AND EXCISE_INVOICE_DATE IS NULL )
OR ( EXCISE_INVOICE_DATE = EXCISE_INVOICE_DATE_1 ) )
AND ( ( VENDOR_ID IS NULL
AND VENDOR_ID IS NULL )
OR ( VENDOR_ID = VENDOR_ID_1 ) )
AND ( ( VENDOR_SITE_ID IS NULL
AND VENDOR_SITE_ID IS NULL )
OR ( VENDOR_SITE_ID = VENDOR_SITE_ID ) )
AND ( ( CUSTOMER_ID IS NULL
AND CUSTOMER_ID IS NULL )
OR ( CUSTOMER_ID = CUSTOMER_ID_1 ) )
AND ( ( CUSTOMER_SITE_ID IS NULL
AND CUSTOMER_SITE_ID IS NULL )
OR ( CUSTOMER_SITE_ID = CUSTOMER_SITE_ID_1 ) )
AND REGISTER_TYPE = P_REGISTER_TYPE
AND ORGANIZATION_ID = P_ORGANIZATION_ID
AND LOCATION_ID = P_LOCATION_ID
AND INVENTORY_ITEM_ID <> 0
AND TRUNC(CREATION_DATE) between NVL(P_TRN_FROM_DATE
,TRUNC(CREATION_DATE))
AND NVL(P_TRN_TO_DATE
,TRUNC(CREATION_DATE))
AND ( ( TRANSACTION_SOURCE_NUM IS NULL
AND TRANSACTION_ID IS NULL )
OR ( TRANSACTION_SOURCE_NUM = TRANSACTION_ID ) ) );