[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
CURRENCY_CODE,
CURRENCY_CONVERSION_RATE,
TRANSACTION_TYPE,
PO_HEADER_ID
FROM
RCV_TRANSACTIONS
WHERE TRANSACTION_ID = PARENT_TRANSACTION_ID;
FOR po_rec IN (SELECT
CURRENCY_CODE,
RATE
FROM
PO_HEADERS_ALL
WHERE PO_HEADER_ID = V_PARENT_REC.PO_HEADER_ID) LOOP
RETURN PO_REC.CURRENCY_CODE;
SELECT
CURRENCY_CODE,
CURRENCY_CONVERSION_RATE,
TRANSACTION_TYPE,
PRIMARY_QUANTITY,
PO_HEADER_ID
FROM
RCV_TRANSACTIONS
WHERE TRANSACTION_ID = PARENT_TRANSACTION_ID;
FOR po_rec IN (SELECT
CURRENCY_CODE,
RATE
FROM
PO_HEADERS_ALL
WHERE PO_HEADER_ID = V_PARENT_REC.PO_HEADER_ID) LOOP
V_CURRENCY_CONVERSION_RATE := PO_REC.RATE;
FOR cr_rec IN (SELECT
JRTL.TAX_AMOUNT,
JRTL.TAX_TYPE,
JRTL.CURRENCY,
NVL(MOD_CR_PERCENTAGE
,0) MOD_CR_PERCENTAGE
FROM
JAI_RCV_LINE_TAXES JRTL,
JAI_CMN_TAXES_ALL JTC
WHERE SHIPMENT_LINE_ID = CF_2FORMULA.SHIPMENT_LINE_ID
AND NVL(MODVAT_FLAG
,'N') = 'Y'
AND JRTL.TAX_ID = JTC.TAX_ID) LOOP
IF CR_REC.CURRENCY <> CF_CURRENCY_CODE THEN
V_CONV_FACTOR := NVL(V_CURRENCY_CONVERSION_RATE
,1);
FOR loc_rec IN (SELECT
DESCRIPTION
FROM
HR_LOCATIONS
WHERE LOCATION_ID = cf_3formula.LOCATION_ID) LOOP
RETURN LOC_REC.DESCRIPTION;
FOR loc_rec IN (SELECT
COUNTRY
FROM
HR_LOCATIONS
WHERE LOCATION_ID = cf_4formula.LOCATION_ID) LOOP
RETURN LOC_REC.COUNTRY;
FOR loc_rec IN (SELECT
ADDRESS_LINE_1
FROM
HR_LOCATIONS
WHERE LOCATION_ID = CF_5FORMULA.LOCATION_ID) LOOP
RETURN LOC_REC.ADDRESS_LINE_1;
FOR loc_rec IN (SELECT
ADDRESS_LINE_2
FROM
HR_LOCATIONS
WHERE LOCATION_ID = CF_6FORMULA.LOCATION_ID) LOOP
RETURN LOC_REC.ADDRESS_LINE_2;
FOR loc_rec IN (SELECT
ADDRESS_LINE_3
FROM
HR_LOCATIONS
WHERE LOCATION_ID = CF_7FORMULA.LOCATION_ID) LOOP
RETURN LOC_REC.ADDRESS_LINE_3;
FOR item_rec IN (SELECT
ITEM_FOLIO
FROM
JAI_INV_ITM_SETUPS
WHERE ORGANIZATION_ID = ORGANIZATION_ID1
AND INVENTORY_ITEM_ID = CF_8FORMULA.INVENTORY_ITEM_ID) LOOP
RETURN ITEM_REC.ITEM_FOLIO;
FOR fetch_curr_code IN (SELECT
CURRENCY_CODE
FROM
GL_SETS_OF_BOOKS
WHERE SET_OF_BOOKS_ID in (
SELECT
SET_OF_BOOKS_ID
FROM
ORG_ORGANIZATION_DEFINITIONS
WHERE ORGANIZATION_ID = ORGANIZATION_ID1 )) LOOP
V_CURRENCY_CODE := FETCH_CURR_CODE.CURRENCY_CODE;
FOR fetch_org_name IN (SELECT
ORGANIZATION_NAME
FROM
ORG_ORGANIZATION_DEFINITIONS
WHERE ORGANIZATION_ID = ORGANIZATION_ID1) LOOP
V_ORGANIZATION_NAME := FETCH_ORG_NAME.ORGANIZATION_NAME;
SELECT
NVL(SUM(JRO.CREDIT)
,SUM(JRO.DEBIT))
FROM
JAI_CMN_RG_OTHERS JRO
WHERE JRO.SOURCE_REGISTER_ID IN (
SELECT
RG.REGISTER_ID
FROM
JAI_CMN_RG_PLA_TRXS RG
WHERE RG.REF_DOCUMENT_ID = TRANSACTION_ID
AND RG.ORGANIZATION_ID = ORGANIZATION_ID1
AND RG.TRANSACTION_SOURCE_NUM = 19
AND RG.LOCATION_ID = cf_cess_amountformula.LOCATION_ID )
AND JRO.SOURCE_TYPE = 2
AND JRO.TAX_TYPE IN ( LV_EXC_EDU_CESS , LV_CVD_EDU_CESS );
SELECT
NVL(SUM(JRO.CREDIT)
,SUM(JRO.DEBIT))
FROM
JAI_CMN_RG_OTHERS JRO
WHERE JRO.SOURCE_REGISTER_ID IN (
SELECT
RG.REGISTER_ID
FROM
JAI_CMN_RG_23AC_II_TRXS RG
WHERE RG.RECEIPT_REF = TRANSACTION_ID
AND RG.ORGANIZATION_ID = ORGANIZATION_ID1
AND RG.TRANSACTION_SOURCE_NUM = 18
AND RG.LOCATION_ID = cf_cess_amountformula.LOCATION_ID )
AND JRO.SOURCE_TYPE = 1
AND JRO.TAX_TYPE IN ( LV_EXC_EDU_CESS , LV_CVD_EDU_CESS );
SELECT
REGISTER_ID
FROM
JAI_CMN_RG_ROUND_HDRS
WHERE ROUNDING_ID = CP_ROUNDING_ID;
SELECT
- NVL(CR_BASIC_ED
,0) + NVL(DR_BASIC_ED
,0) BASIC_ED,
- NVL(CR_ADDITIONAL_ED
,0) + NVL(DR_ADDITIONAL_ED
,0) ADDITIONAL_ED,
- NVL(CR_OTHER_ED
,0) + NVL(DR_OTHER_ED
,0) OTHER_ED,
- NVL(CR_ADDITIONAL_CVD
,0) + NVL(DR_ADDITIONAL_CVD
,0) OTHER_ED
FROM
JAI_CMN_RG_23AC_II_TRXS
WHERE REGISTER_ID = CP_REGISTER_ID;
SELECT
- NVL(CR_BASIC_ED
,0) + NVL(DR_BASIC_ED
,0) BASIC_ED,
- NVL(CR_ADDITIONAL_ED
,0) + NVL(DR_ADDITIONAL_ED
,0) ADDITIONAL_ED,
- NVL(CR_OTHER_ED
,0) + NVL(DR_OTHER_ED
,0) OTHER_ED
FROM
JAI_CMN_RG_PLA_TRXS
WHERE REGISTER_ID = CP_REGISTER_ID;
SELECT
SUM(NVL(DEBIT
,0) - NVL(CREDIT
,0))
FROM
JAI_CMN_RG_OTHERS
WHERE SOURCE_REGISTER_ID = CP_REGISTER_ID
AND SOURCE_TYPE = CP_SOURCE_TYPE
AND TAX_TYPE in ( LV_EXC_EDU_CESS , LV_CVD_EDU_CESS );
SELECT
JIRT.VAT_INVOICE_NO,
JIRT.VAT_INVOICE_DATE
FROM
JAI_RCV_TRANSACTIONS JIRT
WHERE JIRT.TRANSACTION_ID = P_TRANSACTION_ID;
SELECT
NVL(SUM(JRO.CREDIT)
,SUM(JRO.DEBIT))
FROM
JAI_CMN_RG_OTHERS JRO
WHERE JRO.SOURCE_REGISTER_ID in (
SELECT
RG.REGISTER_ID
FROM
JAI_CMN_RG_PLA_TRXS RG
WHERE RG.REF_DOCUMENT_ID = TRANSACTION_ID
AND RG.ORGANIZATION_ID = ORGANIZATION_ID1
AND RG.TRANSACTION_SOURCE_NUM = 19
AND RG.LOCATION_ID = cf_sh_cess_amountformula.LOCATION_ID )
AND JRO.SOURCE_TYPE = 2
AND JRO.TAX_TYPE in ( 'EXCISE_SH_EDU_CESS' , 'CVD_SH_EDU_CESS' );
SELECT
NVL(SUM(JRO.CREDIT)
,SUM(JRO.DEBIT))
FROM
JAI_CMN_RG_OTHERS JRO
WHERE JRO.SOURCE_REGISTER_ID in (
SELECT
RG.REGISTER_ID
FROM
JAI_CMN_RG_23AC_II_TRXS RG
WHERE RG.RECEIPT_REF = TRANSACTION_ID
AND RG.ORGANIZATION_ID = ORGANIZATION_ID1
AND RG.TRANSACTION_SOURCE_NUM = 18
AND RG.LOCATION_ID = cf_sh_cess_amountformula.LOCATION_ID )
AND JRO.SOURCE_TYPE = 1
AND JRO.TAX_TYPE in ( 'EXCISE_SH_EDU_CESS' , 'CVD_SH_EDU_CESS' );