SELECT EXTENSION_ID , INVENTORY_ITEM_ID , MASTER_ORGANIZATION_ID , PARTY_SITE_ID , PAYMENT_METHOD_TYPE , AUTO_CLEARING_HOUSE_PAY_FMT FROM EGO_SBDH_PAYMENT_METHOD_TPAGV UNION ALL SELECT EXTENSION_ID , INVENTORY_ITEM_ID , MASTER_ORGANIZATION_ID , PARTY_SITE_ID , PAYMENT_METHOD_TYPE , AUTO_CLEARING_HOUSE_PAY_FMT FROM (SELECT NULL PARTY_SITE_ID, ITEMAGV.* , ITEMAGV.ORGANIZATION_ID MASTER_ORGANIZATION_ID FROM EGO_SBDH_PAYMENT_METHOD_AGV ITEMAGV )
SELECT EXTENSION_ID
, INVENTORY_ITEM_ID
, MASTER_ORGANIZATION_ID
, PARTY_SITE_ID
, PAYMENT_METHOD_TYPE
, AUTO_CLEARING_HOUSE_PAY_FMT
FROM EGO_SBDH_PAYMENT_METHOD_TPAGV UNION ALL SELECT EXTENSION_ID
, INVENTORY_ITEM_ID
, MASTER_ORGANIZATION_ID
, PARTY_SITE_ID
, PAYMENT_METHOD_TYPE
, AUTO_CLEARING_HOUSE_PAY_FMT
FROM (SELECT NULL PARTY_SITE_ID
, ITEMAGV.*
, ITEMAGV.ORGANIZATION_ID MASTER_ORGANIZATION_ID
FROM EGO_SBDH_PAYMENT_METHOD_AGV ITEMAGV )
|
|
|