APPS.INV_CUSTOMER_ITEM_GRP dependencies on HZ_CUST_ACCT_SITES_ALL

Line 449: HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES_ALL ACCT_SITE

445: WHERE ADDRESS_ID = v_Address_Id; */
446:
447: /* SELECT ACCT_SITE.CUST_ACCOUNT_ID
448: FROM HZ_PARTY_SITES PARTY_SITE, HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
449: HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES_ALL ACCT_SITE
450: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = v_Address_Id
451: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
452: AND LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID AND NVL(ACCT_SITE.ORG_ID, -99) = NVL(LOC_ASSIGN.ORG_ID, -99)
453: AND NVL(ACCT_SITE.ORG_ID, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,

Line 458: FROM HZ_CUST_ACCT_SITES_ALL ACCT_SITE

454: SUBSTRB(USERENV('CLIENT_INFO'),1,10))),- 99)) =
455: NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ', NULL,
456: SUBSTRB(USERENV('CLIENT_INFO'),1,10))),- 99);*/
457: SELECT ACCT_SITE.CUST_ACCOUNT_ID
458: FROM HZ_CUST_ACCT_SITES_ALL ACCT_SITE
459: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = v_Address_Id;
460:
461: BEGIN
462:

Line 535: HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES_ALL ACCT_SITE

531:
532: SELECT ACCT_SITE.CUSTOMER_CATEGORY_CODE
533: INTO RA_Address_Category
534: FROM HZ_PARTY_SITES PARTY_SITE, HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
535: HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES_ALL ACCT_SITE
536: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = Y_Address_Id
537: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
538: AND LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID AND NVL(ACCT_SITE.ORG_ID, -99) = NVL(LOC_ASSIGN.ORG_ID, -99)
539: AND NVL(ACCT_SITE.ORG_ID,

Line 547: FROM HZ_CUST_ACCT_SITES_ALL ACCT_SITE

543: SUBSTRB(USERENV('CLIENT_INFO'),1,10))),- 99);
544: 5064537 */
545: SELECT ACCT_SITE.CUSTOMER_CATEGORY_CODE
546: INTO RA_Address_Category
547: FROM HZ_CUST_ACCT_SITES_ALL ACCT_SITE
548: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = Y_Address_Id;
549:
550: IF (Temp_Customer_Category_Code =
551: RA_Address_Category) THEN