[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;
SELECT
MIN(API2.INVOICE_DATE)
INTO P_FROM_DATE
FROM
JAI_AP_TDS_F16_HDRS_ALL AFRM,
JAI_AP_TDS_F16_DTLS_ALL FRMD,
HR_ORGANIZATION_UNITS HOU,
HR_LOCATIONS LOC,
JAI_CMN_INVENTORY_ORGS JHOU,
AP_INVOICES_ALL API1,
AP_INVOICES_ALL API2,
AP_INVOICE_PAYMENTS_ALL APIP,
PO_VENDORS POV1,
PO_VENDORS POV2,
PO_VENDOR_SITES_ALL POVS,
AP_INVOICE_LINES_ALL APLL
WHERE DECODE(AFRM.ORG_ID
,NULL
,0
,AFRM.ORG_ID) = NVL(P_ORGANIZATION_ID
,DECODE(AFRM.ORG_ID
,NULL
,0
,AFRM.ORG_ID))
AND AFRM.TDS_TAX_SECTION = P_TDS_PAYMENT_TYPE
AND FRMD.CERTIFICATE_NUM = AFRM.CERTIFICATE_NUM
AND AFRM.ORG_ID = hou.organization_id (+)
AND apll.invoice_id (+) = FRMD.TDS_INVOICE_ID
AND ( ( POV1.ORGANIZATION_TYPE_LOOKUP_CODE = P_SUPPLIER_ORG_TYPE
AND UPPER(P_SUPPLIER_ORG_TYPE) = LV_SUPP_TYPE_COMPANY )
OR ( POV1.ORGANIZATION_TYPE_LOOKUP_CODE <> P_SUPPLIER_ORG_TYPE
AND UPPER(P_SUPPLIER_ORG_TYPE) <> LV_SUPP_TYPE_COMPANY ) )
AND pov1.vendor_id (+) = AFRM.VENDOR_ID
AND povs.vendor_site_id (+) = AFRM.VENDOR_SITE_ID
AND povs.org_id (+) = AFRM.ORG_ID
AND api2.invoice_id (+) = FRMD.TDS_INVOICE_ID
AND api1.invoice_id (+) = FRMD.INVOICE_ID
AND apip.invoice_payment_id (+) = FRMD.INVOICE_PAYMENT_ID
AND jhou.organization_id (+) = HOU.ORGANIZATION_ID
AND HOU.LOCATION_ID = loc.location_id (+)
AND pov2.vendor_id (+) = AFRM.TAX_AUTHORITY_ID;
SELECT
SUM(AMOUNT)
FROM
AP_INVOICE_LINES_ALL
WHERE INVOICE_ID = INVOICE_ID1
AND LINE_TYPE_LOOKUP_CODE = CP_LINE_TYPE;