Need Data base Oracle tables stored ThirdPartyOrganizationPaymentMethod details.
I am working on a conversion BIP report for ThirdPartyOrganizationPaymentMethod .
Can you please share a sample SQL to query these information we loaded using HDL.
METADATA|ThirdPartyOrganizationPaymentMethod|EffectiveStartDate|LegislativeDataGroupName|SourceSystemOwner|SourceSystemId|OrganizationPaymentMethodCode|PartyNumber
MERGE|ThirdPartyOrganizationPaymentMethod|2024/03/01|Test Legislative Data Group|PSOFT|TEST_ORG_PMT_MTD|Third Party Pay by Check|999068
At least the tables which stores information such as Effective_start_date, OrganizationPaymentMethodCode and PartyNumber . I see that HZ_parties tables stores few information related to this object. Please advise if I can go ahead with this.
Let me know what are additional tables to be joined with this tables.