[Home] [Help]
1621: */
1622: CURSOR
1623: c_val_sets(p_document_payable_id VARCHAR2)
1624: IS
1625: SELECT /*+ INDEX(docs IBY_DOCS_PAYABLE_GT_N1) NO_EXPAND */
1626: docs.document_payable_id,
1627: val.validation_set_code,
1628: val.validation_code_package,
1629: val.validation_code_entry_point,
1632: val.validation_set_display_name
1633: FROM
1634: IBY_VALIDATION_SETS_VL val,
1635: IBY_VAL_ASSIGNMENTS val_options,
1636: IBY_DOCS_PAYABLE_GT docs
1637: WHERE
1638: docs.document_payable_id = p_document_payable_id
1639: AND
1640: val.validation_set_code = val_options.validation_set_code
2469: * However, only document id is guaranteed to be available.
2470: * Other fields like payer id, payee id, internal bank account id,
2471: * external bank acount id etc. may or may not be provided.
2472: * Therefore, perform an outer join with all entities other than
2473: * the IBY_DOCS_PAYABLE_GT.
2474: */
2475: CURSOR c_onlineDocumentInfo(p_doc_id
2476: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE)
2477: RETURN documentRecType
2551: * Normally, this cursor c_onlineDocumentInfo, and the cursor
2552: * above c_documentInfo are in sync. This means that both
2553: * cursors pick up the same data except that the
2554: * online document cursor picks up the document attributes
2555: * from IBY_DOCS_PAYABLE_GT whereas the offline
2556: * document validation cursor picks up the document
2557: * attributes from IBY_DOCS_PAYABLE_ALL table.
2558: *
2559: * In fix for bug 5997016, we made the offline doc validation
2563: * In the online validation cursor, we will not propagate
2564: * the same logic. There are some reasons for this -
2565: *
2566: * 1. Some columns that are present in IBY_DOCS_PAYABLE_ALL
2567: * table are not present in IBY_DOCS_PAYABLE_GT table.
2568: * E.g., address_source is not available in the GT table.
2569: * Therefore, to support the dynamic payee address
2570: * functionality we would need to make a data model change.
2571: *
2606: docs.payment_method_code payment_method_cd,
2607: docs.payment_format_code payee_payment_format_cd
2608:
2609: FROM
2610: IBY_DOCS_PAYABLE_GT docs,
2611: IBY_PP_FIRST_PARTY_V payer,
2612: HZ_PARTIES payee,
2613: HZ_LOCATIONS payee_loc,
2614: CE_BANK_ACCOUNTS iba,
2674: docs.calling_app_doc_unique_ref5 calling_app_doc_id5,
2675: docs.pay_proc_trxn_type_code pay_proc_trxn_type_cd,
2676: docs.document_payable_id document_id
2677: FROM
2678: IBY_DOCS_PAYABLE_GT docs
2679: WHERE
2680: docs.document_payable_id = p_doc_id
2681: ;
2682: