hi all
this is my first post here
whenever i execute ap_checks_v it says "no rows returned"[:(]
i have a report developed by someone previously before me,the client requirement is to display check_number with PAYMENT_METHOD_LOOKUP_CODE=WIRE
(PAYMENT_METHOD_LOOKUP_CODE is column in ap_checks_v and ap_checks_all)
i took this query which when executed in TOAD gives no rows returned[:(]
<b>SELECT
ac.check_id ac_check_id, ac.amount amount,
ac.currency_code currency_code, fcv.NAME currency_name,
fcv.PRECISION currency_precision, ac.doc_sequence_value voucher_number, ac.check_date check_date, ac.vendor_name paid_to,
ac
.description description, ac.bank_name bank_name,
' ' || ac.bank_account_name || ' ' bank_account_name,
' ' || ac.check_number || ' ' check_number,
NVL
(ac.future_pay_due_date, ac.check_date) maturity_date
FROM ap_checks_v ac, fnd_currencies_vl fcv
WHERE ac.check_number = :p_check_number
AND ac.currency_code = fcv.currency_code </b> i replaced ap_checks_v with ap_checks_all but it says ac.bank_name invalid identifier
whereas when i do select * from ap_checks_all i am able ot view CHECK_NUMBER having values when PAYMENT_METHOD_LOOK_UP_CODE=WIRE
currently i suppose only CHECK_NUMBER with Payment_method_look_up_code=CHECK is being displayed
i require WIRE too
kinldy help me
thanking in advance
kincly help me
Execute ap_checks_v showing "no rows returned"?
Hello.
Open the payments window and search for the check number. Then use Diagnostics/Examine and look for the ORG_ID value, not under the $PROFILE Block but unser the PAY_SUM_FOLDER Block. This should give you the correct org_id.
Are you using multiorg?
Also execute the following query and see if you can identify you org_id:
SELECT organization_id, name
FROM hr_all_organization_units;
Let me know if you solved the problem.
Octavio.
Open the payments window and search for the check number. Then use Diagnostics/Examine and look for the ORG_ID value, not under the $PROFILE Block but unser the PAY_SUM_FOLDER Block. This should give you the correct org_id.
Are you using multiorg?
Also execute the following query and see if you can identify you org_id:
SELECT organization_id, name
FROM hr_all_organization_units;
Let me know if you solved the problem.
Octavio.
Who is online
Users browsing this forum: Google [Bot] and 23 guests