DBA Data[Home] [Help]

APPS.INV_LABEL_PVT10 dependencies on HZ_CUST_SITE_USES_ALL

Line 839: l_location_name hz_cust_site_uses_all.location%TYPE;

835: l_invoice_to_org_id oe_order_headers_all.invoice_to_org_id%TYPE;
836: l_deliver_to_org_id oe_order_headers_all.deliver_to_org_id%TYPE;
837: l_organization_code mtl_parameters.organization_code%TYPE;
838: l_location_id hz_locations.location_id%TYPE;
839: l_location_name hz_cust_site_uses_all.location%TYPE;
840: l_organization_name org_organization_definitions.organization_name%TYPE;
841: l_customer_number hz_cust_accounts.account_number%TYPE;
842: l_sold_from_location_id hz_locations.location_id%TYPE;
843: l_sold_to_location_id hz_locations.location_id%TYPE;

Line 1257: HZ_CUST_SITE_USES_ALL SITE,

1253: --cust_acct.cust_account_id customer_id
1254: FROM
1255: HZ_CUST_ACCT_SITES_ALL ACCT_SITE,
1256: HZ_PARTY_SITES PARTY_SITE,
1257: HZ_CUST_SITE_USES_ALL SITE,
1258: HZ_PARTIES PARTY,
1259: HZ_CUST_ACCOUNTS CUST_ACCT,
1260: ORG_ORGANIZATION_DEFINITIONS ORG
1261: WHERE SITE.ORG_ID = ORG.ORGANIZATION_ID