VIEW: APPS.HRDPV_CREATE_LOCATION

Source

View Text - Preformatted

select batch_id            batch_id
,      batch_line_id       batch_line_id
,      api_module_id       api_module_id
,      line_status         line_status
,      user_sequence       user_sequence
,      link_value          link_value
,      business_group_name business_group_name,
       pval001 P_EFFECTIVE_DATE,
       pval002 P_LANGUAGE_CODE,
       pval003 P_LOCATION_CODE,
       pval004 P_DESCRIPTION,
       pval005 P_TIMEZONE_CODE,
       pval006 P_TP_HEADER_ID,
       pval007 P_ECE_TP_LOCATION_CODE,
       pval008 P_ADDRESS_LINE_1,
       pval009 P_ADDRESS_LINE_2,
       pval010 P_ADDRESS_LINE_3,
       pval011 P_BILL_TO_SITE_FLAG,
       pval012 P_COUNTRY,
       pval013 P_IN_ORGANIZATION_FLAG,
       pval014 P_INACTIVE_DATE,
       pval015 P_OPERATING_UNIT_ID,
       pval016 P_INVENTORY_ORGANIZATION_ID,
       pval017 P_OFFICE_SITE_FLAG,
       pval018 P_POSTAL_CODE,
       pval019 P_RECEIVING_SITE_FLAG,
       pval020 P_REGION_1,
       pval021 P_REGION_2,
       pval022 P_REGION_3,
       pval023 P_SHIP_TO_SITE_FLAG,
       pval024 P_STYLE,
       pval025 P_TAX_NAME,
       pval026 P_TELEPHONE_NUMBER_1,
       pval027 P_TELEPHONE_NUMBER_2,
       pval028 P_TELEPHONE_NUMBER_3,
       pval029 P_TOWN_OR_CITY,
       pval030 P_LOC_INFORMATION13,
       pval031 P_LOC_INFORMATION14,
       pval032 P_LOC_INFORMATION15,
       pval033 P_LOC_INFORMATION16,
       pval034 P_LOC_INFORMATION17,
       pval035 P_LOC_INFORMATION18,
       pval036 P_LOC_INFORMATION19,
       pval037 P_LOC_INFORMATION20,
       pval038 P_ATTRIBUTE_CATEGORY,
       pval039 P_ATTRIBUTE1,
       pval040 P_ATTRIBUTE2,
       pval041 P_ATTRIBUTE3,
       pval042 P_ATTRIBUTE4,
       pval043 P_ATTRIBUTE5,
       pval044 P_ATTRIBUTE6,
       pval045 P_ATTRIBUTE7,
       pval046 P_ATTRIBUTE8,
       pval047 P_ATTRIBUTE9,
       pval048 P_ATTRIBUTE10,
       pval049 P_ATTRIBUTE11,
       pval050 P_ATTRIBUTE12,
       pval051 P_ATTRIBUTE13,
       pval052 P_ATTRIBUTE14,
       pval053 P_ATTRIBUTE15,
       pval054 P_ATTRIBUTE16,
       pval055 P_ATTRIBUTE17,
       pval056 P_ATTRIBUTE18,
       pval057 P_ATTRIBUTE19,
       pval058 P_ATTRIBUTE20,
       pval059 P_GLOBAL_ATTRIBUTE_CATEGORY,
       pval060 P_GLOBAL_ATTRIBUTE1,
       pval061 P_GLOBAL_ATTRIBUTE2,
       pval062 P_GLOBAL_ATTRIBUTE3,
       pval063 P_GLOBAL_ATTRIBUTE4,
       pval064 P_GLOBAL_ATTRIBUTE5,
       pval065 P_GLOBAL_ATTRIBUTE6,
       pval066 P_GLOBAL_ATTRIBUTE7,
       pval067 P_GLOBAL_ATTRIBUTE8,
       pval068 P_GLOBAL_ATTRIBUTE9,
       pval069 P_GLOBAL_ATTRIBUTE10,
       pval070 P_GLOBAL_ATTRIBUTE11,
       pval071 P_GLOBAL_ATTRIBUTE12,
       pval072 P_GLOBAL_ATTRIBUTE13,
       pval073 P_GLOBAL_ATTRIBUTE14,
       pval074 P_GLOBAL_ATTRIBUTE15,
       pval075 P_GLOBAL_ATTRIBUTE16,
       pval076 P_GLOBAL_ATTRIBUTE17,
       pval077 P_GLOBAL_ATTRIBUTE18,
       pval078 P_GLOBAL_ATTRIBUTE19,
       pval079 P_GLOBAL_ATTRIBUTE20,
       pval080 P_LOCATION_USER_KEY,
       pval081 P_OBJECT_VERSION_NUMBER,
       pval082 P_DESIGNATED_RECEIVER_NAME,
       pval083 P_SHIP_TO_LOCATION_CODE
from hr_pump_batch_lines
where api_module_id = 1266
with check option 

View Text - HTML Formatted

SELECT BATCH_ID BATCH_ID
, BATCH_LINE_ID BATCH_LINE_ID
, API_MODULE_ID API_MODULE_ID
, LINE_STATUS LINE_STATUS
, USER_SEQUENCE USER_SEQUENCE
, LINK_VALUE LINK_VALUE
, BUSINESS_GROUP_NAME BUSINESS_GROUP_NAME
, PVAL001 P_EFFECTIVE_DATE
, PVAL002 P_LANGUAGE_CODE
, PVAL003 P_LOCATION_CODE
, PVAL004 P_DESCRIPTION
, PVAL005 P_TIMEZONE_CODE
, PVAL006 P_TP_HEADER_ID
, PVAL007 P_ECE_TP_LOCATION_CODE
, PVAL008 P_ADDRESS_LINE_1
, PVAL009 P_ADDRESS_LINE_2
, PVAL010 P_ADDRESS_LINE_3
, PVAL011 P_BILL_TO_SITE_FLAG
, PVAL012 P_COUNTRY
, PVAL013 P_IN_ORGANIZATION_FLAG
, PVAL014 P_INACTIVE_DATE
, PVAL015 P_OPERATING_UNIT_ID
, PVAL016 P_INVENTORY_ORGANIZATION_ID
, PVAL017 P_OFFICE_SITE_FLAG
, PVAL018 P_POSTAL_CODE
, PVAL019 P_RECEIVING_SITE_FLAG
, PVAL020 P_REGION_1
, PVAL021 P_REGION_2
, PVAL022 P_REGION_3
, PVAL023 P_SHIP_TO_SITE_FLAG
, PVAL024 P_STYLE
, PVAL025 P_TAX_NAME
, PVAL026 P_TELEPHONE_NUMBER_1
, PVAL027 P_TELEPHONE_NUMBER_2
, PVAL028 P_TELEPHONE_NUMBER_3
, PVAL029 P_TOWN_OR_CITY
, PVAL030 P_LOC_INFORMATION13
, PVAL031 P_LOC_INFORMATION14
, PVAL032 P_LOC_INFORMATION15
, PVAL033 P_LOC_INFORMATION16
, PVAL034 P_LOC_INFORMATION17
, PVAL035 P_LOC_INFORMATION18
, PVAL036 P_LOC_INFORMATION19
, PVAL037 P_LOC_INFORMATION20
, PVAL038 P_ATTRIBUTE_CATEGORY
, PVAL039 P_ATTRIBUTE1
, PVAL040 P_ATTRIBUTE2
, PVAL041 P_ATTRIBUTE3
, PVAL042 P_ATTRIBUTE4
, PVAL043 P_ATTRIBUTE5
, PVAL044 P_ATTRIBUTE6
, PVAL045 P_ATTRIBUTE7
, PVAL046 P_ATTRIBUTE8
, PVAL047 P_ATTRIBUTE9
, PVAL048 P_ATTRIBUTE10
, PVAL049 P_ATTRIBUTE11
, PVAL050 P_ATTRIBUTE12
, PVAL051 P_ATTRIBUTE13
, PVAL052 P_ATTRIBUTE14
, PVAL053 P_ATTRIBUTE15
, PVAL054 P_ATTRIBUTE16
, PVAL055 P_ATTRIBUTE17
, PVAL056 P_ATTRIBUTE18
, PVAL057 P_ATTRIBUTE19
, PVAL058 P_ATTRIBUTE20
, PVAL059 P_GLOBAL_ATTRIBUTE_CATEGORY
, PVAL060 P_GLOBAL_ATTRIBUTE1
, PVAL061 P_GLOBAL_ATTRIBUTE2
, PVAL062 P_GLOBAL_ATTRIBUTE3
, PVAL063 P_GLOBAL_ATTRIBUTE4
, PVAL064 P_GLOBAL_ATTRIBUTE5
, PVAL065 P_GLOBAL_ATTRIBUTE6
, PVAL066 P_GLOBAL_ATTRIBUTE7
, PVAL067 P_GLOBAL_ATTRIBUTE8
, PVAL068 P_GLOBAL_ATTRIBUTE9
, PVAL069 P_GLOBAL_ATTRIBUTE10
, PVAL070 P_GLOBAL_ATTRIBUTE11
, PVAL071 P_GLOBAL_ATTRIBUTE12
, PVAL072 P_GLOBAL_ATTRIBUTE13
, PVAL073 P_GLOBAL_ATTRIBUTE14
, PVAL074 P_GLOBAL_ATTRIBUTE15
, PVAL075 P_GLOBAL_ATTRIBUTE16
, PVAL076 P_GLOBAL_ATTRIBUTE17
, PVAL077 P_GLOBAL_ATTRIBUTE18
, PVAL078 P_GLOBAL_ATTRIBUTE19
, PVAL079 P_GLOBAL_ATTRIBUTE20
, PVAL080 P_LOCATION_USER_KEY
, PVAL081 P_OBJECT_VERSION_NUMBER
, PVAL082 P_DESIGNATED_RECEIVER_NAME
, PVAL083 P_SHIP_TO_LOCATION_CODE FROM HR_PUMP_BATCH_LINES WHERE API_MODULE_ID = 1266 WITH CHECK OPTION