| SQL Id | SQL Text |
|---|
| 09k3ak8yazq84 | SELECT S.BASE_CURRENCY_CODE, :B1 , C.NAME, NVL(S.MULTI_CURRENCY_FLAG, 'N') FROM AP_SYSTEM_PARAMETERS S, FND_CURRENCIES_VL C WHERE C.CURRENCY_CODE = S.BASE_CURRENCY_CODE |
| 0b85w9vv0hbt1 | UPDATE WF_ITEM_ATTRIBUTE_VALUES SET TEXT_VALUE = :B4 WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND NAME = :B1 |
| 0d3t5pd9c06kx | SELECT NVL( SUM( NVL(EXTENDED_AMOUNT, 0 ) ), 0), NVL( SUM( NVL(EXTENDED_AMOUNT, 0 ) ), 0) FROM RA_CUSTOMER_TRX_LINES WHERE CUSTOMER_TRX_ID = :B2 AND LINE_TYPE = :B1 |
| 0ns9vs1ctqdsc | SELECT CUSTOMER_TRX_ID COL1, PAYMENT_SCHEDULE_ID COL2, DELINQUENCY_ID COL3, TRX_NUMBER COL4, ACCOUNT_NUMBER COL5, AMOUNT_DUE_ORIGINAL COL6, INVOICE_CURRENCY_CODE COL7, AMOUNT_DUE_REMAINING COL8, INVOICE_CURRENCY_CODE COL9, ACCTD_AMOUNT_DUE_REMAINING COL10, INVOICE_CURRENCY_CODE COL11, INVOICE_CURRENCY_CODE COL12, DAYS_PAST_DUE COL13, CUST_TRX_CLASS_NAME COL14, CUST_TRX_CLASS_CODE COL15, DUE_DATE COL16, TERMS_SEQUENCE_NUMBER COL17, TRX_DATE COL18, TRX_CREATION_DATE COL19, PARTY_SITE_NUMBER COL20, BILL_TO_LOCATION COL21, BILL_TO_ADDRESS COL22, CUST_TRX_TYPE_NAME COL23, CUST_TRX_STATUS_NAME COL24, AMOUNT_IN_DISPUTE COL25, INVOICE_CURRENCY_CODE COL26, DISPUTE_DATE COL27, NULL COL28, NULL COL29, STAGED_DUNNING_LEVEL COL30, PURCHASE_ORDER COL31, NULL COL32, CONS_INV_ID COL33, CONS_BILLING_NUMBER COL34, NULL COL35, NULL COL36, GL_DATE COL37, TERM_NAME COL38, COMMENTS COL39, PRIMARY_SALESREP_NAME COL40, decode(DEFAULT_PRINTING_OPTION, 'NOT', ARPT_SQL_FUNC_UTIL.get_lookup_meaning('YES/NO', 'Y'), '') COL41, ARPT_SQL_FUNC_UTIL.get_lookup_meaning('YES/NO', PRINTING_PENDING) COL42, DELINQUENCY_STATUS COL43, UWQ_STATUS COL44, OPERATING_UNIT COL45, DEL_STATUS_DSP COL46, UNPAID_REASON_MEANING COL47, RECEIVABLES_COMMENTS COL48, RECEIVABLES_INTERNAL_NOTES COL49, RECEIVABLES_SPL_INSTRUCTIONS COL50, ATTRIBUTE_CATEGORY COL51, ATTRIBUTE1 COL52, ATTRIBUTE2 COL53, ATTRIBUTE3 COL54, ATTRIBUTE4 COL55, ATTRIBUTE5 COL56, ATTRIBUTE6 COL57, ATTRIBUTE7 COL58, ATTRIBUTE8 COL59, ATTRIBUTE9 COL60, ATTRIBUTE10 COL61, ATTRIBUTE11 COL62, ATTRIBUTE12 COL63, ATTRIBUTE13 COL64, ATTRIBUTE14 COL65, ATTRIBUTE15 COL66, INTERFACE_HEADER_CONTEXT COL67, INTERFACE_HEADER_ATTRIBUTE1 COL68, INTERFACE_HEADER_ATTRIBUTE2 COL69, INTERFACE_HEADER_ATTRIBUTE3 COL70, INTERFACE_HEADER_ATTRIBUTE4 COL71, INTERFACE_HEADER_ATTRIBUTE5 COL72, INTERFACE_HEADER_ATTRIBUTE6 COL73, INTERFACE_HEADER_ATTRIBUTE7 COL74, INTERFACE_HEADER_ATTRIBUTE8 COL75, INTERFACE_HEADER_ATTRIBUTE9 COL76, INTERFACE_HEADER_ATTRIBUTE10 COL77, INTERFACE_HEADER_ATTRIBUTE11 COL78, INTERFACE_HEADER_ATTRIBUTE12 COL79, INTERFACE_HEADER_ATTRIBUTE13 COL80, INTERFACE_HEADER_ATTRIBUTE14 COL81, INTERFACE_HEADER_ATTRIBUTE15 COL82, GLOBAL_ATTRIBUTE_CATEGORY COL83, GLOBAL_ATTRIBUTE1 COL84, GLOBAL_ATTRIBUTE2 COL85, GLOBAL_ATTRIBUTE3 COL86, GLOBAL_ATTRIBUTE4 COL87, GLOBAL_ATTRIBUTE5 COL88, GLOBAL_ATTRIBUTE6 COL89, GLOBAL_ATTRIBUTE7 COL90, GLOBAL_ATTRIBUTE8 COL91, GLOBAL_ATTRIBUTE9 COL92, GLOBAL_ATTRIBUTE10 COL93, GLOBAL_ATTRIBUTE11 COL94, GLOBAL_ATTRIBUTE12 COL95, GLOBAL_ATTRIBUTE13 COL96, GLOBAL_ATTRIBUTE14 COL97, GLOBAL_ATTRIBUTE15 COL98, ORG_ID COL99, LEGAL_ENTITY_ID COL100, LEGAL_ENTITY_NAME COL101, NULL COL102 FROM IEX_TRANSACTIONS_V WHERE trunc(due_date) >= :B_DUE_DATE_LOW AND trunc(due_date) <= :B_DUE_DATE_HIGH AND customer_id = :B_CUSTOMER_ID AND cust_trx_class_code = :B_TRX_CLASS AND (delinquency_status in ('DELINQUENT', 'PREDELINQUENT') OR (delinquency_status IS NULL AND amount_due_remaining <> 0) OR (delinquency_status = 'CURRENT' AND amount_due_remaining <> 0)) AND (cust_trx_status_code = 'OP') ORDER BY COL16 DESC |
| 0qzp60c3d1prh | SELECT PROMPT FROM AP_EXPENSE_REPORT_PARAMS WHERE PARAMETER_ID = :B1 |
| 0wmwsjy9kd92f | SELECT PROFILE_OPTION_ID, APPLICATION_ID, SITE_ENABLED_FLAG , APP_ENABLED_FLAG , RESP_ENABLED_FLAG , USER_ENABLED_FLAG, ORG_ENABLED_FLAG , SERVER_ENABLED_FLAG, SERVERRESP_ENABLED_FLAG, HIERARCHY_TYPE, USER_CHANGEABLE_FLAG FROM FND_PROFILE_OPTIONS WHERE PROFILE_OPTION_NAME = :B1 AND START_DATE_ACTIVE <= SYSDATE AND NVL(END_DATE_ACTIVE, SYSDATE) >= SYSDATE |
| 1kjhvys1sd1sg | BEGIN fnd_msg_pub.initialize;AP_WEB_OA_MAINFLOW_PKG.OASubmitWorkflow(p_report_header_id => :1, p_preparer_id => :2, p_employee_id => :3, p_invoice_number => :4, p_reimb_curr => :5, p_cost_center => :6, p_purpose => :7, p_approver_id => :8, p_week_end_date => :9, p_workflow_appr_flag => :10, p_msg_count => :11);END; |
| 1rd31t40r4fu5 | BEGIN fnd_global.bless_next_init('FND_PERMIT_0006'); FND_GLOBAL.APPS_INITIALIZE( user_id=>:1 , resp_id=>:2 , resp_appl_id=>:3 , security_group_id=>:4 , server_id=>:5);END; |
| 1wr32ytknh1u9 | SELECT P.PID, S.PROCESS, P.SERIAL#, P.SPID FROM V$PROCESS P, V$SESSION S WHERE S.AUDSID = USERENV('SESSIONID') AND S.PADDR = P.ADDR |
| 2ksmubnmd5hmh | SELECT ROUND( ( (SUM( DECODE(PS.CLASS, 'INV', 1, 'DM', 1, 'CB', 1, 'DEP', 1, 'BR', 1, 0) * PS.ACCTD_AMOUNT_DUE_REMAINING ) * MAX(SP.CER_DSO_DAYS) ) / DECODE( SUM( DECODE(PS.CLASS, 'INV', 1, 'DM', 1, 'DEP', 1, 0) * DECODE(SIGN (TRUNC(SYSDATE) - PS.TRX_DATE - SP.CER_DSO_DAYS), -1, (PS.AMOUNT_DUE_ORIGINAL + NVL(PS.AMOUNT_ADJUSTED, 0)) * NVL(PS.EXCHANGE_RATE, 1 ), 0)) , 0, 1, SUM( DECODE(PS.CLASS, 'INV', 1, 'DM', 1, 'DEP', 1, 0) * DECODE(SIGN (TRUNC(SYSDATE) - PS.TRX_DATE - SP.CER_DSO_DAYS), -1, (PS.AMOUNT_DUE_ORIGINAL + NVL(PS.AMOUNT_ADJUSTED, 0)) * NVL(PS.EXCHANGE_RATE, 1 ), 0) ) ) ), 0) FROM AR_SYSTEM_PARAMETERS SP, AR_PAYMENT_SCHEDULES PS WHERE PS.CUSTOMER_ID = :B1 AND NVL(PS.RECEIPT_CONFIRMED_FLAG, 'Y') = 'Y' AND PS.ORG_ID=SP.ORG_ID |
| 3qqtuw5h6wvf0 |
SELECT * FROM (SELECT AI.DESCRIPTION PURPOSE, AI.INVOICE_CURRENCY_CODE CURRENCY_CODE, AI.INVOICE_DATE REPORT_DATE, AERH.REPORT_SUBMITTED_DATE REPORT_SUBMITTED_DATE, AI.INVOICE_NUM REPORT_NUMBER, TO_CHAR(decode(nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0), 0, decode(AI.CANCELLED_DATE, null, APS.GROSS_AMOUNT, AERH.TOTAL), nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0)) , FND_CURRENCY_CACHE.GET_FORMAT_MASK (AI.INVOICE_CURRENCY_CODE, 30)) ||' '|| AI.INVOICE_CURRENCY_CODE REPORT_TOTAL_CURRENCY, TO_CHAR(decode(nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0), 0, decode(AI.CANCELLED_DATE, null, APS.GROSS_AMOUNT, AERH.TOTAL), nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0)) , FND_CURRENCY_CACHE.GET_FORMAT_MASK (AI.INVOICE_CURRENCY_CODE, 30)) REPORT_TOTAL, P.PERSON_ID EMPLOYEE_ID, AERH.REPORT_HEADER_ID REPORT_HEADER_ID, P.FULL_NAME FULL_NAME , DECODE(AI.CANCELLED_DATE, null, nvl(aerh.expense_status_code, DECODE(APS.GROSS_AMOUNT , 0, 'PAID', decode(AI.Payment_status_flag, 'Y', 'PAID', 'N', 'INVOICED', 'P', 'PARPAID', NULL))), 'CANCELLED') STATUS_CODE, AERH.source SOURCE, NULL CURRENT_APPROVER, ROUND(sysdate - AI.LAST_UPDATE_DATE) DAYS_SINCE_ACTIVITY, AERH.RECEIPTS_STATUS RECEIPTS_STATUS_CODE, AERH.HOLDING_REPORT_HEADER_ID, AI.VENDOR_ID VENDOR_ID, AERH.AMT_DUE_CCARD_COMPANY AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_EMPLOYEE AMT_DUE_EMPLOYEE, 'CurrentApproverName' CURRENT_APPROVER_SWITCHER, to_char(AERH.LAST_UPDATE_DATE, 'DD-MON-RRRR HH:MI:SS'), AI.INVOICE_ID INVOICE_ID, AERH.IMAGE_RECEIPTS_STATUS IMAGE_RECEIPTS_STATUS_CODE FROM AK_WEB_USER_SEC_ATTR_VALUES A, PO_VENDORS PV, AP_INVOICES AI, AP_EXPENSE_REPORT_HEADERS AERH, PER_PEOPLE_X P, AP_PAYMENT_SCHEDULES APS WHERE AI.INVOICE_ID= APS.INVOICE_ID AND AI.INVOICE_ID = AERH.VOUCHNO AND AI.INVOICE_TYPE_LOOKUP_CODE||'' = 'EXPENSE REPORT' AND AI.SOURCE in ('XpenseXpress', 'SelfService', 'CREDIT CARD', 'Both Pay') AND A.ATTRIBUTE_CODE = 'ICX_HR_PERSON_ID' AND PV.EMPLOYEE_ID = A.NUMBER_VALUE AND A.WEB_USER_ID = :1 AND P.PERSON_ID = PV.EMPLOYEE_ID AND PV.VENDOR_ID = AI.VENDOR_ID AND DECODE (AI.PAYMENT_STATUS_FLAG, 'Y', sysdate - AI.LAST_UPDATE_DATE, decode(APS.GROSS_AMOUNT , 0 , sysdate - AI.LAST_UPDATE_DATE, 0) ) <= 30 AND (AERH.SOURCE <> 'Both Pay' OR AERH.REPORT_HEADER_ID IS NULL) UNION SELECT AI.DESCRIPTION PURPOSE, AI.INVOICE_CURRENCY_CODE CURRENCY_CODE, AI.INVOICE_DATE REPORT_DATE, AERH.REPORT_SUBMITTED_DATE REPORT_SUBMITTED_DATE, AI.INVOICE_NUM REPORT_NUMBER, TO_CHAR(decode(nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0), 0, decode(AI.CANCELLED_DATE, null, APS.GROSS_AMOUNT, AERH.TOTAL), nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0)) , FND_CURRENCY_CACHE.GET_FORMAT_MASK (AI.INVOICE_CURRENCY_CODE, 30)) ||' '|| AI.INVOICE_CURRENCY_CODE REPORT_TOTAL_CURRENCY, TO_CHAR(decode(nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0), 0, decode(AI.CANCELLED_DATE, null, APS.GROSS_AMOUNT, AERH.TOTAL), nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0)), FND_CURRENCY_CACHE.GET_FORMAT_MASK (AI.INVOICE_CURRENCY_CODE, 30)) REPORT_TOTAL, P.PERSON_ID EMPLOYEE_ID, AERH.REPORT_HEADER_ID REPORT_HEADER_ID, P.FULL_NAME FULL_NAME , DECODE(AI.C
ANCELLED_DATE, null, nvl(aerh.expense_status_code, DECODE(APS.GROSS_AMOUNT , 0, 'PAID', decode(AI.Payment_status_flag, 'Y', 'PAID', 'N', 'INVOICED', 'P', 'PARPAID', NULL))), 'CANCELLED') STATUS_CODE, AERH.source SOURCE, NULL CURRENT_APPROVER, ROUND(sysdate - AI.LAST_UPDATE_DATE) DAYS_SINCE_ACTIVITY, AERH.RECEIPTS_STATUS RECEIPTS_STATUS_CODE, AERH.HOLDING_REPORT_HEADER_ID, AI.VENDOR_ID VENDOR_ID, AERH.AMT_DUE_CCARD_COMPANY AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_EMPLOYEE AMT_DUE_EMPLOYEE, 'CurrentApproverName' CURRENT_APPROVER_SWITCHER, to_char(AERH.LAST_UPDATE_DATE, 'DD-MON-RRRR HH:MI:SS'), AI.INVOICE_ID INVOICE_ID, AERH.IMAGE_RECEIPTS_STATUS IMAGE_RECEIPTS_STATUS_CODE FROM AK_WEB_USER_SEC_ATTR_VALUES A, PO_VENDORS PV, AP_INVOICES AI, AP_EXPENSE_REPORT_HEADERS AERH, PER_PEOPLE_X P, AP_PAYMENT_SCHEDULES APS WHERE AI.INVOICE_ID= APS.INVOICE_ID AND AI.INVOICE_ID = AERH.VOUCHNO AND AI.INVOICE_TYPE_LOOKUP_CODE||'' in ('STANDARD', 'MIXED', 'PAYMENT REQUEST') AND AI.SOURCE IN ('SelfService', 'Both Pay', 'CREDIT CARD') AND A.ATTRIBUTE_CODE = 'ICX_HR_PERSON_ID' AND AI.PAID_ON_BEHALF_EMPLOYEE_ID = A.NUMBER_VALUE AND A.WEB_USER_ID = :2 AND P.PERSON_ID = AI.PAID_ON_BEHALF_EMPLOYEE_ID AND PV.VENDOR_ID = AI.VENDOR_ID AND DECODE (AI.PAYMENT_STATUS_FLAG, 'Y', sysdate - AI.LAST_UPDATE_DATE, decode(APS.GROSS_AMOUNT , 0 , sysdate - AI.LAST_UPDATE_DATE, 0) ) <= 30 AND (AERH.SOURCE <> 'Both Pay' OR AERH.REPORT_HEADER_ID IS NULL) UNION ALL SELECT AERH.DESCRIPTION PURPOSE, AERH.DEFAULT_CURRENCY_CODE CURRENCY_CODE, AERH.WEEK_END_DATE REPORT_DATE, AERH.REPORT_SUBMITTED_DATE REPORT_SUBMITTED_DATE, AERH.INVOICE_NUM REPORT_NUMBER, TO_CHAR(nvl(AERH.AMT_DUE_CCARD_COMPANY+AERH.AMT_DUE_EMPLOYEE+nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0), AERH.TOTAL), FND_CURRENCY_CACHE.GET_FORMAT_MASK (AERH.DEFAULT_CURRENCY_CODE, 30)) ||' '|| AERH.DEFAULT_CURRENCY_CODE REPORT_TOTAL_CURRENCY, TO_CHAR(nvl(AERH.AMT_DUE_CCARD_COMPANY+AERH.AMT_DUE_EMPLOYEE+nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0), AERH.TOTAL), FND_CURRENCY_CACHE.GET_FORMAT_MASK (AERH.DEFAULT_CURRENCY_CODE, 30)) REPORT_TOTAL, PER_EMPLOYEE.PERSON_ID EMPLOYEE_ID, AERH.REPORT_HEADER_ID REPORT_HEADER_ID, PER_EMPLOYEE.FULL_NAME FULL_NAME, NVL(AERH.expense_status_code, AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode(AERH.Source, AERH.Workflow_approved_flag, AERH.report_header_id, 'Y', 'N')) STATUS_CODE, AERH.source SOURCE, NVL (PER_APPROVER.full_name, AP_WEB_OA_ACTIVE_PKG.GetCurrentApprover(AERH.Source, AERH.Workflow_approved_flag, AERH.report_header_id, AERH.expense_status_code)) CURRENT_APPROVER, ROUND(NVL(sysdate - AERH.EXPENSE_LAST_STATUS_DATE, sysdate - AERH.LAST_UPDATE_DATE)) DAYS_SINCE_ACTIVITY, AERH.RECEIPTS_STATUS RECEIPTS_STATUS_CODE, AERH.HOLDING_REPORT_HEADER_ID, 0 VENDOR_ID, AERH.AMT_DUE_CCARD_COMPANY AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_EMPLOYEE AMT_DUE_EMPLOYEE, DECODE(AERH.expense_current_approver_id, -99999, 'AMEMultipleApprovers', decode(PER_APPROVER.full_name, null, 'CurrentApproverName', 'AMESingleApprover')) CURRENT_APPROVER_SWITCHER, to_char(AERH.LAST_UPDATE_DATE, 'DD-MON-RRRR HH:MI:SS'), -1 INVOICE_ID, AERH.IMAGE_RECEIPTS_STATUS IMAGE_RECEIPTS_STATUS_CODE FROM AK_WEB_USER_SEC_ATTR_VALUES A, AP_EXPENSE_REPORT_HEADERS AERH, PER_PEOPLE_X PER_EMPLOYEE, PER_PEOPLE_X PER_APPROVER WHERE AERH.VOUCHNO +0 =0 AND A.ATTRIBUTE_CODE = 'ICX_HR_PERSON_ID' AND AERH.EMPLOYEE_ID = A.NUMBER_VALUE AND A.WEB_USER_ID = :3 AND PER_EMPLOYEE.PERSON_ID = AERH.EMPLOYEE_ID AND (AERH.Source <> 'NonValidatedWebExpense' OR AERH.Workflow_approved_flag IS NULL) AND AERH.expense_current_approver_id = PER_APPROVER.person_id (+) AND DECODE(AERH.expense_status_code, 'PAID', ROUND(NVL(sysdate - AERH.EXPENSE_LAST_STATUS_DATE, sysdate - AERH.LAST_UPDATE_DATE)), 30) <= 30 AND AERH.SOURCE <> 'Both Pay' UNION SELECT AERH.DESCRIPTION PURPOSE, AERH.DEFAULT_CURRENCY_CODE CURRENCY_CODE, AERH.WEEK_END_DATE REPORT_DATE, AERH.REPORT_SUBMITTED_DATE REPORT_SUBMITTED_DATE, AER
H.INVOICE_NUM REPORT_NUMBER, TO_CHAR(nvl(AERH.AMT_DUE_CCARD_COMPANY+AERH.AMT_DUE_EMPLOYEE+nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0), AERH.TOTAL), FND_CURRENCY_CACHE.GET_FORMAT_MASK (AERH.DEFAULT_CURRENCY_CODE, 30)) ||' '|| AERH.DEFAULT_CURRENCY_CODE REPORT_TOTAL_CURRENCY, TO_CHAR(nvl(AERH.AMT_DUE_CCARD_COMPANY+AERH.AMT_DUE_EMPLOYEE+nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0), AERH.TOTAL), FND_CURRENCY_CACHE.GET_FORMAT_MASK (AERH.DEFAULT_CURRENCY_CODE, 30)) REPORT_TOTAL, PER_EMPLOYEE.PERSON_ID EMPLOYEE_ID, AERH.REPORT_HEADER_ID REPORT_HEADER_ID, PER_EMPLOYEE.FULL_NAME FULL_NAME, NVL(AERH.expense_status_code, AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode(AERH.Source, AERH.Workflow_approved_flag, AERH.report_header_id, 'Y', 'N')) STATUS_CODE, AERH.source SOURCE, NVL (PER_APPROVER.full_name, AP_WEB_OA_ACTIVE_PKG.GetCurrentApprover(AERH.Source, AERH.Workflow_approved_flag, AERH.report_header_id, AERH.expense_status_code)) CURRENT_APPROVER, ROUND(NVL(sysdate - AERH.EXPENSE_LAST_STATUS_DATE, sysdate - AERH.LAST_UPDATE_DATE)) DAYS_SINCE_ACTIVITY, AERH.RECEIPTS_STATUS RECEIPTS_STATUS_CODE, AERH.HOLDING_REPORT_HEADER_ID, 0 VENDOR_ID, AERH.AMT_DUE_CCARD_COMPANY AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_EMPLOYEE AMT_DUE_EMPLOYEE, DECODE(AERH.expense_current_approver_id, -99999, 'AMEMultipleApprovers', decode(PER_APPROVER.full_name, null, 'CurrentApproverName', 'AMESingleApprover')) CURRENT_APPROVER_SWITCHER, to_char(AERH.LAST_UPDATE_DATE, 'DD-MON-RRRR HH:MI:SS'), -1 INVOICE_ID, AERH.IMAGE_RECEIPTS_STATUS IMAGE_RECEIPTS_STATUS_CODE FROM AK_WEB_USER_SEC_ATTR_VALUES A, AP_EXPENSE_REPORT_HEADERS AERH, PER_PEOPLE_X PER_EMPLOYEE, PER_PEOPLE_X PER_APPROVER WHERE AERH.VOUCHNO +0=0 AND A.ATTRIBUTE_CODE = 'ICX_HR_PERSON_ID' AND AERH.PAID_ON_BEHALF_EMPLOYEE_ID = A.NUMBER_VALUE AND A.WEB_USER_ID = :4 AND PER_EMPLOYEE.PERSON_ID = PAID_ON_BEHALF_EMPLOYEE_ID AND AERH.EMPLOYEE_ID IS NULL AND (AERH.Source <> 'NonValidatedWebExpense' OR AERH.Workflow_approved_flag IS NULL) AND AERH.expense_current_approver_id = PER_APPROVER.person_id (+) AND DECODE(AERH.expense_status_code, 'PAID', ROUND(NVL(sysdate - AERH.EXPENSE_LAST_STATUS_DATE, sysdate - AERH.LAST_UPDATE_DATE)), 30) <= 30 AND AERH.SOURCE <> 'Both Pay' UNION ALL /* This select is for invoice imported reports by contingent workers */ SELECT AI.DESCRIPTION PURPOSE, AI.INVOICE_CURRENCY_CODE CURRENCY_CODE, AI.INVOICE_DATE REPORT_DATE, AERH.REPORT_SUBMITTED_DATE REPORT_SUBMITTED_DATE, AI.INVOICE_NUM REPORT_NUMBER, TO_CHAR(decode(nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0), 0, decode(AI.CANCELLED_DATE, null, APS.GROSS_AMOUNT, AERH.TOTAL), nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0)) , FND_CURRENCY_CACHE.GET_FORMAT_MASK (AI.INVOICE_CURRENCY_CODE, 30)) ||' '|| AI.INVOICE_CURRENCY_CODE REPORT_TOTAL_CURRENCY, TO_CHAR(decode(nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0), 0, decode(AI.CANCELLED_DATE, null, APS.GROSS_AMOUNT, AERH.TOTAL), nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0)) , FND_CURRENCY_CACHE.GET_FORMAT_MASK (AI.INVOICE_CURRENCY_CODE, 30)) REPORT_TOTAL, P.PERSON_ID EMPLOYEE_ID, AERH.REPORT_HEADER_ID REPORT_HEADER_ID, P.FULL_NAME FULL_NAME , DECODE(AI.CANCELLED_DATE, null, nvl(aerh.expense_status_code, DECODE(APS.GROSS_AMOUNT , 0, 'PAID', decode(AI.Payment_status_flag, 'Y', 'PAID', 'N', 'INVOICED', 'P', 'PARPAID', NULL))), 'CANCELLED') STATUS_CODE, AERH.source SOURCE, NULL CURRENT_APPROVER, ROUND(sysdate - AI.LAST_UPDATE_DATE) DAYS_SINCE_ACTIVITY, AERH.RECEIPTS_STATUS RECEIPTS_STATUS_CODE, AERH.HOLDING_REPORT_HEADER_ID, AI.VENDOR_ID V
ENDOR_ID, AERH.AMT_DUE_CCARD_COMPANY AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_EMPLOYEE AMT_DUE_EMPLOYEE, 'CurrentApproverName' CURRENT_APPROVER_SWITCHER, to_char(AERH.LAST_UPDATE_DATE, 'DD-MON-RRRR HH:MI:SS'), AI.INVOICE_ID INVOICE_ID, AERH.IMAGE_RECEIPTS_STATUS IMAGE_RECEIPTS_STATUS_CODE FROM AK_WEB_USER_SEC_ATTR_VALUES A, AP_INVOICES AI, AP_EXPENSE_REPORT_HEADERS AERH, PER_PEOPLE_X P, AP_PAYMENT_SCHEDULES APS WHERE AI.INVOICE_ID= APS.INVOICE_ID AND AI.INVOICE_ID = AERH.VOUCHNO AND AI.INVOICE_TYPE_LOOKUP_CODE||'' = 'EXPENSE REPORT' AND AI.SOURCE in ('XpenseXpress', 'SelfService', 'CREDIT CARD', 'Both Pay') AND A.ATTRIBUTE_CODE = 'ICX_HR_PERSON_ID' AND AI.PAID_ON_BEHALF_EMPLOYEE_ID = A.NUMBER_VALUE AND A.WEB_USER_ID = :5 AND P.PERSON_ID = AI.PAID_ON_BEHALF_EMPLOYEE_ID AND AP_WEB_DB_HR_INT_PKG.IsPersonCwk(AI.PAID_ON_BEHALF_EMPLOYEE_ID)='Y' AND DECODE (AI.PAYMENT_STATUS_FLAG, 'Y', sysdate - AI.LAST_UPDATE_DATE, decode(APS.GROSS_AMOUNT , 0 , sysdate - AI.LAST_UPDATE_DATE, 0) ) <= 30 AND (AERH.SOURCE <> 'Both Pay' OR AERH.REPORT_HEADER_ID IS NULL)) QRSLT ORDER BY REPORT_SUBMITTED_DATE DESC |
| 3vy5h9xkfv1s5 | INSERT INTO WF_ITEM_ATTRIBUTE_VALUES ( ITEM_TYPE, ITEM_KEY, NAME, TEXT_VALUE, NUMBER_VALUE, DATE_VALUE ) SELECT :B1 , :B2 , WIA.NAME, WIA.TEXT_DEFAULT, WIA.NUMBER_DEFAULT, WIA.DATE_DEFAULT FROM WF_ITEM_ATTRIBUTES WIA WHERE WIA.ITEM_TYPE = :B1 |
| 4ygjza9x62zmh | SELECT L.POLICY_LINE_ID FROM AP_POL_HEADERS H, AP_POL_LINES L, AP_POL_SCHEDULE_PERIODS SP, AP_SYSTEM_PARAMETERS SYS, AP_POL_EXRATE_OPTIONS RATE_OPTS, AP_EXPENSE_REPORT_PARAMS_ALL P WHERE P.PARAMETER_ID = :B4 AND H.POLICY_ID = P.COMPANY_POLICY_ID AND H.CATEGORY_CODE <> 'MILEAGE' AND H.CATEGORY_CODE <> 'PER_DIEM' AND :B1 BETWEEN H.START_DATE AND NVL(H.END_DATE, TO_DATE('31-12-4712', 'DD-MM-YYYY')) AND L.POLICY_ID = H.POLICY_ID AND L.STATUS = 'ACTIVE' AND L.SCHEDULE_PERIOD_ID = SP.SCHEDULE_PERIOD_ID AND :B1 BETWEEN SP.START_DATE AND NVL(SP.END_DATE, TO_DATE('31-12-4712', 'DD-MM-YYYY')) AND SYS.ORG_ID = RATE_OPTS.ORG_ID(+) AND (NVL(H.EMPLOYEE_ROLE_FLAG, 'N') = 'N' OR L.ROLE_ID = NVL((SELECT ROLE_ID FROM AP_POL_SCHEDULE_OPTIONS WHERE POLICY_ID = H.POLICY_ID AND OPTION_TYPE = 'EMPLOYEE_ROLE' AND STATUS = 'ACTIVE' AND (END_DATE IS NULL OR END_DATE >= :B1 ) AND ROLE_ID = DECODE(H.ROLE_CODE, 'JOB_GROUP', :B7 , 'POSITION', :B6 , 'GRADE', :B5 , -1)), -1)) AND (NVL(H.LOCATION_FLAG, 'N') = 'N' OR L.LOCATION_ID = :B3 ) AND ( (H.CATEGORY_CODE = 'AIRFARE') OR (L.CURRENCY_CODE = :B2 ) OR (NVL(H.ALLOW_RATE_CONVERSION_CODE, 'NO_CONVERSION') = 'NO_CONVERSION' AND H.CURRENCY_CODE = :B2 ) OR (H.CURRENCY_PREFERENCE = 'SRC' AND H.ALLOW_RATE_CONVERSION_CODE = 'ALLOW_CONVERSION' AND ('Y' = GL_CURRENCY_API.RATE_EXISTS(:B2 , L.CURRENCY_CODE, :B1 , RATE_OPTS.EXCHANGE_RATE_TYPE) OR ('Y' = GL_CURRENCY_API.RATE_EXISTS(:B2 , SYS.BASE_CURRENCY_CODE, :B1 , RATE_OPTS.EXCHANGE_RATE_TYPE) AND 'Y' = GL_CURRENCY_API.RATE_EXISTS(SYS.BASE_CURRENCY_CODE, L.CURRENCY_CODE, :B1 , RATE_OPTS.EXCHANGE_RATE_TYPE))) ) OR (NVL(H.CURRENCY_PREFERENCE, 'LCR') = 'LCR' AND ('Y' = GL_CURRENCY_API.RATE_EXISTS(:B2 , L.CURRENCY_CODE, :B1 , RATE_OPTS.EXCHANGE_RATE_TYPE) OR ('Y' = GL_CURRENCY_API.RATE_EXISTS(:B2 , SYS.BASE_CURRENCY_CODE, :B1 , RATE_OPTS.EXCHANGE_RATE_TYPE) AND 'Y' = GL_CURRENCY_API.RATE_EXISTS(SYS.BASE_CURRENCY_CODE, L.CURRENCY_CODE, :B1 , RATE_OPTS.EXCHANGE_RATE_TYPE))) ) ) AND (H.CATEGORY_CODE <> 'ACCOMMODATIONS' OR L.START_OF_SEASON IS NULL OR L.END_OF_SEASON IS NULL OR 'Y' = AP_WEB_POLICY_UTILS.ISDATEINSEASON(:B1 , L.START_OF_SEASON, L.END_OF_SEASON)) AND L.PARENT_LINE_ID IS NULL AND :B1 BETWEEN NVL(L.EFFECTIVE_START_DATE, :B1 ) AND NVL(L.EFFECTIVE_END_DATE, :B1 +1) |
| 592madzz61k01 | WITH a as (SELECT a$.dbid, a$.snap_id, a$.INSTANCE_NUMBER, a$.PLSQL_ENTRY_OBJECT_ID, a$.PLSQL_ENTRY_SUBPROGRAM_ID, a$.TIME_MODEL FROM WRH$_ACTIVE_SESSION_HISTORY a$ WHERE a$.dbid = :dbid AND a$.instance_number = :inst AND a$.snap_id > :bid AND a$.snap_id <= :eid AND a$.session_type = 1 ) , ash as (SELECT cnt , PLSQL_ENTRY_OBJECT_ID, PLSQL_ENTRY_SUBPROGRAM_ID FROM ( SELECT count(*) as cnt , a.PLSQL_ENTRY_OBJECT_ID, a.PLSQL_ENTRY_SUBPROGRAM_ID FROM a WHERE bitand(a.time_model, power(2, 11 )) !=0 AND a.PLSQL_ENTRY_OBJECT_ID > 0 AND a.PLSQL_ENTRY_SUBPROGRAM_ID > 0 GROUP BY PLSQL_ENTRY_OBJECT_ID, PLSQL_ENTRY_SUBPROGRAM_ID HAVING count(*) >= :rowcnt ORDER BY 1 DESC, 2 ASC ) WHERE rownum <= :ret) SELECT ash.plsql_entry_object_id, ash.plsql_entry_subprogram_id, dba.object_name, dba.object_type, dba.owner, dba.procedure_name, to_number(dba.overload), ash.cnt FROM dba_procedures dba, ash WHERE ash.plsql_entry_object_id = dba.object_id(+) AND ash.plsql_entry_subprogram_id = dba.subprogram_id(+) ORDER BY ash.cnt DESC, ash.plsql_entry_object_id, ash.plsql_entry_subprogram_id |
| 5c8xj742thhyr | SELECT BUSINESS_GROUP_ID FROM PA_IMPLEMENTATIONS |
| 5kdm5kp8va5w0 | SELECT * FROM (SELECT AP_WEB_DB_CCARD_PKG.GetLocation(merchant_city , merchant_province_state) AS LOCATION, ApCreditCardTrxnsAll.TRX_ID, ApCreditCardTrxnsAll.CARD_PROGRAM_ID, ApCreditCardTrxnsAll.TRANSACTION_DATE, ApCreditCardTrxnsAll.TRANSACTION_AMOUNT, ApCreditCardTrxnsAll.BILLED_AMOUNT, ApCreditCardTrxnsAll.POSTED_CURRENCY_CODE, ApCreditCardTrxnsAll.BILLED_CURRENCY_CODE, ApCreditCardTrxnsAll.MERCHANT_NAME1, ApCreditCardTrxnsAll.MERCHANT_CITY, ApCreditCardTrxnsAll.MERCHANT_PROVINCE_STATE, ApCreditCardTrxnsAll.MERCHANT_COUNTRY, ApCreditCardTrxnsAll.FOLIO_TYPE, ApCreditCardTrxnsAll.CATEGORY, ApCreditCardTrxnsAll.REPORT_HEADER_ID, ApCreditCardTrxnsAll.COMPANY_PREPAID_INVOICE_ID, ApCreditCardTrxnsAll.EXPENSED_AMOUNT, CreditCardEO.CARD_ID, nvl(ApCreditCardTrxnsAll.BILLED_DATE, ApCreditCardTrxnsAll.POSTED_DATE) BILLED_DATE, ApCreditCardTrxnsAll.HOTEL_ROOM_AMOUNT, ApCreditCardTrxnsAll.HOTEL_TELEPHONE_AMOUNT, ApCreditCardTrxnsAll.HOTEL_ROOM_TAX, ApCreditCardTrxnsAll.HOTEL_BAR_AMOUNT, ApCreditCardTrxnsAll.HOTEL_MOVIE_AMOUNT, ApCreditCardTrxnsAll.HOTEL_GIFT_SHOP_AMOUNT, ApCreditCardTrxnsAll.HOTEL_LAUNDRY_AMOUNT, ApCreditCardTrxnsAll.HOTEL_HEALTH_AMOUNT, ApCreditCardTrxnsAll.HOTEL_RESTAURANT_AMOUNT, ApCreditCardTrxnsAll.HOTEL_BUSINESS_AMOUNT, ApCreditCardTrxnsAll.HOTEL_PARKING_AMOUNT, ApCreditCardTrxnsAll.HOTEL_ROOM_SERVICE_AMOUNT, ApCreditCardTrxnsAll.HOTEL_TIP_AMOUNT, ApCreditCardTrxnsAll.HOTEL_MISC_AMOUNT, ApCreditCardTrxnsAll.PAYMENT_DUE_FROM_CODE, ApCreditCardTrxnsAll.POSTED_DATE, ApCreditCardTrxnsAll.AIR_TICKET_NUMBER, TRUNC(sysdate - NVL(POSTED_DATE, BILLED_DATE)) as Age, decode(REPORT_HEADER_ID, null, 'N', 'Y') as selected, decode(apcp.auto_itemize_enabled_flag, 'Y', decode(folio_type, null, 'N', ApCreditCardTrxnsAll.TRXN_DETAIL_FLAG), 'N') , decode(apcp.auto_itemize_enabled_flag, 'Y', decode(folio_type, null, 'N', decode(ApCreditCardTrxnsAll.TRXN_DETAIL_FLAG, 'Y', 'Y', AP_WEB_CREDIT_CARD_PKG.HAS_DETAILED_TRXN(ApCreditCardTrxnsAll.trx_id) ) ), 'N') as level2or3_detail_flag, ApCreditCardTrxnsAll.DESCRIPTION FROM AP_CREDIT_CARD_TRXNS ApCreditCardTrxnsAll, AP_CARDS CreditCardEO, AP_CARD_PROGRAMS apcp WHERE ApCreditCardTrxnsAll.validate_code = 'Y' AND CreditCardEO.CARD_PROGRAM_ID = apcp.card_program_id AND ApCreditCardTrxnsAll.payment_flag <> 'Y' AND ApCreditCardTrxnsAll.billed_amount is not null AND ApCreditCardTrxnsAll.billed_currency_code = :1 AND CreditCardEO.card_id = :2 AND ApCreditCardTrxnsAll.payment_due_from_code = :3 AND ApCreditCardTrxnsAll.CARD_PROGRAM_ID = CreditCardEO.CARD_PROGRAM_ID AND ApCreditCardTrxnsAll.CARD_ID = CreditCardEO.CARD_ID AND (nvl(ApCreditCardTrxnsAll.CATEGORY, 'BUSINESS') not in ('DISPUTED', 'CREDIT', 'MATCHED', 'DEACTIVATED')) AND trunc(nvl(ApCreditCardTrxnsAll.trx_available_date, TO_DATE('01-01-1952 00:00:00', 'DD-MM-YYYY HH24:MI:SS'))) <= trunc(sysdate)) QRSLT WHERE (report_header_id is null OR report_header_id = :4) ORDER BY age desc |
| 5y4fg1527trdk | SELECT * FROM (SELECT rsa.RULE_ASSIGNMENT_ID, rsa.RULE_SET_ID, rsa.ORG_ID, rsa.CREATION_DATE, rsa.CREATED_BY, rsa.LAST_UPDATE_LOGIN, rsa.LAST_UPDATE_DATE, rsa.LAST_UPDATED_BY, rsa.START_DATE, rsa.END_DATE, rs.rule_set_type, ou.name ORG_NAME, rs.rule_set_name, rsa.END_DATE orig_end_date FROM AP_AUD_RULE_ASSIGNMENTS_ALL rsa, AP_AUD_RULE_SETS rs, HR_ORGANIZATION_UNITS ou WHERE ou.organization_id = rsa.org_id AND rs.rule_set_id = rsa.rule_set_id AND rsa.org_id = :1 AND rs.rule_set_type = :2) QRSLT ORDER BY start_date desc |
| 61ra3j3bhj409 |
SELECT /*+ index(ps AR_PAYMENT_SCHEDULES_ALL_CUS2) */ DECODE(:B4 , NULL, PS.ACCTD_AMOUNT_DUE_REMAINING, PS.AMOUNT_DUE_REMAINING), DECODE(:B29 , 'DISPUTE_ONLY', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 0, 1), 'PENDADJ_ONLY', DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 'DISPUTE_PENDADJ', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 1), DECODE( GREATEST(:B28 , CEIL(:B7 -PS.DUE_DATE)), LEAST(:B27 , CEIL(:B7 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B8 , 'DISPUTE_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B8 , 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1))) B0, DECODE(:B26 , 'DISPUTE_ONLY', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 0, 1), 'PENDADJ_ONLY', DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 'DISPUTE_PENDADJ', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 1), DECODE( GREATEST(:B25 , CEIL(:B7 -PS.DUE_DATE)), LEAST(:B24 , CEIL(:B7 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B8 , 'DISPUTE_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B8 , 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1))) B1, DECODE(:B23 , 'DISPUTE_ONLY', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 0, 1), 'PENDADJ_ONLY', DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 'DISPUTE_PENDADJ', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 1), DECODE( GREATEST(:B22 , CEIL(:B7 -PS.DUE_DATE)), LEAST(:B21 , CEIL(:B7 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B8 , 'DISPUTE_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B8 , 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1))) B2, DECODE(:B20 , 'DISPUTE_ONLY', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 0, 1), 'PENDADJ_ONLY', DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 'DISPUTE_PENDADJ', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 1), DECODE( GREATEST(:B19 , CEIL(:B7 -PS.DUE_DATE)), LEAST(:B18 , CEIL(:B7 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B8 , 'DISPUTE_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B8 , 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1))) B3, DECODE(:B17 , 'DISPUTE_ONLY', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 0, 1), 'PENDADJ_ONLY', DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 'DISPUTE_PENDADJ', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 1), DECODE( GREATEST(:B16 , CEIL(:B7 -PS.DUE_DATE)), LEAST(:B15 , CEIL(:B7 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B8 , 'DISPUTE_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B8 , 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1))) B4, DECODE(:B14 , 'DISPUTE_ONLY', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 0, 1), 'PENDADJ_ONLY', DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 'DISPUTE_PENDADJ', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 1), DECODE( GREATEST(:B13 , CEIL(:B7 -PS.DUE_DATE)), LEAST(:B12 , CEIL(:B7 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B8 , 'DISPUTE_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B8 , 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1))) B5, DECODE(:B11 , 'DISPUTE_ONLY', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 0, 1), 'PENDADJ_ONLY', DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 'DISPUTE_PENDADJ', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 1), DECO
DE( GREATEST(:B10 , CEIL(:B7 -PS.DUE_DATE)), LEAST(:B9 , CEIL(:B7 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B8 , 'DISPUTE_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B8 , 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1))) B6 FROM RA_CUST_TRX_TYPES, AR_PAYMENT_SCHEDULES PS WHERE PS.GL_DATE <= :B7 AND PS.CUST_TRX_TYPE_ID = RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID AND PS.GL_DATE_CLOSED > :B7 AND PS.CUSTOMER_ID = :B6 AND DECODE(:B5 , NULL, PS.CUSTOMER_SITE_USE_ID, :B5 ) = PS.CUSTOMER_SITE_USE_ID AND DECODE(UPPER(:B4 ), NULL, PS.INVOICE_CURRENCY_CODE, UPPER(:B4 )) = PS.INVOICE_CURRENCY_CODE AND DECODE(UPPER(:B3 ), 'AGE', 'dummy', 'CM') <> PS.CLASS AND DECODE(UPPER(:B3 ), 'AGE', 'dummy', 'PMT') <> PS.CLASS AND DECODE(:B2 , NULL, RA_CUST_TRX_TYPES.NAME, :B2 ) <= RA_CUST_TRX_TYPES.NAME AND DECODE(:B1 , NULL, RA_CUST_TRX_TYPES.NAME, :B1 ) >= RA_CUST_TRX_TYPES.NAME UNION ALL SELECT /*+ index(ps AR_PAYMENT_SCHEDULES_ALL_CUS2) */ -SUM(DECODE(:B4 , NULL, APP.ACCTD_AMOUNT_APPLIED_FROM, APP.AMOUNT_APPLIED)), DECODE(:B29 , 'DISPUTE_ONLY', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 0, 1), 'PENDADJ_ONLY', DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 'DISPUTE_PENDADJ', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 1), DECODE( GREATEST(:B28 , CEIL(:B7 -PS.DUE_DATE)), LEAST(:B27 , CEIL(:B7 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B8 , 'DISPUTE_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B8 , 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1))) B0, DECODE(:B26 , 'DISPUTE_ONLY', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 0, 1), 'PENDADJ_ONLY', DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 'DISPUTE_PENDADJ', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 1), DECODE( GREATEST(:B25 , CEIL(:B7 -PS.DUE_DATE)), LEAST(:B24 , CEIL(:B7 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B8 , 'DISPUTE_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B8 , 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)))B1, DECODE(:B23 , 'DISPUTE_ONLY', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 0, 1), 'PENDADJ_ONLY', DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 'DISPUTE_PENDADJ', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 1), DECODE( GREATEST(:B22 , CEIL(:B7 -PS.DUE_DATE)), LEAST(:B21 , CEIL(:B7 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B8 , 'DISPUTE_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B8 , 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1))) B2, DECODE(:B20 , 'DISPUTE_ONLY', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 0, 1), 'PENDADJ_ONLY', DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 'DISPUTE_PENDADJ', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 1), DECODE( GREATEST(:B19 , CEIL(:B7 -PS.DUE_DATE)), LEAST(:B18 , CEIL(:B7 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B8 , 'DISPUTE_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B8 , 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1))) B3, DECODE(:B17 , 'DISPUTE_ONLY', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 0, 1), 'PENDADJ_ONLY', DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 'DISPUTE_PENDADJ', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 1), DECODE( GREATEST(:B16 , CEIL(:B7 -PS.DUE_DATE)), LEAST(:B15 , CEIL(:B7 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B8 , 'DISPUTE_ONLY', 0, 'DISPUTE
_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B8 , 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1))) B4, DECODE(:B14 , 'DISPUTE_ONLY', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 0, 1), 'PENDADJ_ONLY', DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 'DISPUTE_PENDADJ', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 1), DECODE( GREATEST(:B13 , CEIL(:B7 -PS.DUE_DATE)), LEAST(:B12 , CEIL(:B7 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B8 , 'DISPUTE_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B8 , 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1))) B5, DECODE(:B11 , 'DISPUTE_ONLY', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 0, 1), 'PENDADJ_ONLY', DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 'DISPUTE_PENDADJ', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 1), DECODE( GREATEST(:B10 , CEIL(:B7 -PS.DUE_DATE)), LEAST(:B9 , CEIL(:B7 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B8 , 'DISPUTE_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B8 , 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1))) B6 FROM AR_PAYMENT_SCHEDULES PS, AR_RECEIVABLE_APPLICATIONS APP WHERE APP.GL_DATE+0 <= :B7 AND PS.CASH_RECEIPT_ID+0 = APP.CASH_RECEIPT_ID AND APP.STATUS IN ( 'ACC', 'UNAPP', 'UNID', 'OTHER ACC') AND NVL(APP.CONFIRMED_FLAG, 'Y') = 'Y' AND PS.GL_DATE_CLOSED > :B7 AND (APP.REVERSAL_GL_DATE > :B7 OR APP.REVERSAL_GL_DATE IS NULL ) AND NVL( PS.RECEIPT_CONFIRMED_FLAG, 'Y' ) = 'Y' AND PS.CUSTOMER_ID = :B6 AND DECODE(:B5 , NULL, NVL(PS.CUSTOMER_SITE_USE_ID, -10), :B5 ) = NVL(PS.CUSTOMER_SITE_USE_ID, -10) AND DECODE(UPPER(:B4 ), NULL, PS.INVOICE_CURRENCY_CODE, UPPER(:B4 )) = PS.INVOICE_CURRENCY_CODE AND DECODE(UPPER(:B3 ), 'AGE', 'dummy', 'CM') <> PS.CLASS AND DECODE(UPPER(:B3 ), 'AGE', 'dummy', 'PMT') <> PS.CLASS GROUP BY PS.DUE_DATE, PS.AMOUNT_DUE_ORIGINAL, PS.AMOUNT_ADJUSTED, PS.AMOUNT_APPLIED, PS.AMOUNT_CREDITED, PS.GL_DATE, PS.AMOUNT_IN_DISPUTE, PS.AMOUNT_ADJUSTED_PENDING, PS.INVOICE_CURRENCY_CODE, PS.EXCHANGE_RATE, PS.CLASS, DECODE( APP.STATUS, 'UNID', 'UNID', 'UNAPP') |
| 67mmmbx5hb3p0 | BEGIN :1 := FND_AOLJ_UTIL.is_Valid_ICX(:2, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, true);:19 := fnd_session_management.g_enc_key;:20 := fnd_session_management.g_mac_key;:21 := fnd_session_management.g_proxy_user_id; :22 := fnd_session_management.g_mode_code; END; |
| 6hr29bwvugchr | SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM GMS_IMPLEMENTATIONS WHERE ORG_ID = :B1 AND ENABLED = 'Y') |
| 707cda24y439k | SELECT NVL(count(1), 0), NVL(SUM(ACCTD_AMOUNT_DUE_REMAINING), 0) FROM ar_payment_schedules arp WHERE (arp.customer_id = :cust_account_id and arp.status = 'OP') and ( trunc(sysdate)-trunc(arp.due_date) >= :days_start and trunc(sysdate)-trunc(arp.due_date) <= :days_to and arp.class = :class ) |
| 72tm9vzuscjyf | declare sess_id number; tranx_id number; new_tranx_id number; cursor c1 is select transaction_id from icx_transactions where session_id = sess_id and transaction_id = tranx_id;begin sess_id := fnd_session_utilities.XSID_to_SessionID(:1); tranx_id := :2; open c1; fetch c1 into new_tranx_id; if c1%notfound then new_tranx_id := fnd_session_management.CREATETRANSACTION(sess_id); end if; :3 := new_tranx_id;end; |
| 7qs7fx89194u1 | SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = :B2 AND LEVEL_VALUE = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL |
| 7r409fmf91tmv | SELECT GS.CHART_OF_ACCOUNTS_ID FROM AP_SYSTEM_PARAMETERS S, GL_SETS_OF_BOOKS GS WHERE GS.SET_OF_BOOKS_ID = S.SET_OF_BOOKS_ID AND ROWNUM = 1 |
| 7ujfmgb1j83a3 | BEGIN FND_AOLJ_UTIL.SET_NLS_CONTEXT( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13);END; |
| 7z0tsy9zxk6p0 | SELECT count(distinct ocahb.id) FROM ar_payment_schedules arp, ar_aging_bucket_lines aabl, ra_customer_trx rct, okl_cnsld_ar_strms_b ocasb, OKL_CNSLD_AR_LINES_B ocalb, OKL_CNSLD_AR_HDRS_B ocahb WHERE (:l_date - arp.due_date) >= aabl.days_start and (:l_date - arp.due_date) <= aabl.days_to and arp.class = :l_class and rct.customer_trx_id = arp.customer_trx_id and ocasb.receivables_invoice_id = rct.customer_trx_id and ocalb.id = ocasb.lln_id and ocahb.id = ocalb.cnr_id and rct.interface_header_attribute9 <> :l_interface_attr and rct.interface_header_context = :l_interface_context and arp.status = :l_status and aabl.aging_bucket_line_id = :bucket_line_id AND arp.customer_id = :cust_account_id |
| 91hakq9n36htp | SELECT TEXT_VALUE FROM WF_ITEM_ATTRIBUTE_VALUES WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND NAME = :B1 |
| 92u6ugfbk24qw | /* $Header: ValueSet.java 120.7.12010000.7 2009/09/01 20:55:44 hgeorgi ship $ */ select 'Y' FLEX_ENABLED_FLAG , trunc(to_date(null)) FLEX_START_DATE , trunc(to_date(null)) FLEX_END_DATE , trunc(SysDate) FLEX_SYSDATE , 'N' FLEX_SUMMARY_FLAG , NULL FLEX_COMPILED_VALUE_ATTRIBUTES , PROMPT FLEX_ID , PARAMETER_ID FLEX_DESCRIPTION from AP_EXPENSE_TYPES_V erp, AP_EXPENSE_REPORTS er where ( ((nvl(:1, 'NULL') != 'NULL' AND erp.PA_EXPENDITURE_TYPE in (select ga.EXPENDITURE_TYPE from GMS_SSA_AWARD_EXPTYPE_V ga where ga.AWARD_NUMBER = nvl(:2, -99999) )) OR nvl(:3, 'NULL') = 'NULL') AND ((erp.EXPENSE_REPORT_ID = nvl(:4, -99999)) OR (erp.WEB_ENABLED_FLAG = 'Y' AND er.WEB_ENABLED_FLAG = 'Y')) AND ( (nvl(:5, 'NULL') <> 'MILEAGE' AND nvl(:6, 'NULL') <> 'PER_DIEM' AND erp.CATEGORY_CODE <> 'MILEAGE' AND erp.CATEGORY_CODE <> 'PER_DIEM') OR (nvl(:7, 'NULL') = erp.CATEGORY_CODE) ) AND trunc(sysdate) <= trunc(nvl(er.INACTIVE_DATE, sysdate)) + nvl(:8, 0) AND trunc(sysdate) <= trunc(nvl(erp.END_DATE, sysdate)) + nvl(:9, 0) AND (nvl(:10, 'NULL') = 'NULL' OR PA_EXPENDITURE_TYPE is not NULL) AND erp.EXPENSE_REPORT_ID = er.EXPENSE_REPORT_ID) and WEB_PROMPT = :11 |
| 9bbak9qpg1c7x | INSERT INTO WF_ITEM_ATTRIBUTE_VALUES ( ITEM_TYPE, ITEM_KEY, NAME, TEXT_VALUE, NUMBER_VALUE, DATE_VALUE ) VALUES ( :B6 , :B5 , :B4 , :B3 , :B2 , :B1 ) |
| 9dq8x6239bhmt | UPDATE AP_EXP_REPORT_DISTS SET (CODE_COMBINATION_ID, SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, SEGMENT6, SEGMENT7, SEGMENT8, SEGMENT9, SEGMENT10, SEGMENT11, SEGMENT12, SEGMENT13, SEGMENT14, SEGMENT15, SEGMENT16, SEGMENT17, SEGMENT18, SEGMENT19, SEGMENT20, SEGMENT21, SEGMENT22, SEGMENT23, SEGMENT24, SEGMENT25, SEGMENT26, SEGMENT27, SEGMENT28, SEGMENT29, SEGMENT30, COST_CENTER) = (SELECT NVL(CODE_COMBINATION_ID, :B3 ), SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, SEGMENT6, SEGMENT7, SEGMENT8, SEGMENT9, SEGMENT10, SEGMENT11, SEGMENT12, SEGMENT13, SEGMENT14, SEGMENT15, SEGMENT16, SEGMENT17, SEGMENT18, SEGMENT19, SEGMENT20, SEGMENT21, SEGMENT22, SEGMENT23, SEGMENT24, SEGMENT25, SEGMENT26, SEGMENT27, SEGMENT28, SEGMENT29, SEGMENT30, AP_WEB_DB_EXPDIST_PKG.GETCCSEGMENTVALUE(:B3 ) FROM GL_CODE_COMBINATIONS WHERE CODE_COMBINATION_ID = :B3 ) WHERE REPORT_DISTRIBUTION_ID = :B2 AND REPORT_HEADER_ID = :B1 |
| a0b9t5ctnc47j | SELECT REPORT_DISTRIBUTION_ID FROM AP_EXP_REPORT_DISTS WHERE REPORT_HEADER_ID = :B2 AND REPORT_LINE_ID = :B1 AND ROWNUM = 1 |
| a14wcsg9mk8j3 | WITH a as (SELECT a$.dbid, a$.snap_id, a$.INSTANCE_NUMBER, a$.PLSQL_ENTRY_OBJECT_ID, a$.PLSQL_ENTRY_SUBPROGRAM_ID, a$.PLSQL_OBJECT_ID, a$.PLSQL_SUBPROGRAM_ID, a$.TIME_MODEL FROM WRH$_ACTIVE_SESSION_HISTORY a$ WHERE a$.dbid = :dbid AND a$.instance_number = :inst AND a$.snap_id > :bid AND a$.snap_id <= :eid AND a$.session_type = 1 ) , ash as (SELECT cnt , PLSQL_OBJECT_ID, PLSQL_SUBPROGRAM_ID FROM ( SELECT count(*) as cnt , a.PLSQL_OBJECT_ID, a.PLSQL_SUBPROGRAM_ID FROM a WHERE bitand(a.time_model, power(2, 11 )) !=0 AND a.PLSQL_ENTRY_OBJECT_ID = :plsqleid AND a.PLSQL_ENTRY_SUBPROGRAM_ID = :plsqlesid GROUP BY PLSQL_OBJECT_ID, PLSQL_SUBPROGRAM_ID HAVING count(*) >= :rowcnt ORDER BY 1 DESC, 2 ASC ) WHERE rownum <= :ret) SELECT ash.plsql_object_id, ash.plsql_subprogram_id, dba.object_name, dba.object_type, dba.owner, dba.procedure_name, to_number(dba.overload), ash.cnt FROM dba_procedures dba, ash WHERE ash.plsql_object_id = dba.object_id(+) AND ash.plsql_subprogram_id = dba.subprogram_id(+) ORDER BY ash.cnt DESC, ash.plsql_object_id, ash.plsql_subprogram_id |
| aaw4na3kmdfkq | DECLARE l_result varchar2(1); BEGIN l_result := FND_AOLJ_UTIL.convertGuestSession(:1, :2, :3, :4, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20); :21 := l_result;END; |
| aw7fu9a9bdyus | SELECT * FROM PER_SECURITY_PROFILES WHERE SECURITY_PROFILE_ID = :B1 |
| b1rpgkmtm60d1 | SELECT EXP_CYCLE_START_DAY_CODE FROM PA_IMPLEMENTATIONS |
| bqf04xkudk4zt | BEGIN :1 := FND_AOLJ_UTIL.createSession(:2, :3, :4, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22);:23 := fnd_session_management.g_enc_key;:24 := fnd_session_management.g_mac_key;END; |
| chkkj84y3mv9s | BEGIN fnd_msg_pub.initialize;AP_WEB_OA_MAINFLOW_PKG.validateReceiptLine(employee_id => :1, template_id => :2, summary_start_date => :3, reimbursement_currency_code => :4, reimbursement_currency_name => :5, multi_currency_flag => :6, override_approver_name => :7, number_max_flexfield => :8, start_date => :9, end_date => :10, days => :11, daily_amount => :12, receipt_amount => :13, rate => :14, amount => :15, parameter_id => :16, currency_code => :17, merchant => :18, merchantDoc => :19, taxReference => :20, taxRegNumber => :21, taxPayerId => :22, supplyCountry => :23, itemizeId => :24, cCardTrxnId => :25, group_value => :26, justification => :27, receipt_missing_flag => :28, validation_required => :29, taxOverrideFlag => :30, project_number => :31, task_number => :32, project_name => :33, task_name => :34, attribute1 => :35, attribute2 => :36, attribute3 => :37, attribute4 => :38, attribute5 => :39, attribute6 => :40, attribute7 => :41, attribute8 => :42, attribute9 => :43, attribute10 => :44, attribute11 => :45, attribute12 => :46, attribute13 => :47, attribute14 => :48, attribute15 => :49, p_IsSessionTaxEnabled => :50, p_IsSessionProjectEnabled => :51, p_calculate_amt_index => :52, p_calculated_receipt_amount => :53, p_return_status => :54, p_msg_count => :55, p_msg_data => :56, p_userId => :57, award_number => :58, p_cost_center => :59, p_template_name => :60 , p_purpose => :61 , p_override_approver_id => :62, p_last_update_date => :63, receipt_cost_center => :64, p_transaction_currency_type => :65, p_inverse_rate_flag => :66, p_report_header_id => :67, p_category_code => :68, p_nFreeBreakfasts1 => :69, p_nFreeBreakfasts2 => :70, p_nFreeBreakfasts3 => :71, p_nFreeLunches1 => :72, p_nFreeLunches2 => :73, p_nFreeLunches3 => :74, p_nFreeDinners1 => :75, p_nFreeDinners2 => :76, p_nFreeDinners3 => :77, p_nFreeAccommodations1 => :78, p_nFreeAccommodations2 => :79, p_nFreeAccommodations3 => :80, p_location => :81, p_dailyDistance => :82, p_tripDistance => :83, p_mileageRate => :84, p_vehicleCategory => :85, p_vehicleType => :86, p_fuelType => :87, p_numberPassengers => :88, p_default_currency_code => :89, p_default_exchange_rate_type => :90, p_header_attribute_category => :91, p_header_attribute1 => :92, p_header_attribute2 => :93, p_header_attribute3 => :94, p_header_attribute4 => :95, p_header_attribute5 => :96, p_header_attribute6 => :97, p_header_attribute7 => :98, p_header_attribute8 => :99, p_header_attribute9 => :100, p_header_attribute10 => :101, p_header_attribute11 => :102, p_header_attribute12 => :103, p_header_attribute13 => :104, p_header_attribute14 => :105, p_header_attribute15 => :106, p_receipt_index => :107, p_passenger_rate_used => :108, p_license_plate_number => :109, p_destination_from => :110, p_destination_to => :111, p_distance_unit_code => :112, p_report_line_id => :113, p_itemization_parent_id => :114, p_cust_meals_amount => :115, p_cust_accommodation_amount => :116, p_cust_night_rate_amount => :117, p_cust_pdm_rate => :118, p_emp_attendee_count => :119, p_nonemp_attendee_count => :120 , p_vat_code => :121);END; |
| cmxq1hvy8crz7 | SELECT ExpAttendeeEO.REPORT_LINE_ID, ExpAttendeeEO.EMPLOYEE_FLAG, ExpAttendeeEO.EMPLOYEE_ID, ExpAttendeeEO.ATTENDEE_TYPE, ExpAttendeeEO.NAME, ExpAttendeeEO.TITLE, ExpAttendeeEO.EMPLOYER, ExpAttendeeEO.EMPLOYER_ADDRESS, ExpAttendeeEO.ORG_ID, ExpAttendeeEO.LAST_UPDATE_DATE, ExpAttendeeEO.LAST_UPDATED_BY, ExpAttendeeEO.CREATION_DATE, ExpAttendeeEO.CREATED_BY, ExpAttendeeEO.LAST_UPDATE_LOGIN, ExpAttendeeEO.ATTENDEE_LINE_ID, ExpAttendeeEO.TAX_ID FROM OIE_ATTENDEES_ALL ExpAttendeeEO WHERE :1 = ExpAttendeeEO.REPORT_LINE_ID AND EMPLOYEE_FLAG = 'Y' |
| dawf7hvg1ym94 | select V.PROFILE_OPTION_VALUE from FND_PROFILE_OPTIONS O, FND_PROFILE_OPTION_VALUES V where O.PROFILE_OPTION_NAME = :1 and V.LEVEL_ID = :2 and O.START_DATE_ACTIVE <= SYSDATE and nvl(O.END_DATE_ACTIVE, SYSDATE) >= SYSDATE and O.PROFILE_OPTION_ID = V.PROFILE_OPTION_ID and O.APPLICATION_ID = V.APPLICATION_ID and V.LEVEL_VALUE = :3 |
| dcrschgcxcbkn | begin AP_WEB_EXPENSE_WF.APVALIDATEEXPENSEREPORT (:v1, :v2, :v3, :v4, :v5); end; |
| f2m7b1g3jk389 | INSERT INTO AP_EXP_REPORT_DISTS ( REPORT_HEADER_ID, REPORT_LINE_ID, REPORT_DISTRIBUTION_ID, SEQUENCE_NUM, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, CODE_COMBINATION_ID, SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, SEGMENT6, SEGMENT7, SEGMENT8, SEGMENT9, SEGMENT10, SEGMENT11, SEGMENT12, SEGMENT13, SEGMENT14, SEGMENT15, SEGMENT16, SEGMENT17, SEGMENT18, SEGMENT19, SEGMENT20, SEGMENT21, SEGMENT22, SEGMENT23, SEGMENT24, SEGMENT25, SEGMENT26, SEGMENT27, SEGMENT28, SEGMENT29, SEGMENT30, ORG_ID, AMOUNT, PROJECT_ID, TASK_ID, AWARD_ID, EXPENDITURE_ORGANIZATION_ID, COST_CENTER ) SELECT XL.REPORT_HEADER_ID, XL.REPORT_LINE_ID, AP_EXP_REPORT_DISTS_S.NEXTVAL, :B2 , SYSDATE, XL.LAST_UPDATED_BY, SYSDATE, XL.CREATED_BY, XL.CODE_COMBINATION_ID, GL.SEGMENT1, GL.SEGMENT2, GL.SEGMENT3, GL.SEGMENT4, GL.SEGMENT5, GL.SEGMENT6, GL.SEGMENT7, GL.SEGMENT8, GL.SEGMENT9, GL.SEGMENT10, GL.SEGMENT11, GL.SEGMENT12, GL.SEGMENT13, GL.SEGMENT14, GL.SEGMENT15, GL.SEGMENT16, GL.SEGMENT17, GL.SEGMENT18, GL.SEGMENT19, GL.SEGMENT20, GL.SEGMENT21, GL.SEGMENT22, GL.SEGMENT23, GL.SEGMENT24, GL.SEGMENT25, GL.SEGMENT26, GL.SEGMENT27, GL.SEGMENT28, GL.SEGMENT29, GL.SEGMENT30, XL.ORG_ID, XL.AMOUNT, XL.PROJECT_ID, XL.TASK_ID, XL.AWARD_ID, XL.EXPENDITURE_ORGANIZATION_ID, XH.FLEX_CONCATENATED FROM AP_EXPENSE_REPORT_LINES XL, AP_EXPENSE_REPORT_HEADERS XH, GL_CODE_COMBINATIONS GL WHERE XL.REPORT_LINE_ID = :B1 AND XL.REPORT_HEADER_ID = XH.REPORT_HEADER_ID AND GL.CODE_COMBINATION_ID(+) = XL.CODE_COMBINATION_ID |
| f7g96xjhudpzt | BEGIN HXC_TIMECARD.CREATE_TIMECARD (P_VALIDATE => :1 , P_BLOCKS => :2 , P_ATTRIBUTES => :3 , P_DEPOSIT_MODE => :4 , P_TEMPLATE => :5 , P_ITEM_TYPE => :6 , P_APPROVAL_PRC => :7 , P_LOCK_ROWID => :8 , P_TIMECARD_ID => :9 , P_TIMECARD_OVN => :10 , P_MESSAGES => :11 , P_CLA_SAVE => :12 ); END; |
| fpbjgy15dr12j | SELECT FLEX_CONCACTENATED FROM AP_EXPENSE_REPORT_PARAMS WHERE PARAMETER_ID = :B1 |
| g3g74r6wnrv0h | SELECT * FROM (SELECT parent_type.expense_report_id as parent_expense_report_id, parent_type.parameter_id as parent_expense_type_id, child_type.PARAMETER_ID AS child_expense_type_id, nvl(child_type.WEB_FRIENDLY_PROMPT, child_type.PROMPT) AS WEB_PROMPT, child_type.PROMPT AS PROMPT, child_type.REQUIRE_RECEIPT_AMOUNT AS REQUIRE_RECEIPT_AMOUNT, nvl(child_type.prompt, 'ITEM') AS ITEM_DESCRIPTION, nvl(child_type.line_type_lookup_code, 'ITEM') AS LINE_TYPE_LOOKUP_CODE, child_type.CARD_EXP_TYPE_LOOKUP_CODE AS CARD_EXP_TYPE_LOOKUP_CODE, nvl(child_type.JUSTIFICATION_REQUIRED_FLAG, 'N') AS JUSTIFICATION_REQUIRED, child_type.CALCULATE_AMOUNT_FLAG AS CALCULATE_AMOUNT_FLAG, child_type.AMOUNT_INCLUDES_TAX_FLAG AS AMOUNT_INCLUDES_TAX_FLAG, child_type.PA_EXPENDITURE_TYPE AS PA_EXPENDITURE_TYPE, child_type.COMPANY_POLICY_ID, child_type.CATEGORY_CODE, child_type.END_DATE, child_type.ITEMIZATION_REQUIRED_FLAG, child_type.ITEMIZATION_ALL_FLAG, child_type.RECEIPT_REQUIRED_FLAG, child_type.data_capture_rule_id FROM AP_EXPENSE_REPORT_PARAMS parent_type, AP_EXPENSE_REPORT_PARAMS child_type, AP_POL_ITEMIZATIONS api WHERE parent_type.itemization_all_flag = 'N' AND api.parameter_id = parent_type.parameter_id AND child_type.parameter_id = api.itemization_parameter_id AND child_type.CATEGORY_CODE != 'PER_DIEM' AND child_type.CATEGORY_CODE != 'MILEAGE' AND ('RO' = :1 or trunc(sysdate) <= trunc(nvl(child_type.END_DATE, sysdate)) + nvl(fnd_profile.value('AP_WEB_POLICY_GRACE_PERIOD'), 0)) UNION ALL SELECT parent_type.expense_report_id as parent_expense_report_id, parent_type.parameter_id as parent_expense_type_id, child_type.PARAMETER_ID AS child_expense_type_id, nvl(child_type.WEB_FRIENDLY_PROMPT, child_type.PROMPT) AS WEB_PROMPT, child_type.PROMPT AS PROMPT, child_type.REQUIRE_RECEIPT_AMOUNT AS REQUIRE_RECEIPT_AMOUNT, nvl(child_type.prompt, 'ITEM') AS ITEM_DESCRIPTION, nvl(child_type.line_type_lookup_code, 'ITEM') AS LINE_TYPE_LOOKUP_CODE, child_type.CARD_EXP_TYPE_LOOKUP_CODE AS CARD_EXP_TYPE_LOOKUP_CODE, nvl(child_type.JUSTIFICATION_REQUIRED_FLAG, 'N') AS JUSTIFICATION_REQUIRED, child_type.CALCULATE_AMOUNT_FLAG AS CALCULATE_AMOUNT_FLAG, child_type.AMOUNT_INCLUDES_TAX_FLAG AS AMOUNT_INCLUDES_TAX_FLAG, child_type.PA_EXPENDITURE_TYPE AS PA_EXPENDITURE_TYPE, child_type.COMPANY_POLICY_ID, child_type.CATEGORY_CODE, child_type.END_DATE, child_type.ITEMIZATION_REQUIRED_FLAG, child_type.ITEMIZATION_ALL_FLAG, child_type.RECEIPT_REQUIRED_FLAG, child_type.data_capture_rule_id FROM AP_EXPENSE_REPORT_PARAMS parent_type, AP_EXPENSE_REPORT_PARAMS child_type WHERE parent_type.itemization_all_flag = 'Y' -- Include Expense Type if it either belongs to the requested Template -- or if it is marked as "Viewable From All Tempaltes AND (child_type.expense_report_id = parent_type.expense_report_id OR child_type.web_enabled_flag = 'Y') AND child_type.CATEGORY_CODE != 'PER_DIEM' AND child_type.CATEGORY_CODE != 'MILEAGE' AND ('RO' = :2 or trunc(sysdate) <= trunc(nvl(child_type.END_DATE, sysdate)) + nvl(fnd_profile.value('AP_WEB_POLICY_GRACE_PERIOD'), 0))) QRSLT WHERE PARENT_EXPENSE_TYPE_ID = :3 ORDER BY WEB_PROMPT |
| gpjv3cr5rgu7d | SELECT S.EXCHANGE_RATE_TYPE FROM AP_POL_EXRATE_OPTIONS S WHERE ENABLED = 'Y' |
| gyxy3j5qt6hq0 | SELECT * FROM (SELECT erp.PARAMETER_ID AS PARAMETER_ID, nvl(erp.WEB_FRIENDLY_PROMPT, erp.PROMPT) AS WEB_PROMPT, erp.PROMPT AS PROMPT, erp.REQUIRE_RECEIPT_AMOUNT AS REQUIRE_RECEIPT_AMOUNT, nvl(erp.prompt, 'ITEM') AS ITEM_DESCRIPTION, nvl(erp.line_type_lookup_code, 'ITEM') AS LINE_TYPE_LOOKUP_CODE, erp.CARD_EXP_TYPE_LOOKUP_CODE AS CARD_EXP_TYPE_LOOKUP_CODE, nvl(erp.JUSTIFICATION_REQUIRED_FLAG, 'N') AS JUSTIFICATION_REQUIRED, erp.CALCULATE_AMOUNT_FLAG AS CALCULATE_AMOUNT_FLAG, erp.AMOUNT_INCLUDES_TAX_FLAG AS AMOUNT_INCLUDES_TAX_FLAG, erp.PA_EXPENDITURE_TYPE AS PA_EXPENDITURE_TYPE, erp.COMPANY_POLICY_ID, erp.CATEGORY_CODE, erp.END_DATE, erp.ITEMIZATION_REQUIRED_FLAG, erp.ITEMIZATION_ALL_FLAG, erp.RECEIPT_REQUIRED_FLAG, erp.data_capture_rule_id, tax.name as tax_code, tax.tax_id, erp.CARD_REQUIRE_RECEIPT_AMOUNT, erp.NEG_RECEIPT_REQUIRED_FLAG FROM AP_EXPENSE_REPORT_PARAMS erp, AP_TAX_CODES tax where erp.vat_code = tax.name(+) and 'Y' = tax.WEB_ENABLED_FLAG(+)) QRSLT WHERE PARAMETER_ID = :1 |