eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_FD_EXTRACT_GEN_PVT dependencies on IBY_DOCS_PAYABLE_ALL

Line 2737: FROM iby_docs_payable_all xml_doc_lvl

2733: */
2734: /* Perf Function : 9184059*/
2735: CURSOR l_pmt_docpayablecount_csr (p_payment_id IN NUMBER) IS
2736: SELECT count(payment_id)
2737: FROM iby_docs_payable_all xml_doc_lvl
2738: WHERE xml_doc_lvl.formatting_payment_id = p_payment_id
2739: AND xml_doc_lvl.document_status NOT IN
2740: ('FAILED_BY_CALLING_APP','FAILED_BY_REJECTION_LEVEL','FAILED_BY_RELATED_DOCUMENT','FAILED_VALIDATION','REJECTED', 'REMOVED'); --bug 7006504
2741:

Line 2750: FROM iby_docs_payable_all xml_doc_lvl

2746: WHERE xml_doc_lvl.payment_id = p_payment_id; --bug 7459662
2747: */
2748: CURSOR l_docpayablecount_ppr_rpt_csr (p_payment_id IN NUMBER) IS
2749: SELECT count(payment_id)
2750: FROM iby_docs_payable_all xml_doc_lvl
2751: WHERE xml_doc_lvl.payment_id = p_payment_id; --bug 7459662
2752:
2753:
2754: CURSOR l_docpayablecount_amex_csr (p_payment_id IN NUMBER) IS

Line 2756: FROM iby_docs_payable_all xml_doc_lvl

2752:
2753:
2754: CURSOR l_docpayablecount_amex_csr (p_payment_id IN NUMBER) IS
2755: SELECT count(payment_id)
2756: FROM iby_docs_payable_all xml_doc_lvl
2757: WHERE xml_doc_lvl.payment_id = p_payment_id
2758: and xml_doc_lvl.document_status = 'PAYMENT_CREATED';
2759:
2760: BEGIN

Line 3462: FROM iby_xml_fd_doc_1_0_v xml_doc, iby_docs_payable_all doc, ce_security_profiles_v ce_sp

3458:
3459: -- for ppr report we need to filter the docs by MOAC accessibility check
3460: CURSOR l_docpayable_ppr_rpt_csr (p_payment_id IN NUMBER) IS
3461: SELECT XMLAgg(doc_payable)
3462: FROM iby_xml_fd_doc_1_0_v xml_doc, iby_docs_payable_all doc, ce_security_profiles_v ce_sp
3463: WHERE xml_doc.payment_id = p_payment_id --bug 7459662
3464: AND xml_doc.document_payable_id = doc.document_payable_id
3465: AND ce_sp.organization_type = doc.org_type
3466: AND ce_sp.organization_id = doc.org_id

Line 4102: iby_docs_payable_all ibydoc

4098: )
4099: FROM
4100: ap_invoice_lines_all ail,
4101: po_headers_all ph,
4102: iby_docs_payable_all ibydoc
4103: WHERE ibydoc.document_payable_id = p_document_payable_id
4104: AND ail.po_header_id = ph.po_header_id(+)
4105: AND nvl(ibydoc.calling_app_doc_unique_ref2,-99) = ail.invoice_id
4106: AND ibydoc.calling_app_id = 200;

Line 4157: p_doc_currency_code IN iby_docs_payable_all.document_currency_code%TYPE,

4153:
4154: /* Start of overloaded function */
4155: FUNCTION Get_Doc_DocLineAgg(p_document_payable_id IN NUMBER,
4156: p_call_app_doc_unique_ref2 IN ap_invoices_all.invoice_id%TYPE,
4157: p_doc_currency_code IN iby_docs_payable_all.document_currency_code%TYPE,
4158: p_calling_app_id IN iby_docs_payable_all.calling_app_id%TYPE)
4159: RETURN XMLTYPE
4160: IS
4161: l_docline_agg XMLTYPE;

Line 4158: p_calling_app_id IN iby_docs_payable_all.calling_app_id%TYPE)

4154: /* Start of overloaded function */
4155: FUNCTION Get_Doc_DocLineAgg(p_document_payable_id IN NUMBER,
4156: p_call_app_doc_unique_ref2 IN ap_invoices_all.invoice_id%TYPE,
4157: p_doc_currency_code IN iby_docs_payable_all.document_currency_code%TYPE,
4158: p_calling_app_id IN iby_docs_payable_all.calling_app_id%TYPE)
4159: RETURN XMLTYPE
4160: IS
4161: l_docline_agg XMLTYPE;
4162: --l_conc_invalid_chars VARCHAR2(50);

Line 4170: p_doc_currency_code IN iby_docs_payable_all.document_currency_code%TYPE,

4166: CURSOR l_docline_csr(p_document_payable_id IN NUMBER,
4167: p_conc_invalid_chars IN VARCHAR2,
4168: p_conc_replacement_chars IN VARCHAR2,
4169: p_call_app_doc_unique_ref2 IN ap_invoices_all.invoice_id%TYPE,
4170: p_doc_currency_code IN iby_docs_payable_all.document_currency_code%TYPE,
4171: p_calling_app_id IN iby_docs_payable_all.calling_app_id%TYPE)
4172: IS
4173: SELECT XMLAgg(
4174: XMLElement("DocumentPayableLine",

Line 4171: p_calling_app_id IN iby_docs_payable_all.calling_app_id%TYPE)

4167: p_conc_invalid_chars IN VARCHAR2,
4168: p_conc_replacement_chars IN VARCHAR2,
4169: p_call_app_doc_unique_ref2 IN ap_invoices_all.invoice_id%TYPE,
4170: p_doc_currency_code IN iby_docs_payable_all.document_currency_code%TYPE,
4171: p_calling_app_id IN iby_docs_payable_all.calling_app_id%TYPE)
4172: IS
4173: SELECT XMLAgg(
4174: XMLElement("DocumentPayableLine",
4175: XMLElement("LineNumber", ail.line_number),

Line 4673: FROM iby_docs_payable_all

4669: IS
4670: l_amount_withheld NUMBER;
4671: CURSOR l_pmt_amount_withheld_csr (p_payment_id IN NUMBER) IS
4672: SELECT sum(amount_withheld)
4673: FROM iby_docs_payable_all
4674: WHERE payment_id = p_payment_id;
4675: BEGIN
4676:
4677: OPEN l_pmt_amount_withheld_csr (payment_id);

Line 5462: l_base_inv_num iby_docs_payable_all.CALLING_APP_DOC_REF_NUMBER%TYPE;

5458: FUNCTION Get_Expense_Rpt_CC_Num(p_document_payable_id IN NUMBER)
5459: RETURN VARCHAR2
5460: IS
5461: l_instrid NUMBER;
5462: l_base_inv_num iby_docs_payable_all.CALLING_APP_DOC_REF_NUMBER%TYPE;
5463: l_card_num VARCHAR2(30);
5464: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Expense_Rpt_CC_Num';
5465:
5466: BEGIN

Line 5523: l_base_inv_num iby_docs_payable_all.CALLING_APP_DOC_REF_NUMBER%TYPE;

5519: RETURN XMLTYPE
5520: IS
5521: l_instrid NUMBER;
5522: l_card_num_agg XMLTYPE := NULL;
5523: l_base_inv_num iby_docs_payable_all.CALLING_APP_DOC_REF_NUMBER%TYPE;
5524: l_card_num VARCHAR2(30);
5525: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_CC_Num_For_Issuer_Pmt_Agg';
5526:
5527: CURSOR cc_num_ext_agg(p_card_num varchar2) is

Line 5546: FROM iby_docs_payable_all

5542:
5543: /* Fetching base invoice number where trxn_id is stamped */
5544: SELECT REPLACE(calling_app_doc_ref_number,'.1')
5545: INTO l_base_inv_num
5546: FROM iby_docs_payable_all
5547: WHERE document_payable_id = p_document_payable_id;
5548:
5549: /* Fetching instrument id from Expense tables */
5550: BEGIN