DBA Data[Home] [Help]

APPS.INV_LABEL_PVT10 dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 840: l_organization_name org_organization_definitions.organization_name%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;
844: l_ship_from_location_id hz_locations.location_id%TYPE;

Line 1260: ORG_ORGANIZATION_DEFINITIONS ORG

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
1262: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
1263: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
1264: and acct_site.status='A'