eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.EDWBV_TPRT_TRADE_PARTNER_LCV

Source

View Text - Preformatted


SELECT hzca.cust_account_id || '-' || inst.instance_code || '-' || 'CUST_ACCT', NULL, substrb(parties.party_name,1,80) || '(' || hzca.account_number || ')', substrb(parties.party_name,1,80) || '(' || hzca.account_number || ')', parties.organization_name_phonetic, hzca.account_activation_date, hzca.account_termination_date, parties.sic_code, parties.tax_reference, parties.jgzz_fiscal_code, apt.name, NULL, /* vndr_number (?parties.party_number?) */ NULL, /* vndr_type (?parties.party_type?) */ NULL, /* vnd.one_time_flag,*/ NULL, /* vnd.minority_group_lookup_code, */ NULL, /* vnd.women_owned_flag, */ NULL, /* vnd.small_business_flag, */ NULL, /* vnd.hold_flag, */ NULL, /* vnd.inspection_required_flag, */ NULL, /* vnd.receipt_required_flag, */ NULL, /* vnd.allow_substitute_receipts_flag, */ NULL, /* vnd.allow_unordered_receipts_flag, */ hzca.account_number, hzca.orig_system_reference, hzca.status, hzca.customer_type, decode(parties.TOTAL_NUM_OF_ORDERS,0,'PROSPECT',1,'CUSTOMER','CUSTOMER'), hzca.customer_class_code, NULL, /* for salesrep, no org_id, can't find salesreps */ hzca.sales_channel_code, ot.name, substrb(pl.name, 1, 40), parties.analysis_fy, NULL, /* hzca.category_code,*****NOT IN INTERNALS***** */ substrb(parties.customer_key,1,80), parties.fiscal_yearend_month, parties.employees_total, parties.curr_fy_potential_revenue, parties.next_fy_potential_revenue, NULL, /* hzca.reference_use_flag,*****NOT IN INTERNALS***** */ hzca.tax_code, NULL, /* hzca.third_party_flag,*****NOT IN INTERNALS***** */ NULL, /* access_template_entity_code ***obsoleted*** */ NULL, /* hzca.competitor_flag,*****NOT IN INTERNALS***** */ NULL, /* orig_system ***obsoleted*** */ parties.year_established, hzca.coterminate_day_month, hzca.fob_point, hzca.freight_term, parties.gsa_indicator_flag, hzca.ship_partial, hzca.ship_via, parties.do_not_mail_flag, hzca.tax_header_level_flag, hzca.tax_rounding_rule, NULL, /* user_attribute 1-5 */ NULL, NULL, NULL, NULL, greatest(hzca.last_update_date, parties.last_update_date), hzca.creation_date, NULL, /* operation_code */ hzca.party_id, hzca.cust_account_id, inst.instance_code, '_DF:_DUMMY:PO:PO_VENDORS:vnd', '_DF:AR:HZ_PARTIES:parties', '_DF:AR:RA_CUSTOMERS_HZ:hzca' FROM edw_local_instance inst, (select transaction_type_id, name from oe_transaction_types_tl WHERE language = userenv('LANG')) ot, (select price_list_id, name from so_price_lists_tl where language = userenv('LANG')) pl, (select term_id, name from ap_terms_tl where language = userenv('LANG')) apt, hz_cust_accounts hzca, hz_parties parties WHERE hzca.order_type_id = ot.transaction_type_id (+) AND hzca.payment_term_id = apt.term_id (+) AND hzca.price_list_id = pl.price_list_id (+) AND hzca.party_id = parties.party_id UNION ALL /* VENDORS FROM PO_VENDORS ONLY (with parents) */ /*For level > 4, parent_tpartner_fk will be populated in the push program*/ SELECT vnd.vendor_id || '-' || inst.instance_code || '-' || 'SUPPLIER', DECODE(ele.hierarchy_level, 1, vnd.vendor_id ||'-'|| inst.instance_code ||'-'|| 'SUPPLIER', 2, vnd.vendor_id ||'-'|| inst.instance_code ||'-'|| 'SUPPLIER', 3, vnd.vendor_id ||'-'|| inst.instance_code ||'-'|| 'SUPPLIER', 4, ele.parent_vendor_id ||'-'|| inst.instance_code ||'-'|| 'SUPPLIER', NULL), vnd.vendor_name, vnd.vendor_name, vnd.vendor_name_alt, vnd.start_date_active, vnd.end_date_active, vnd.standard_industry_class, vnd.vat_registration_num, vnd.num_1099, apt.name, vnd.segment1, vnd.vendor_type_lookup_code, vnd.one_time_flag, vnd.minority_group_lookup_code, vnd.women_owned_flag, vnd.small_business_flag, vnd.hold_flag, vnd.inspection_required_flag, vnd.receipt_required_flag, vnd.allow_substitute_receipts_flag, vnd.allow_unordered_receipts_flag, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, to_number(NULL), to_number(NULL), to_number(NULL), NULL, NULL, NULL, NULL, NULL, NULL, to_number(NULL), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, vnd.last_update_date, vnd.creation_date, NULL, vnd.vendor_id, to_number(NULL), inst.instance_code, '_DF:PO:PO_VENDORS:vnd', '_DF:_DUMMY:AR:HZ_PARTIES:parties', '_DF:_DUMMY:AR:RA_CUSTOMERS_HZ:hzca' FROM edw_local_instance inst, edw_po_vendor_hierarchies_v ele, (select term_id, name from ap_terms_tl where language = userenv('LANG')) apt, po_vendors vnd WHERE ele.vendor_id = vnd.vendor_id AND vnd.terms_id = apt.term_id (+) UNION ALL /* VENDORS FROM PO_VENDORS ONLY (without parent) */ SELECT vnd.vendor_id || '-' || inst.instance_code || '-' || 'SUPPLIER', vnd.vendor_id ||'-'|| inst.instance_code ||'-'|| 'SUPPLIER', vnd.vendor_name, vnd.vendor_name, vnd.vendor_name_alt, vnd.start_date_active, vnd.end_date_active, vnd.standard_industry_class, vnd.vat_registration_num, vnd.num_1099, apt.name, vnd.segment1, vnd.vendor_type_lookup_code, vnd.one_time_flag, vnd.minority_group_lookup_code, vnd.women_owned_flag, vnd.small_business_flag, vnd.hold_flag, vnd.inspection_required_flag, vnd.receipt_required_flag, vnd.allow_substitute_receipts_flag, vnd.allow_unordered_receipts_flag, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, to_number(NULL), to_number(NULL), to_number(NULL), NULL, NULL, NULL, NULL, NULL, NULL, to_number(NULL), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, vnd.last_update_date, vnd.creation_date, NULL, vnd.vendor_id, to_number(NULL), inst.instance_code, '_DF:PO:PO_VENDORS:vnd', '_DF:_DUMMY:AR:HZ_PARTIES:parties', '_DF:_DUMMY:AR:RA_CUSTOMERS_HZ:hzca' FROM edw_local_instance inst, (select term_id, name from ap_terms_tl where language = userenv('LANG')) apt, po_vendors vnd WHERE vnd.parent_vendor_id is NULL AND vnd.terms_id = apt.term_id (+) UNION ALL /* PARTY INFORMATION ONLY*/ SELECT parties.party_id || '-' || inst.instance_code || '-' || 'PARTY', NULL, substrb(parties.party_name,1,120), substrb(parties.party_name,1,120), parties.organization_name_phonetic, to_date(NULL), /*hzca.account_activation_date,*/ to_date(NULL), /*hzca.account_termination_date,*/ parties.sic_code, parties.tax_reference, parties.jgzz_fiscal_code, NULL, /*hzca.payment_term_id,*/ parties.party_number, parties.party_type, NULL, /* vnd.one_time_flag,*/ NULL, /* vnd.minority_group_lookup_code, */ NULL, /* vnd.women_owned_flag, */ NULL, /* vnd.small_business_flag, */ NULL, /* vnd.hold_flag, */ NULL, /* vnd.inspection_required_flag, */ NULL, /* vnd.receipt_required_flag, */ NULL, /* vnd.allow_substitute_receipts_flag, */ NULL, /* vnd.allow_unordered_receipts_flag, */ NULL, /* hzca.account_number,*/ NULL, /* hzca.orig_system_reference,*/ NULL, /* hzca.status, */ NULL, /* hzca.customer_type, */ decode(parties.TOTAL_NUM_OF_ORDERS,0,'PROSPECT',1,'CUSTOMER','CUSTOMER'), NULL, /* hzca.customer_class_code, */ NULL, /* hzca.primary_salesrep_id, */ NULL, /* hzca.sales_channel_code, */ NULL, /* ot.name, */ NULL, /* pl.name, */ parties.analysis_fy, NULL, /* hzca.category_code,*****NOT IN INTERNALS***** */ substrb(parties.customer_key,1,80), parties.fiscal_yearend_month, parties.employees_total, parties.curr_fy_potential_revenue, parties.next_fy_potential_revenue, NULL, /* hzca.reference_use_flag,*****NOT IN INTERNALS***** */ parties.TAX_NAME, /* hzca.tax_code, */ NULL, /* hzca.third_party_flag,*****NOT IN INTERNALS***** */ NULL, /* access_template_entity_code ***obsoleted*** */ NULL, /* hzca.competitor_flag,*****NOT IN INTERNALS***** */ NULL, /* orig_system ***obsoleted*** */ parties.year_established, NULL, /* hzca.coterminate_day_month, */ NULL, /* hzca.fob_point, */ NULL, /* hzca.freight_term, */ parties.gsa_indicator_flag, NULL, /* hzca.ship_partial, */ NULL, /* hzca.ship_via, */ parties.do_not_mail_flag, NULL, /* hzca.tax_header_level_flag, */ NULL, /* hzca.tax_rounding_rule, */ NULL, /* user_attribute 1-5 */ NULL, NULL, NULL, NULL, parties.last_update_date, parties.creation_date, NULL, /* operation_code */ parties.party_id, to_number(NULL), inst.instance_code, '_DF:_DUMMY:PO:PO_VENDORS:vnd', '_DF:AR:HZ_PARTIES:parties', '_DF:_DUMMY:AR:RA_CUSTOMERS_HZ:hzca' FROM edw_local_instance inst, hz_parties parties

View Text - HTML Formatted

SELECT HZCA.CUST_ACCOUNT_ID || '-' || INST.INSTANCE_CODE || '-' || 'CUST_ACCT'
, NULL
, SUBSTRB(PARTIES.PARTY_NAME
, 1
, 80) || '(' || HZCA.ACCOUNT_NUMBER || ')'
, SUBSTRB(PARTIES.PARTY_NAME
, 1
, 80) || '(' || HZCA.ACCOUNT_NUMBER || ')'
, PARTIES.ORGANIZATION_NAME_PHONETIC
, HZCA.ACCOUNT_ACTIVATION_DATE
, HZCA.ACCOUNT_TERMINATION_DATE
, PARTIES.SIC_CODE
, PARTIES.TAX_REFERENCE
, PARTIES.JGZZ_FISCAL_CODE
, APT.NAME
, NULL
, /* VNDR_NUMBER (?PARTIES.PARTY_NUMBER?) */ NULL
, /* VNDR_TYPE (?PARTIES.PARTY_TYPE?) */ NULL
, /* VND.ONE_TIME_FLAG
, */ NULL
, /* VND.MINORITY_GROUP_LOOKUP_CODE
, */ NULL
, /* VND.WOMEN_OWNED_FLAG
, */ NULL
, /* VND.SMALL_BUSINESS_FLAG
, */ NULL
, /* VND.HOLD_FLAG
, */ NULL
, /* VND.INSPECTION_REQUIRED_FLAG
, */ NULL
, /* VND.RECEIPT_REQUIRED_FLAG
, */ NULL
, /* VND.ALLOW_SUBSTITUTE_RECEIPTS_FLAG
, */ NULL
, /* VND.ALLOW_UNORDERED_RECEIPTS_FLAG
, */ HZCA.ACCOUNT_NUMBER
, HZCA.ORIG_SYSTEM_REFERENCE
, HZCA.STATUS
, HZCA.CUSTOMER_TYPE
, DECODE(PARTIES.TOTAL_NUM_OF_ORDERS
, 0
, 'PROSPECT'
, 1
, 'CUSTOMER'
, 'CUSTOMER')
, HZCA.CUSTOMER_CLASS_CODE
, NULL
, /* FOR SALESREP
, NO ORG_ID
, CAN'T FIND SALESREPS */ HZCA.SALES_CHANNEL_CODE
, OT.NAME
, SUBSTRB(PL.NAME
, 1
, 40)
, PARTIES.ANALYSIS_FY
, NULL
, /* HZCA.CATEGORY_CODE
, *****NOT IN INTERNALS***** */ SUBSTRB(PARTIES.CUSTOMER_KEY
, 1
, 80)
, PARTIES.FISCAL_YEAREND_MONTH
, PARTIES.EMPLOYEES_TOTAL
, PARTIES.CURR_FY_POTENTIAL_REVENUE
, PARTIES.NEXT_FY_POTENTIAL_REVENUE
, NULL
, /* HZCA.REFERENCE_USE_FLAG
, *****NOT IN INTERNALS***** */ HZCA.TAX_CODE
, NULL
, /* HZCA.THIRD_PARTY_FLAG
, *****NOT IN INTERNALS***** */ NULL
, /* ACCESS_TEMPLATE_ENTITY_CODE ***OBSOLETED*** */ NULL
, /* HZCA.COMPETITOR_FLAG
, *****NOT IN INTERNALS***** */ NULL
, /* ORIG_SYSTEM ***OBSOLETED*** */ PARTIES.YEAR_ESTABLISHED
, HZCA.COTERMINATE_DAY_MONTH
, HZCA.FOB_POINT
, HZCA.FREIGHT_TERM
, PARTIES.GSA_INDICATOR_FLAG
, HZCA.SHIP_PARTIAL
, HZCA.SHIP_VIA
, PARTIES.DO_NOT_MAIL_FLAG
, HZCA.TAX_HEADER_LEVEL_FLAG
, HZCA.TAX_ROUNDING_RULE
, NULL
, /* USER_ATTRIBUTE 1-5 */ NULL
, NULL
, NULL
, NULL
, GREATEST(HZCA.LAST_UPDATE_DATE
, PARTIES.LAST_UPDATE_DATE)
, HZCA.CREATION_DATE
, NULL
, /* OPERATION_CODE */ HZCA.PARTY_ID
, HZCA.CUST_ACCOUNT_ID
, INST.INSTANCE_CODE
, '_DF:_DUMMY:PO:PO_VENDORS:VND'
, '_DF:AR:HZ_PARTIES:PARTIES'
, '_DF:AR:RA_CUSTOMERS_HZ:HZCA'
FROM EDW_LOCAL_INSTANCE INST
, (SELECT TRANSACTION_TYPE_ID
, NAME
FROM OE_TRANSACTION_TYPES_TL
WHERE LANGUAGE = USERENV('LANG')) OT
, (SELECT PRICE_LIST_ID
, NAME
FROM SO_PRICE_LISTS_TL
WHERE LANGUAGE = USERENV('LANG')) PL
, (SELECT TERM_ID
, NAME
FROM AP_TERMS_TL
WHERE LANGUAGE = USERENV('LANG')) APT
, HZ_CUST_ACCOUNTS HZCA
, HZ_PARTIES PARTIES
WHERE HZCA.ORDER_TYPE_ID = OT.TRANSACTION_TYPE_ID (+)
AND HZCA.PAYMENT_TERM_ID = APT.TERM_ID (+)
AND HZCA.PRICE_LIST_ID = PL.PRICE_LIST_ID (+)
AND HZCA.PARTY_ID = PARTIES.PARTY_ID UNION ALL /* VENDORS
FROM PO_VENDORS ONLY (WITH PARENTS) */ /*FOR LEVEL > 4
, PARENT_TPARTNER_FK WILL BE POPULATED IN THE PUSH PROGRAM*/ SELECT VND.VENDOR_ID || '-' || INST.INSTANCE_CODE || '-' || 'SUPPLIER'
, DECODE(ELE.HIERARCHY_LEVEL
, 1
, VND.VENDOR_ID ||'-'|| INST.INSTANCE_CODE ||'-'|| 'SUPPLIER'
, 2
, VND.VENDOR_ID ||'-'|| INST.INSTANCE_CODE ||'-'|| 'SUPPLIER'
, 3
, VND.VENDOR_ID ||'-'|| INST.INSTANCE_CODE ||'-'|| 'SUPPLIER'
, 4
, ELE.PARENT_VENDOR_ID ||'-'|| INST.INSTANCE_CODE ||'-'|| 'SUPPLIER'
, NULL)
, VND.VENDOR_NAME
, VND.VENDOR_NAME
, VND.VENDOR_NAME_ALT
, VND.START_DATE_ACTIVE
, VND.END_DATE_ACTIVE
, VND.STANDARD_INDUSTRY_CLASS
, VND.VAT_REGISTRATION_NUM
, VND.NUM_1099
, APT.NAME
, VND.SEGMENT1
, VND.VENDOR_TYPE_LOOKUP_CODE
, VND.ONE_TIME_FLAG
, VND.MINORITY_GROUP_LOOKUP_CODE
, VND.WOMEN_OWNED_FLAG
, VND.SMALL_BUSINESS_FLAG
, VND.HOLD_FLAG
, VND.INSPECTION_REQUIRED_FLAG
, VND.RECEIPT_REQUIRED_FLAG
, VND.ALLOW_SUBSTITUTE_RECEIPTS_FLAG
, VND.ALLOW_UNORDERED_RECEIPTS_FLAG
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, VND.LAST_UPDATE_DATE
, VND.CREATION_DATE
, NULL
, VND.VENDOR_ID
, TO_NUMBER(NULL)
, INST.INSTANCE_CODE
, '_DF:PO:PO_VENDORS:VND'
, '_DF:_DUMMY:AR:HZ_PARTIES:PARTIES'
, '_DF:_DUMMY:AR:RA_CUSTOMERS_HZ:HZCA'
FROM EDW_LOCAL_INSTANCE INST
, EDW_PO_VENDOR_HIERARCHIES_V ELE
, (SELECT TERM_ID
, NAME
FROM AP_TERMS_TL
WHERE LANGUAGE = USERENV('LANG')) APT
, PO_VENDORS VND
WHERE ELE.VENDOR_ID = VND.VENDOR_ID
AND VND.TERMS_ID = APT.TERM_ID (+) UNION ALL /* VENDORS
FROM PO_VENDORS ONLY (WITHOUT PARENT) */ SELECT VND.VENDOR_ID || '-' || INST.INSTANCE_CODE || '-' || 'SUPPLIER'
, VND.VENDOR_ID ||'-'|| INST.INSTANCE_CODE ||'-'|| 'SUPPLIER'
, VND.VENDOR_NAME
, VND.VENDOR_NAME
, VND.VENDOR_NAME_ALT
, VND.START_DATE_ACTIVE
, VND.END_DATE_ACTIVE
, VND.STANDARD_INDUSTRY_CLASS
, VND.VAT_REGISTRATION_NUM
, VND.NUM_1099
, APT.NAME
, VND.SEGMENT1
, VND.VENDOR_TYPE_LOOKUP_CODE
, VND.ONE_TIME_FLAG
, VND.MINORITY_GROUP_LOOKUP_CODE
, VND.WOMEN_OWNED_FLAG
, VND.SMALL_BUSINESS_FLAG
, VND.HOLD_FLAG
, VND.INSPECTION_REQUIRED_FLAG
, VND.RECEIPT_REQUIRED_FLAG
, VND.ALLOW_SUBSTITUTE_RECEIPTS_FLAG
, VND.ALLOW_UNORDERED_RECEIPTS_FLAG
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, VND.LAST_UPDATE_DATE
, VND.CREATION_DATE
, NULL
, VND.VENDOR_ID
, TO_NUMBER(NULL)
, INST.INSTANCE_CODE
, '_DF:PO:PO_VENDORS:VND'
, '_DF:_DUMMY:AR:HZ_PARTIES:PARTIES'
, '_DF:_DUMMY:AR:RA_CUSTOMERS_HZ:HZCA'
FROM EDW_LOCAL_INSTANCE INST
, (SELECT TERM_ID
, NAME
FROM AP_TERMS_TL
WHERE LANGUAGE = USERENV('LANG')) APT
, PO_VENDORS VND
WHERE VND.PARENT_VENDOR_ID IS NULL
AND VND.TERMS_ID = APT.TERM_ID (+) UNION ALL /* PARTY INFORMATION ONLY*/ SELECT PARTIES.PARTY_ID || '-' || INST.INSTANCE_CODE || '-' || 'PARTY'
, NULL
, SUBSTRB(PARTIES.PARTY_NAME
, 1
, 120)
, SUBSTRB(PARTIES.PARTY_NAME
, 1
, 120)
, PARTIES.ORGANIZATION_NAME_PHONETIC
, TO_DATE(NULL)
, /*HZCA.ACCOUNT_ACTIVATION_DATE
, */ TO_DATE(NULL)
, /*HZCA.ACCOUNT_TERMINATION_DATE
, */ PARTIES.SIC_CODE
, PARTIES.TAX_REFERENCE
, PARTIES.JGZZ_FISCAL_CODE
, NULL
, /*HZCA.PAYMENT_TERM_ID
, */ PARTIES.PARTY_NUMBER
, PARTIES.PARTY_TYPE
, NULL
, /* VND.ONE_TIME_FLAG
, */ NULL
, /* VND.MINORITY_GROUP_LOOKUP_CODE
, */ NULL
, /* VND.WOMEN_OWNED_FLAG
, */ NULL
, /* VND.SMALL_BUSINESS_FLAG
, */ NULL
, /* VND.HOLD_FLAG
, */ NULL
, /* VND.INSPECTION_REQUIRED_FLAG
, */ NULL
, /* VND.RECEIPT_REQUIRED_FLAG
, */ NULL
, /* VND.ALLOW_SUBSTITUTE_RECEIPTS_FLAG
, */ NULL
, /* VND.ALLOW_UNORDERED_RECEIPTS_FLAG
, */ NULL
, /* HZCA.ACCOUNT_NUMBER
, */ NULL
, /* HZCA.ORIG_SYSTEM_REFERENCE
, */ NULL
, /* HZCA.STATUS
, */ NULL
, /* HZCA.CUSTOMER_TYPE
, */ DECODE(PARTIES.TOTAL_NUM_OF_ORDERS
, 0
, 'PROSPECT'
, 1
, 'CUSTOMER'
, 'CUSTOMER')
, NULL
, /* HZCA.CUSTOMER_CLASS_CODE
, */ NULL
, /* HZCA.PRIMARY_SALESREP_ID
, */ NULL
, /* HZCA.SALES_CHANNEL_CODE
, */ NULL
, /* OT.NAME
, */ NULL
, /* PL.NAME
, */ PARTIES.ANALYSIS_FY
, NULL
, /* HZCA.CATEGORY_CODE
, *****NOT IN INTERNALS***** */ SUBSTRB(PARTIES.CUSTOMER_KEY
, 1
, 80)
, PARTIES.FISCAL_YEAREND_MONTH
, PARTIES.EMPLOYEES_TOTAL
, PARTIES.CURR_FY_POTENTIAL_REVENUE
, PARTIES.NEXT_FY_POTENTIAL_REVENUE
, NULL
, /* HZCA.REFERENCE_USE_FLAG
, *****NOT IN INTERNALS***** */ PARTIES.TAX_NAME
, /* HZCA.TAX_CODE
, */ NULL
, /* HZCA.THIRD_PARTY_FLAG
, *****NOT IN INTERNALS***** */ NULL
, /* ACCESS_TEMPLATE_ENTITY_CODE ***OBSOLETED*** */ NULL
, /* HZCA.COMPETITOR_FLAG
, *****NOT IN INTERNALS***** */ NULL
, /* ORIG_SYSTEM ***OBSOLETED*** */ PARTIES.YEAR_ESTABLISHED
, NULL
, /* HZCA.COTERMINATE_DAY_MONTH
, */ NULL
, /* HZCA.FOB_POINT
, */ NULL
, /* HZCA.FREIGHT_TERM
, */ PARTIES.GSA_INDICATOR_FLAG
, NULL
, /* HZCA.SHIP_PARTIAL
, */ NULL
, /* HZCA.SHIP_VIA
, */ PARTIES.DO_NOT_MAIL_FLAG
, NULL
, /* HZCA.TAX_HEADER_LEVEL_FLAG
, */ NULL
, /* HZCA.TAX_ROUNDING_RULE
, */ NULL
, /* USER_ATTRIBUTE 1-5 */ NULL
, NULL
, NULL
, NULL
, PARTIES.LAST_UPDATE_DATE
, PARTIES.CREATION_DATE
, NULL
, /* OPERATION_CODE */ PARTIES.PARTY_ID
, TO_NUMBER(NULL)
, INST.INSTANCE_CODE
, '_DF:_DUMMY:PO:PO_VENDORS:VND'
, '_DF:AR:HZ_PARTIES:PARTIES'
, '_DF:_DUMMY:AR:RA_CUSTOMERS_HZ:HZCA'
FROM EDW_LOCAL_INSTANCE INST
, HZ_PARTIES PARTIES