A query containing a subquery is executed. By default, in Salesforce B2B Commerce, "__ccrz" is appended to the subquery name as part of its transformation. This is done to avoid conflicts with the standard Salesforce fields and relationships. For example, SELECT Id, Name, (SELECT Id, Name FROM Contacts) FROM Account will be transformed to SELECT Id, Name, (SELECT Id, Name FROM Contacts__ccrz) FROM Account__ccrz. Salesforce Reference: B2B Commerce and D2C Commerce Developer Guide, Query Transformation

To retrieve metadata about a specific object in a Lightning Web Component, a developer can use the getObjectInfowire adapter. This adapter provides access to the metadata of a specified Salesforce object, including fields, record types, and layouts, which is essential for dynamic component rendering based on the object's schema.

One way of preventing an existing payment page from being shown on the checkout payment page is to remove the payment type associated with the payment page from CO.pmts, then rebuild and activate a new cache. This will exclude the payment type from the list of available payment options on the checkout page. The other options are either not feasible or not effective in hiding the payment page. Salesforce Reference: B2B Commerce and D2C Commerce Developer Guide, Payment Configuration Settings