APPS.INV_CUSTOMER_ITEM_GRP dependencies on HZ_CUST_ACCT_SITES_ALL

Line 452: HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES_ALL ACCT_SITE

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

Line 461: FROM HZ_CUST_ACCT_SITES_ALL ACCT_SITE

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

Line 542: HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES_ALL ACCT_SITE

538:
539: SELECT ACCT_SITE.CUSTOMER_CATEGORY_CODE
540: INTO RA_Address_Category
541: FROM HZ_PARTY_SITES PARTY_SITE, HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
542: HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES_ALL ACCT_SITE
543: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = Y_Address_Id
544: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
545: AND LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID AND NVL(ACCT_SITE.ORG_ID, -99) = NVL(LOC_ASSIGN.ORG_ID, -99)
546: AND NVL(ACCT_SITE.ORG_ID,

Line 554: FROM HZ_CUST_ACCT_SITES_ALL ACCT_SITE

550: SUBSTRB(USERENV('CLIENT_INFO'),1,10))),- 99);
551: 5064537 */
552: SELECT ACCT_SITE.CUSTOMER_CATEGORY_CODE
553: INTO RA_Address_Category
554: FROM HZ_CUST_ACCT_SITES_ALL ACCT_SITE
555: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = Y_Address_Id;
556:
557: IF (Temp_Customer_Category_Code =
558: RA_Address_Category) THEN

Line 624: HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES_ALL ACCT_SITE

620:
621: SELECT ACCT_SITE.CUSTOMER_CATEGORY_CODE
622: INTO RA_Address_Category
623: FROM HZ_PARTY_SITES PARTY_SITE, HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
624: HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES_ALL ACCT_SITE
625: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = Y_Address_Id
626: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
627: AND LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID AND NVL(ACCT_SITE.ORG_ID, -99) = NVL(LOC_ASSIGN.ORG_ID, -99)
628: AND NVL(ACCT_SITE.ORG_ID,

Line 636: FROM HZ_CUST_ACCT_SITES_ALL ACCT_SITE

632: SUBSTRB(USERENV('CLIENT_INFO'),1,10))),- 99);
633: 5064537 */
634: SELECT ACCT_SITE.CUSTOMER_CATEGORY_CODE
635: INTO RA_Address_Category
636: FROM HZ_CUST_ACCT_SITES_ALL ACCT_SITE
637: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = Y_Address_Id;
638:
639: IF (Temp_Customer_Category_Code =
640: RA_Address_Category) THEN