Results for “total_ordered_amount”
50+ results
-
View: AMS_P_ORGANIZATION_V 12.2.2
This View returns all entries from the HZ_PARTIES table which have a party_type of ORGANIZATION. Used for list generation.
-
View: AMS_P_ORGANIZATION_V 12.1.1
This View returns all entries from the HZ_PARTIES table which have a party_type of ORGANIZATION. Used for list generation.
-
Data Source view to get information about b2c contacts
APPS.AMS_LT_PERSON_DETAILS_V·↳ HZ_PARTIES·Explore AMS module →
-
It returns the Missing items for Post Admission Requirements
APPS.IGS_AD_POSTADM_MISS_ITM_LTR_V·↳ HZ_PARTIES·↳ IGS_AD_APLINS_ADMREQ·↳ IGS_AD_APPL_ALL·Explore IGS module →
-
View: AMS_ORGANIZATION_V 12.2.2
This View returns all entries from the HZ_PARTIES table which have a party_type of ORGANIZATION. Used for list generation.
-
View: AS_PARTY_CUSTOMERS_V 12.1.1
This view is only a wrapper view of HZ_PARTIES
-
View: AMS_ORGANIZATION_V 12.1.1
This View returns all entries from the HZ_PARTIES table which have a party_type of ORGANIZATION. Used for list generation.
-
View: IGF_AW_PER_LIST_V 12.1.1
Stores person details used for correspondence
APPS.IGF_AW_PER_LIST_V·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_AWARD_ALL·Explore IGF module →
-
View: AS_PARTY_CUSTOMERS_V 12.2.2
This view is only a wrapper view of HZ_PARTIES
-
Person Profiles
APPS.HZ_PERSON_PROFILES_CPUI_V·↳ HZ_PARTIES·↳ HZ_PERSON_PROFILES·Explore AR module →
-
View: IGF_AP_MIS_ITMS_LTR_V 12.1.1
This view is used to return the missing items (missing documents) which are required for Financial Aid processing
APPS.IGF_AP_MIS_ITMS_LTR_V·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AP_ST_CORR_TEXT·Explore IGF module →
-
View: IGF_SL_DISB_LTR_V 12.1.1
Stores persons loan details used for correspondence
APPS.IGF_SL_DISB_LTR_V·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_AWARD_ALL·Explore IGF module →
-
View: IGF_AW_AWD_LTR_V 12.1.1
This view selects relevant data for the Award Notification Letter to be sent to a Student
APPS.IGF_AW_AWD_LTR_V·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_AWD_LTR_TMP·Explore IGF module →
-
View: AST_ORG_PARTIES_V 12.2.2
-
View: HZ_ORG_PROFILES_CPUI_V 12.1.1
Organization Profiles
APPS.HZ_ORG_PROFILES_CPUI_V·↳ HZ_ORGANIZATION_PROFILES·↳ HZ_PARTIES·Explore AR module →
-
View: AST_ORG_V 12.1.1
APPS.AST_ORG_V·↳ AR_LOOKUPS·↳ HZ_CONTACT_POINTS·↳ HZ_PARTIES·Explore AST module →
-
View: AST_ORG_PROFILES_V 12.1.1
APPS.AST_ORG_PROFILES_V·↳ AR_LOOKUPS·↳ HZ_ORGANIZATION_PROFILES·↳ HZ_PARTIES·Explore AST module →
-
View: AST_PERSON_PROFILE_V 12.2.2
APPS.AST_PERSON_PROFILE_V·↳ AR_LOOKUPS·↳ FND_GLOBAL·↳ FND_LOOKUPS·Explore AST module →
-
Person Profiles
APPS.HZ_PERSON_PROFILES_CPUI_V·↳ HZ_PARTIES·↳ HZ_PERSON_PROFILES·Explore AR module →
-
View: AMS_HZ_B2B_MAPPING_V 12.1.1
This view stores the mapping of ams_imp_source_lines table. This is used to populate the data from the data file.
APPS.AMS_HZ_B2B_MAPPING_V·↳ AMS_IMP_LIST_HEADERS_ALL·↳ AMS_IMP_SOURCE_LINES·Explore AMS module →
-
View: AMS_LEAD_MAPPING_V 12.1.1
This view stores the mapping of ams_imp_source_lines table. This is used to populate the data from the data file.
APPS.AMS_LEAD_MAPPING_V·↳ AMS_IMP_SOURCE_LINES·Explore AMS module →
-
View: IGS_AD_ACK_LETTER_V 12.1.1
It would return the Acknowledgement Details of a student
APPS.IGS_AD_ACK_LETTER_V·↳ HZ_PARTIES·↳ IGS_AD_APPL_ADMAPPL_V·↳ IGS_AD_APPL_STAT·Explore IGS module →
-
View: HZ_PERSON_PROFILES_V 12.1.1
APPS.HZ_PERSON_PROFILES_V·↳ HZ_PARTIES·↳ HZ_PERSON_PROFILES·Explore AR module →
-
APPS.HZ_PARTY_CONTACT_POINTS_V·↳ HZ_CONTACT_POINTS·↳ HZ_PARTIES·Explore AR module →
-
APPS.HZ_ORGANIZATION_PROFILES_V·↳ HZ_ORGANIZATION_PROFILES·↳ HZ_PARTIES·Explore AR module →
-
View: AMS_PERSON_DETAILS_V 12.1.1
Information about parties such as people.
APPS.AMS_PERSON_DETAILS_V·↳ HZ_CONTACT_POINTS·↳ HZ_LOCATIONS·↳ HZ_PARTIES·Explore AMS module →
-
Returns the missing items. For processing application of the student, few documents are required by the admission module. When student forget to send any document or miss out any document , then these documents are treated as missing items
APPS.IGS_AD_MISSING_ITEMS_LETTER_V·↳ HZ_PARTIES·↳ IGS_AD_APLINS_ADMREQ·↳ IGS_AD_APPL_ALL·Explore IGS module →
-
The validations for the individual letters are placed at the SQLl query level that we attach to master document
APPS.IGS_AD_OUTCOME_LETTERS_V·↳ HZ_PARTIES·↳ IGS_AD_APPL_ADMAPPL_V·↳ IGS_AD_APPL_ALL·Explore IGS module →
-
View: AMS_PERSON_DETAILS_V 12.2.2
Information about parties such as people.
APPS.AMS_PERSON_DETAILS_V·↳ HZ_CONTACT_POINTS·↳ HZ_LOCATIONS·↳ HZ_PARTIES·Explore AMS module →
-
Data Source view to get information about b2c contacts
APPS.AMS_LT_PERSON_DETAILS_V·↳ HZ_PARTIES·Explore AMS module →
-
staging table to hold data to be imported
-
View: AMS_PARTY_CUSTOMERS_V 12.1.1
This view retuns all the parties(both Persons and Organizations)
APPS.AMS_PARTY_CUSTOMERS_V·↳ HZ_PARTIES·Explore AMS module →
-
View: AMS_PARTY_CUSTOMERS_V 12.2.2
This view retuns all the parties(both Persons and Organizations)
APPS.AMS_PARTY_CUSTOMERS_V·↳ HZ_PARTIES·Explore AMS module →
-
Information about parties such as organizations, people, and groups
-
View: AST_ORG_PARTIES_V 12.1.1
-
View: AST_ORG_V 12.2.2
APPS.AST_ORG_V·↳ AR_LOOKUPS·↳ HZ_CONTACT_POINTS·↳ HZ_PARTIES·Explore AST module →
-
View: IGS_AD_RESI_LETTER_V 12.1.1
It would return the Residency Details of a student
APPS.IGS_AD_RESI_LETTER_V·↳ HZ_PARTIES·↳ IGS_AD_APPL·↳ IGS_CA_INST·Explore IGS module →
-
View: AST_ORG_PROFILES_V 12.2.2
APPS.AST_ORG_PROFILES_V·↳ AR_LOOKUPS·↳ HZ_ORGANIZATION_PROFILES·↳ HZ_PARTIES·Explore AST module →
-
View: AST_PERSON_PROFILE_V 12.1.1
APPS.AST_PERSON_PROFILE_V·↳ AR_LOOKUPS·↳ FND_GLOBAL·↳ FND_LOOKUPS·Explore AST module →
-
View: HZ_PERSON_PROFILES_V 12.2.2
APPS.HZ_PERSON_PROFILES_V·↳ HZ_PARTIES·↳ HZ_PERSON_PROFILES·Explore AR module →
-
View: HZ_ORG_PROFILES_CPUI_V 12.2.2
Organization Profiles
APPS.HZ_ORG_PROFILES_CPUI_V·↳ HZ_ORGANIZATION_PROFILES·↳ HZ_PARTIES·Explore AR module →
-
View: AMS_LEAD_MAPPING_V 12.2.2
This view stores the mapping of ams_imp_source_lines table. This is used to populate the data from the data file.
APPS.AMS_LEAD_MAPPING_V·↳ AMS_IMP_SOURCE_LINES·Explore AMS module →
-
View: AMS_HZ_B2B_MAPPING_V 12.2.2
This view stores the mapping of ams_imp_source_lines table. This is used to populate the data from the data file.
APPS.AMS_HZ_B2B_MAPPING_V·↳ AMS_IMP_LIST_HEADERS_ALL·↳ AMS_IMP_SOURCE_LINES·Explore AMS module →
-
APPS.HZ_PARTY_CONTACT_POINTS_V·↳ HZ_CONTACT_POINTS·↳ HZ_PARTIES·Explore AR module →
-
APPS.HZ_ORGANIZATION_PROFILES_V·↳ HZ_ORGANIZATION_PROFILES·↳ HZ_PARTIES·Explore AR module →
-
View: AMS_ORG_DETAILS_V 12.2.2
This view list the details of an Organization
APPS.AMS_ORG_DETAILS_V·↳ HZ_CONTACT_POINTS·↳ HZ_LOCATIONS·↳ HZ_ORGANIZATION_PROFILES·Explore AMS module →
-
View: AMS_ORG_DETAILS_V 12.1.1
This view list the details of an Organization
APPS.AMS_ORG_DETAILS_V·↳ HZ_CONTACT_POINTS·↳ HZ_LOCATIONS·↳ HZ_ORGANIZATION_PROFILES·Explore AMS module →
-
Information about parties such as organizations, people, and groups
-
staging table to hold data to be imported