[Home] [Help]
2193: */
2194: CURSOR
2195: c_val_sets(p_document_payable_id VARCHAR2)
2196: IS
2197: SELECT /*+ INDEX(docs IBY_DOCS_PAYABLE_GT_N1) NO_EXPAND */
2198: docs.document_payable_id,
2199: val.validation_set_code,
2200: val.validation_code_package,
2201: val.validation_code_entry_point,
2204: val.validation_set_display_name
2205: FROM
2206: IBY_VALIDATION_SETS_VL val,
2207: IBY_VAL_ASSIGNMENTS val_options,
2208: IBY_DOCS_PAYABLE_GT docs,
2209: IBY_VALIDATION_VALUES vld_val
2210: WHERE
2211: docs.document_payable_id = p_document_payable_id
2212: AND
2478: * However, only document id is guaranteed to be available.
2479: * Other fields like payer id, payee id, internal bank account id,
2480: * external bank acount id etc. may or may not be provided.
2481: * Therefore, perform an outer join with all entities other than
2482: * the IBY_DOCS_PAYABLE_GT.
2483: */
2484: CURSOR c_onlineDocumentInfo(p_doc_id
2485: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE)
2486: RETURN documentRecType
2569: * Normally, this cursor c_onlineDocumentInfo, and the cursor
2570: * above c_documentInfo are in sync. This means that both
2571: * cursors pick up the same data except that the
2572: * online document cursor picks up the document attributes
2573: * from IBY_DOCS_PAYABLE_GT whereas the offline
2574: * document validation cursor picks up the document
2575: * attributes from IBY_DOCS_PAYABLE_ALL table.
2576: *
2577: * In fix for bug 5997016, we made the offline doc validation
2581: * In the online validation cursor, we will not propagate
2582: * the same logic. There are some reasons for this -
2583: *
2584: * 1. Some columns that are present in IBY_DOCS_PAYABLE_ALL
2585: * table are not present in IBY_DOCS_PAYABLE_GT table.
2586: * E.g., address_source is not available in the GT table.
2587: * Therefore, to support the dynamic payee address
2588: * functionality we would need to make a data model change.
2589: *
2625: docs.payment_format_code payee_payment_format_cd,
2626: payeesite.party_site_name payee_party_site_name
2627:
2628: FROM
2629: IBY_DOCS_PAYABLE_GT docs,
2630: IBY_PP_FIRST_PARTY_V payer,
2631: HZ_PARTIES payee,
2632: HZ_PARTY_SITES payeesite,
2633: HZ_LOCATIONS payee_loc,
2697: docs.calling_app_doc_unique_ref5 calling_app_doc_id5,
2698: docs.pay_proc_trxn_type_code pay_proc_trxn_type_cd,
2699: docs.document_payable_id document_id
2700: FROM
2701: IBY_DOCS_PAYABLE_GT docs
2702: WHERE
2703: docs.document_payable_id = p_doc_id
2704: ;
2705: