VIEW: APPS.OE_ORDER_LINES_HIST_V

Source

View Text - Preformatted

SELECT L.ROWID ROW_ID, L.LINE_ID, L.ORG_ID, L.HEADER_ID, L.LINE_TYPE_ID, L.LINE_NUMBER, L.PRICE_REQUEST_CODE, L.WF_ACTIVITY_CODE , L.WF_RESULT_CODE , L.REASON_CODE , L.HIST_COMMENTS , L.HIST_TYPE_CODE , L.HIST_CREATION_DATE , L.HIST_CREATED_BY , L.MFG_COMPONENT_SEQUENCE_ID, L.RE_SOURCE_FLAG, L.SHIPPABLE_FLAG , L.ORIG_SYS_SHIPMENT_REF , L.CHANGE_SEQUENCE , L.DROP_SHIP_FLAG , L.transaction_phase_code, L.source_document_version_number, L.ORDERED_ITEM, L.REQUEST_DATE, L.PROMISE_DATE, L.SCHEDULE_ARRIVAL_DATE, L.SCHEDULE_SHIP_DATE, L.ORDER_QUANTITY_UOM, L.PRICING_QUANTITY, L.PRICING_QUANTITY_UOM, L.CANCELLED_QUANTITY, L.SHIPPED_QUANTITY, L.ORDERED_QUANTITY, L.FULFILLED_QUANTITY, L.SHIPPING_QUANTITY, L.SHIPPING_QUANTITY_UOM, L.DELIVERY_LEAD_TIME, L.AUTO_SELECTED_QUANTITY, L.TAX_EXEMPT_FLAG, L.TAX_EXEMPT_NUMBER, L.TAX_EXEMPT_REASON_CODE, L.CUST_PO_NUMBER, L.SHIP_TOLERANCE_ABOVE, L.SHIP_TOLERANCE_BELOW, L.DEMAND_BUCKET_TYPE_CODE, L.RLA_SCHEDULE_TYPE_CODE, L.CUSTOMER_DOCK_CODE, L.CUSTOMER_JOB, L.CUSTOMER_PRODUCTION_LINE, L.CUST_MODEL_SERIAL_NUMBER, L.PROJECT_ID, L.TASK_ID, L.END_ITEM_UNIT_NUMBER, L.SOLD_TO_ORG_ID, L.SHIP_FROM_ORG_ID, L.SHIP_TO_ORG_ID, L.DELIVER_TO_ORG_ID, L.INTMED_SHIP_TO_ORG_ID, L.INVOICE_TO_ORG_ID, L.SHIP_TO_CONTACT_ID, L.DELIVER_TO_CONTACT_ID, L.INTMED_SHIP_TO_CONTACT_ID, L.INVOICE_TO_CONTACT_ID, L.INVENTORY_ITEM_ID, L.TAX_DATE, L.TAX_CODE, L.TAX_RATE, L.DEMAND_CLASS_CODE, L.SCHEDULE_STATUS_CODE, L.SOURCE_TYPE_CODE, L.PRICE_LIST_ID, L.PRICING_DATE, L.SHIPMENT_NUMBER, L.AGREEMENT_ID, L.SHIPMENT_PRIORITY_CODE, L.SHIPPING_METHOD_CODE, L.FREIGHT_TERMS_CODE, L.FREIGHT_CARRIER_CODE, L.FOB_POINT_CODE, L.TAX_POINT_CODE, L.PAYMENT_TERM_ID, L.INVOICING_RULE_ID, L.ACCOUNTING_RULE_ID, L.ACCOUNTING_RULE_DURATION, L.SOURCE_DOCUMENT_TYPE_ID, L.ORIG_SYS_DOCUMENT_REF, L.SOURCE_DOCUMENT_ID, L.ORIG_SYS_LINE_REF, L.SOURCE_DOCUMENT_LINE_ID, L.REFERENCE_LINE_ID, L.REFERENCE_TYPE, L.REFERENCE_HEADER_ID, L.ITEM_REVISION, L.LINE_CATEGORY_CODE, L.CUSTOMER_TRX_LINE_ID, L.RETURN_CONTEXT, L.RETURN_ATTRIBUTE1, L.RETURN_ATTRIBUTE2, L.RETURN_ATTRIBUTE3, L.RETURN_ATTRIBUTE4, L.RETURN_ATTRIBUTE5, L.RETURN_ATTRIBUTE6, L.RETURN_ATTRIBUTE7, L.RETURN_ATTRIBUTE8, L.RETURN_ATTRIBUTE9, L.RETURN_ATTRIBUTE10, L.RETURN_ATTRIBUTE11, L.RETURN_ATTRIBUTE12, L.RETURN_ATTRIBUTE13, L.RETURN_ATTRIBUTE14, L.RETURN_ATTRIBUTE15, NULL REF_ORDER_NUMBER, NULL REF_LINE_NUMBER, NULL REF_SHIPMENT_NUMBER, NULL REF_OPTION_NUMBER, NULL REF_INVOICE_NUMBER, L.reference_customer_trx_line_id REFERENCE_CUSTOMER_TRX_LINE_ID, NULL REF_INVOICE_LINE_NUMBER, L.UNIT_SELLING_PRICE, L.UNIT_LIST_PRICE, L.TAX_VALUE, L.CONTEXT, L.ATTRIBUTE1, L.ATTRIBUTE2, L.ATTRIBUTE3, L.ATTRIBUTE4, L.ATTRIBUTE5, L.ATTRIBUTE6, L.ATTRIBUTE7, L.ATTRIBUTE8, L.ATTRIBUTE9, L.ATTRIBUTE10, L.ATTRIBUTE11, L.ATTRIBUTE12, L.ATTRIBUTE13, L.ATTRIBUTE14, L.ATTRIBUTE15, L.ATTRIBUTE16, L.ATTRIBUTE17, L.ATTRIBUTE18, L.ATTRIBUTE19, L.ATTRIBUTE20, L.GLOBAL_ATTRIBUTE_CATEGORY, L.GLOBAL_ATTRIBUTE1, L.GLOBAL_ATTRIBUTE2, L.GLOBAL_ATTRIBUTE3, L.GLOBAL_ATTRIBUTE4, L.GLOBAL_ATTRIBUTE5, L.GLOBAL_ATTRIBUTE6, L.GLOBAL_ATTRIBUTE7, L.GLOBAL_ATTRIBUTE8, L.GLOBAL_ATTRIBUTE9, L.GLOBAL_ATTRIBUTE10, L.GLOBAL_ATTRIBUTE11, L.GLOBAL_ATTRIBUTE12, L.GLOBAL_ATTRIBUTE13, L.GLOBAL_ATTRIBUTE14, L.GLOBAL_ATTRIBUTE15, L.GLOBAL_ATTRIBUTE16, L.GLOBAL_ATTRIBUTE17, L.GLOBAL_ATTRIBUTE18, L.GLOBAL_ATTRIBUTE19, L.GLOBAL_ATTRIBUTE20, L.PRICING_CONTEXT, L.PRICING_ATTRIBUTE1, L.PRICING_ATTRIBUTE2, L.PRICING_ATTRIBUTE3, L.PRICING_ATTRIBUTE4, L.PRICING_ATTRIBUTE5, L.PRICING_ATTRIBUTE6, L.PRICING_ATTRIBUTE7, L.PRICING_ATTRIBUTE8, L.PRICING_ATTRIBUTE9, L.PRICING_ATTRIBUTE10, L.INDUSTRY_CONTEXT, L.INDUSTRY_ATTRIBUTE1, L.INDUSTRY_ATTRIBUTE2, L.INDUSTRY_ATTRIBUTE3, L.INDUSTRY_ATTRIBUTE4, L.INDUSTRY_ATTRIBUTE5, L.INDUSTRY_ATTRIBUTE6, L.INDUSTRY_ATTRIBUTE7, L.INDUSTRY_ATTRIBUTE8, L.INDUSTRY_ATTRIBUTE9 , L.INDUSTRY_ATTRIBUTE10, L.INDUSTRY_ATTRIBUTE11, L.INDUSTRY_ATTRIBUTE13, L.INDUSTRY_ATTRIBUTE12, L.INDUSTRY_ATTRIBUTE14, L.INDUSTRY_ATTRIBUTE15, L.INDUSTRY_ATTRIBUTE16, L.INDUSTRY_ATTRIBUTE17, L.INDUSTRY_ATTRIBUTE18, L.INDUSTRY_ATTRIBUTE19, L.INDUSTRY_ATTRIBUTE20, L.INDUSTRY_ATTRIBUTE21, L.INDUSTRY_ATTRIBUTE22, L.INDUSTRY_ATTRIBUTE23, L.INDUSTRY_ATTRIBUTE24, L.INDUSTRY_ATTRIBUTE25, L.INDUSTRY_ATTRIBUTE26, L.INDUSTRY_ATTRIBUTE27, L.INDUSTRY_ATTRIBUTE28, L.INDUSTRY_ATTRIBUTE29, L.INDUSTRY_ATTRIBUTE30, L.TP_CONTEXT, L.TP_ATTRIBUTE1, L.TP_ATTRIBUTE2, L.TP_ATTRIBUTE3, L.TP_ATTRIBUTE4, L.TP_ATTRIBUTE5, L.TP_ATTRIBUTE6, L.TP_ATTRIBUTE7, L.TP_ATTRIBUTE8, L.TP_ATTRIBUTE9, L.TP_ATTRIBUTE10, L.TP_ATTRIBUTE11, L.TP_ATTRIBUTE12, L.TP_ATTRIBUTE13, L.TP_ATTRIBUTE14, L.TP_ATTRIBUTE15, L.CREATION_DATE, L.CREATED_BY, L.LAST_UPDATE_DATE, L.LAST_UPDATED_BY, L.LAST_UPDATE_LOGIN, L.PROGRAM_APPLICATION_ID, L.PROGRAM_ID, L.PROGRAM_UPDATE_DATE, L.REQUEST_ID, L.SHIP_MODEL_COMPLETE_FLAG, L.ATO_LINE_ID, L.CONFIGURATION_ID, L.TOP_MODEL_LINE_ID, L.LINK_TO_LINE_ID, L.EXPLOSION_DATE, L.COMPONENT_SEQUENCE_ID, L.COMPONENT_CODE, L.CONFIG_DISPLAY_SEQUENCE, L.SORT_ORDER, L.ITEM_TYPE_CODE, L.OPTION_NUMBER, L.COMPONENT_NUMBER, L.MODEL_GROUP_NUMBER, L.OPTION_FLAG, L.DEP_PLAN_REQUIRED_FLAG, L.VISIBLE_DEMAND_FLAG, L.ACTUAL_ARRIVAL_DATE, L.ACTUAL_SHIPMENT_DATE, L.EARLIEST_ACCEPTABLE_DATE, L.LATEST_ACCEPTABLE_DATE, lt.name LINE_TYPE, NULL AGREEMENT, PL.NAME PRICE_LIST, -PL1.ROUNDING_FACTOR ROUNDING_FACTOR, ACCRULE.NAME ACCOUNTING_RULE, INVRULE.NAME INVOICING_RULE, TERM.NAME TERMS, NULL COMMITMENT, PARTY.PARTY_NAME SOLD_TO, CUST_ACCT.ACCOUNT_NUMBER CUSTOMER_NUMBER, ship_from_org.organization_code SHIP_FROM, L.SUBINVENTORY SUBINVENTORY, NULL SHIP_FROM_LOCATION, ship_su.location SHIP_TO, ship_su.location SHIP_TO_LOCATION, ship_loc.address1 SHIP_TO_ADDRESS1, ship_loc.address2 SHIP_TO_ADDRESS2, ship_loc.address3 SHIP_TO_ADDRESS3, ship_loc.address4 SHIP_TO_ADDRESS4, DECODE(ship_loc.city, NULL, NULL, ship_loc.city || ', ') || DECODE(ship_loc.state, NULL, NULL, ship_loc.state || ', ') || DECODE(ship_loc.postal_code, NULL, NULL, ship_loc.postal_code || ', ') || DECODE(ship_loc.country, NULL, NULL, ship_loc.country) SHIP_TO_ADDRESS5, NULL DELIVER_TO, NULL DELIVER_TO_LOCATION, NULL DELIVER_TO_ADDRESS1, NULL DELIVER_TO_ADDRESS2, NULL DELIVER_TO_ADDRESS3, NULL DELIVER_TO_ADDRESS4, NULL INTMED_SHIP_TO, NULL INTMED_SHIP_TO_LOCATION, NULL INTMED_SHIP_TO_ADDRESS1, NULL INTMED_SHIP_TO_ADDRESS2, NULL INTMED_SHIP_TO_ADDRESS3, NULL INTMED_SHIP_TO_ADDRESS4, bill_su.location INVOICE_TO, bill_su.location INVOICE_TO_LOCATION, bill_loc.address1 INVOICE_TO_ADDRESS1, bill_loc.address2 INVOICE_TO_ADDRESS2, bill_loc.address3 INVOICE_TO_ADDRESS3, bill_loc.address4 INVOICE_TO_ADDRESS4, DECODE(bill_loc.city, NULL, NULL, bill_loc.city || ', ') || DECODE(bill_loc.state, NULL, NULL, bill_loc.state || ', ') || DECODE(bill_loc.postal_code, NULL, NULL, bill_loc.postal_code || ', ') || DECODE(bill_loc.country, NULL, NULL, bill_loc.country) INVOICE_TO_ADDRESS5, ship_party.PERSON_LAST_NAME || DECODE(ship_party.PERSON_FIRST_NAME, NULL, NULL, ', ' || ship_party.PERSON_FIRST_NAME) || DECODE(ship_arl.meaning,NULL, NULL, ' '||ship_arl.meaning) SHIP_TO_CONTACT, NULL INTMED_SHIP_TO_CONTACT, invoice_party.PERSON_LAST_NAME || DECODE(invoice_party.PERSON_FIRST_NAME, NULL, NULL, ', ' || invoice_party.PERSON_FIRST_NAME) || DECODE(invoice_arl.meaning,NULL, NULL, ' '||invoice_arl.meaning) INVOICE_TO_CONTACT, NULL DELIVER_TO_CONTACT, NULL SOURCE_DOCUMENT_TYPE, H.order_number ORDER_NUMBER, H.version_number VERSION_NUMBER, H.order_type_id, NULL ORDER_TYPE, H.ordered_date ORDERED_DATE, H.order_source_id, L.salesrep_id, L.return_reason_code, L.split_from_line_id, L.Line_set_id, L.Split_by, L.cust_production_seq_num, L.authorized_to_ship_flag, L.veh_cus_item_cum_key_id, L.invoice_interface_status_code, L.over_ship_reason_code, L.over_ship_resolved_flag, L.ship_set_id, L.arrival_set_id, NULL ARRIVAL_SET, NULL SHIP_SET, NULL over_ship_reason, L.ordered_item_id, L.item_identifier_type, L.commitment_id, L.shipping_interfaced_flag, L.credit_invoice_line_id, L.FIRST_ACK_CODE, L.FIRST_ACK_DATE, L.LAST_ACK_CODE, L.LAST_ACK_DATE, NULL credit_invoice_number, L.planning_priority, L.config_header_id, L.config_rev_nbr, L.booked_flag, L.cancelled_flag, L.open_flag, l.sold_from_org_id, l.fulfilled_flag, NULL project_number, NULL task_number, l.shipping_instructions, l.packing_instructions, l.invoiced_quantity , l.service_txn_reason_code , l.service_txn_comments , l.service_duration , l.service_period , l.service_start_date , l.service_end_date , l.service_coterminate_flag , l.unit_selling_percent , l.unit_list_percent , l.unit_percent_base_price , l.service_number , l.service_reference_type_code , l.service_reference_line_id , l.service_reference_system_id , l.flow_status_code , l.Model_Remnant_Flag , l.fulfillment_method_code , l.Calculate_price_flag , l.Revenue_Amount , l.fulfillment_date , l.preferred_grade , l.ordered_quantity2 , l.ordered_quantity_uom2 , l.shipped_quantity2 , l.cancelled_quantity2 , l.shipping_quantity2 , l.shipping_quantity_uom2 , l.fulfilled_quantity2 , l.unit_selling_price_per_pqty , l.unit_list_price_per_pqty , l.customer_line_number , l.customer_shipment_number , l.customer_item_net_price , l.customer_payment_term_id , l.Original_Inventory_Item_Id , l.Original_item_identifier_Type , l.Original_ordered_item_id , l.Original_ordered_item , l.Item_substitution_type_code , l.Late_demand_penalty_factor , l.Override_atp_date_code , l.user_item_description , l.item_relationship_type , l.blanket_number , l.blanket_line_number , l.blanket_version_number ,l.retrobill_request_id , l.minisite_id , l.end_customer_id , l.end_customer_contact_id , l.end_customer_site_use_id , null end_customer_name , null end_customer_number , null end_customer_contact , null end_customer_location , null end_customer_address1 , null end_customer_address2 , null end_customer_address3 , null end_customer_address4 , null end_customer_address5 , l.ib_owner , l.ib_current_location , l.ib_installed_at_location , l.phase_change_flag , l.version_flag , h.version_flag hdr_version_flag , l.audit_flag , l.reason_id , l.firm_demand_flag , l.earliest_ship_date , l.SERVICE_CREDIT_ELIGIBLE_CODE ,l.ORDER_FIRMED_DATE ,l.ACTUAL_FULFILLMENT_DATE ,l.CHARGE_PERIODICITY_CODE , l.CONTINGENCY_ID , l.REVREC_EVENT_CODE , l.REVREC_EXPIRATION_DAYS , l.ACCEPTED_QUANTITY , l.ACCEPTED_BY , l.REVREC_COMMENTS , l.REVREC_REFERENCE_DOCUMENT , l.REVREC_SIGNATURE , l.REVREC_SIGNATURE_DATE , l.REVREC_IMPLICIT_FLAG , L.SERVICE_BILL_PROFILE_ID , L.SERVICE_COV_TEMPLATE_ID , L.SERVICE_SUBS_TEMPLATE_ID , L.SERVICE_BILL_OPTION_CODE , L.SERVICE_FIRST_PERIOD_AMOUNT , L.SERVICE_FIRST_PERIOD_ENDDATE , L.SUBSCRIPTION_ENABLE_FLAG FROM mtl_parameters ship_from_org, hz_cust_site_uses_all ship_su, hz_party_sites ship_ps, hz_locations ship_loc, hz_cust_acct_sites_all ship_cas, hz_cust_site_uses_all bill_su, hz_party_sites bill_ps, hz_locations bill_loc, hz_cust_acct_sites_all bill_cas, hz_parties party, hz_cust_accounts cust_acct, hz_cust_account_roles ship_roles, hz_parties ship_party, hz_relationships ship_rel, hz_cust_accounts ship_acct, ar_lookups ship_arl, hz_cust_account_roles invoice_roles, hz_parties invoice_party, hz_relationships invoice_rel, hz_cust_accounts invoice_acct, ar_lookups invoice_arl, oe_order_header_history H, oe_order_lines_history L, qp_list_headers_tl PL, qp_list_headers_b PL1, RA_RULES ACCRULE, RA_RULES INVRULE, RA_TERMS_TL TERM, OE_TRANSACTION_TYPES_TL lt WHERE L.line_type_id = LT.transaction_type_id AND LT.language = userenv('LANG') AND L.PRICE_LIST_ID = PL.list_header_id (+) AND PL.language(+) = userenv('LANG') AND PL.list_header_id = PL1.list_header_id (+) AND L.ACCOUNTING_RULE_ID = ACCRULE.RULE_ID (+) AND L.INVOICING_RULE_ID = INVRULE.RULE_ID (+) AND L.PAYMENT_TERM_ID = TERM.TERM_ID (+) AND TERM.Language(+) = userenv('LANG') AND L.sold_to_org_id = cust_acct.cust_account_id(+) AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID(+) AND L.ship_from_org_id = ship_from_org.organization_id (+) AND l.ship_to_org_id = ship_su.site_use_id(+) AND ship_su.cust_acct_site_id= ship_cas.cust_acct_site_id(+) AND ship_cas.party_site_id = ship_ps.party_site_id(+) AND ship_loc.location_id(+) = ship_ps.location_id AND l.invoice_to_org_id = bill_su.site_use_id(+) AND bill_su.cust_acct_site_id= bill_cas.cust_acct_site_id(+) AND bill_cas.party_site_id = bill_ps.party_site_id(+) AND bill_loc.location_id(+) = bill_ps.location_id AND l.ship_to_contact_id = ship_roles.cust_account_role_id(+) AND ship_roles.party_id = ship_rel.party_id(+) AND ship_roles.role_type(+) = 'CONTACT' AND ship_rel.subject_id = ship_party.party_id(+) AND ship_arl.lookup_type(+) = 'CONTACT_TITLE' AND ship_arl.lookup_code(+) = ship_party.person_pre_name_adjunct AND ship_roles.cust_account_id = ship_acct.cust_account_id(+) AND nvl(ship_rel.object_id,-1) = nvl(ship_acct.party_id,-1) AND l.invoice_to_contact_id = invoice_roles.cust_account_role_id(+) AND invoice_roles.party_id = invoice_rel.party_id(+) AND invoice_roles.role_type(+) = 'CONTACT' AND invoice_rel.subject_id = invoice_party.party_id(+) AND invoice_roles.cust_account_id = invoice_acct.cust_account_id(+) AND nvl(invoice_rel.object_id,-1) = nvl(invoice_acct.party_id,-1) AND invoice_arl.lookup_type(+) = 'CONTACT_TITLE' AND invoice_arl.lookup_code(+) = invoice_party.person_pre_name_adjunct AND L.header_id = H.header_id and l.version_number=h.version_number and l.transaction_phase_code=h.transaction_phase_code and ship_rel.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES' AND invoice_rel.OBJECT_TABLE_NAME(+) = 'HZ_PARTIES' and invoice_rel.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES' AND ship_rel.OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'

View Text - HTML Formatted

SELECT L.ROWID ROW_ID
, L.LINE_ID
, L.ORG_ID
, L.HEADER_ID
, L.LINE_TYPE_ID
, L.LINE_NUMBER
, L.PRICE_REQUEST_CODE
, L.WF_ACTIVITY_CODE
, L.WF_RESULT_CODE
, L.REASON_CODE
, L.HIST_COMMENTS
, L.HIST_TYPE_CODE
, L.HIST_CREATION_DATE
, L.HIST_CREATED_BY
, L.MFG_COMPONENT_SEQUENCE_ID
, L.RE_SOURCE_FLAG
, L.SHIPPABLE_FLAG
, L.ORIG_SYS_SHIPMENT_REF
, L.CHANGE_SEQUENCE
, L.DROP_SHIP_FLAG
, L.TRANSACTION_PHASE_CODE
, L.SOURCE_DOCUMENT_VERSION_NUMBER
, L.ORDERED_ITEM
, L.REQUEST_DATE
, L.PROMISE_DATE
, L.SCHEDULE_ARRIVAL_DATE
, L.SCHEDULE_SHIP_DATE
, L.ORDER_QUANTITY_UOM
, L.PRICING_QUANTITY
, L.PRICING_QUANTITY_UOM
, L.CANCELLED_QUANTITY
, L.SHIPPED_QUANTITY
, L.ORDERED_QUANTITY
, L.FULFILLED_QUANTITY
, L.SHIPPING_QUANTITY
, L.SHIPPING_QUANTITY_UOM
, L.DELIVERY_LEAD_TIME
, L.AUTO_SELECTED_QUANTITY
, L.TAX_EXEMPT_FLAG
, L.TAX_EXEMPT_NUMBER
, L.TAX_EXEMPT_REASON_CODE
, L.CUST_PO_NUMBER
, L.SHIP_TOLERANCE_ABOVE
, L.SHIP_TOLERANCE_BELOW
, L.DEMAND_BUCKET_TYPE_CODE
, L.RLA_SCHEDULE_TYPE_CODE
, L.CUSTOMER_DOCK_CODE
, L.CUSTOMER_JOB
, L.CUSTOMER_PRODUCTION_LINE
, L.CUST_MODEL_SERIAL_NUMBER
, L.PROJECT_ID
, L.TASK_ID
, L.END_ITEM_UNIT_NUMBER
, L.SOLD_TO_ORG_ID
, L.SHIP_FROM_ORG_ID
, L.SHIP_TO_ORG_ID
, L.DELIVER_TO_ORG_ID
, L.INTMED_SHIP_TO_ORG_ID
, L.INVOICE_TO_ORG_ID
, L.SHIP_TO_CONTACT_ID
, L.DELIVER_TO_CONTACT_ID
, L.INTMED_SHIP_TO_CONTACT_ID
, L.INVOICE_TO_CONTACT_ID
, L.INVENTORY_ITEM_ID
, L.TAX_DATE
, L.TAX_CODE
, L.TAX_RATE
, L.DEMAND_CLASS_CODE
, L.SCHEDULE_STATUS_CODE
, L.SOURCE_TYPE_CODE
, L.PRICE_LIST_ID
, L.PRICING_DATE
, L.SHIPMENT_NUMBER
, L.AGREEMENT_ID
, L.SHIPMENT_PRIORITY_CODE
, L.SHIPPING_METHOD_CODE
, L.FREIGHT_TERMS_CODE
, L.FREIGHT_CARRIER_CODE
, L.FOB_POINT_CODE
, L.TAX_POINT_CODE
, L.PAYMENT_TERM_ID
, L.INVOICING_RULE_ID
, L.ACCOUNTING_RULE_ID
, L.ACCOUNTING_RULE_DURATION
, L.SOURCE_DOCUMENT_TYPE_ID
, L.ORIG_SYS_DOCUMENT_REF
, L.SOURCE_DOCUMENT_ID
, L.ORIG_SYS_LINE_REF
, L.SOURCE_DOCUMENT_LINE_ID
, L.REFERENCE_LINE_ID
, L.REFERENCE_TYPE
, L.REFERENCE_HEADER_ID
, L.ITEM_REVISION
, L.LINE_CATEGORY_CODE
, L.CUSTOMER_TRX_LINE_ID
, L.RETURN_CONTEXT
, L.RETURN_ATTRIBUTE1
, L.RETURN_ATTRIBUTE2
, L.RETURN_ATTRIBUTE3
, L.RETURN_ATTRIBUTE4
, L.RETURN_ATTRIBUTE5
, L.RETURN_ATTRIBUTE6
, L.RETURN_ATTRIBUTE7
, L.RETURN_ATTRIBUTE8
, L.RETURN_ATTRIBUTE9
, L.RETURN_ATTRIBUTE10
, L.RETURN_ATTRIBUTE11
, L.RETURN_ATTRIBUTE12
, L.RETURN_ATTRIBUTE13
, L.RETURN_ATTRIBUTE14
, L.RETURN_ATTRIBUTE15
, NULL REF_ORDER_NUMBER
, NULL REF_LINE_NUMBER
, NULL REF_SHIPMENT_NUMBER
, NULL REF_OPTION_NUMBER
, NULL REF_INVOICE_NUMBER
, L.REFERENCE_CUSTOMER_TRX_LINE_ID REFERENCE_CUSTOMER_TRX_LINE_ID
, NULL REF_INVOICE_LINE_NUMBER
, L.UNIT_SELLING_PRICE
, L.UNIT_LIST_PRICE
, L.TAX_VALUE
, L.CONTEXT
, L.ATTRIBUTE1
, L.ATTRIBUTE2
, L.ATTRIBUTE3
, L.ATTRIBUTE4
, L.ATTRIBUTE5
, L.ATTRIBUTE6
, L.ATTRIBUTE7
, L.ATTRIBUTE8
, L.ATTRIBUTE9
, L.ATTRIBUTE10
, L.ATTRIBUTE11
, L.ATTRIBUTE12
, L.ATTRIBUTE13
, L.ATTRIBUTE14
, L.ATTRIBUTE15
, L.ATTRIBUTE16
, L.ATTRIBUTE17
, L.ATTRIBUTE18
, L.ATTRIBUTE19
, L.ATTRIBUTE20
, L.GLOBAL_ATTRIBUTE_CATEGORY
, L.GLOBAL_ATTRIBUTE1
, L.GLOBAL_ATTRIBUTE2
, L.GLOBAL_ATTRIBUTE3
, L.GLOBAL_ATTRIBUTE4
, L.GLOBAL_ATTRIBUTE5
, L.GLOBAL_ATTRIBUTE6
, L.GLOBAL_ATTRIBUTE7
, L.GLOBAL_ATTRIBUTE8
, L.GLOBAL_ATTRIBUTE9
, L.GLOBAL_ATTRIBUTE10
, L.GLOBAL_ATTRIBUTE11
, L.GLOBAL_ATTRIBUTE12
, L.GLOBAL_ATTRIBUTE13
, L.GLOBAL_ATTRIBUTE14
, L.GLOBAL_ATTRIBUTE15
, L.GLOBAL_ATTRIBUTE16
, L.GLOBAL_ATTRIBUTE17
, L.GLOBAL_ATTRIBUTE18
, L.GLOBAL_ATTRIBUTE19
, L.GLOBAL_ATTRIBUTE20
, L.PRICING_CONTEXT
, L.PRICING_ATTRIBUTE1
, L.PRICING_ATTRIBUTE2
, L.PRICING_ATTRIBUTE3
, L.PRICING_ATTRIBUTE4
, L.PRICING_ATTRIBUTE5
, L.PRICING_ATTRIBUTE6
, L.PRICING_ATTRIBUTE7
, L.PRICING_ATTRIBUTE8
, L.PRICING_ATTRIBUTE9
, L.PRICING_ATTRIBUTE10
, L.INDUSTRY_CONTEXT
, L.INDUSTRY_ATTRIBUTE1
, L.INDUSTRY_ATTRIBUTE2
, L.INDUSTRY_ATTRIBUTE3
, L.INDUSTRY_ATTRIBUTE4
, L.INDUSTRY_ATTRIBUTE5
, L.INDUSTRY_ATTRIBUTE6
, L.INDUSTRY_ATTRIBUTE7
, L.INDUSTRY_ATTRIBUTE8
, L.INDUSTRY_ATTRIBUTE9
, L.INDUSTRY_ATTRIBUTE10
, L.INDUSTRY_ATTRIBUTE11
, L.INDUSTRY_ATTRIBUTE13
, L.INDUSTRY_ATTRIBUTE12
, L.INDUSTRY_ATTRIBUTE14
, L.INDUSTRY_ATTRIBUTE15
, L.INDUSTRY_ATTRIBUTE16
, L.INDUSTRY_ATTRIBUTE17
, L.INDUSTRY_ATTRIBUTE18
, L.INDUSTRY_ATTRIBUTE19
, L.INDUSTRY_ATTRIBUTE20
, L.INDUSTRY_ATTRIBUTE21
, L.INDUSTRY_ATTRIBUTE22
, L.INDUSTRY_ATTRIBUTE23
, L.INDUSTRY_ATTRIBUTE24
, L.INDUSTRY_ATTRIBUTE25
, L.INDUSTRY_ATTRIBUTE26
, L.INDUSTRY_ATTRIBUTE27
, L.INDUSTRY_ATTRIBUTE28
, L.INDUSTRY_ATTRIBUTE29
, L.INDUSTRY_ATTRIBUTE30
, L.TP_CONTEXT
, L.TP_ATTRIBUTE1
, L.TP_ATTRIBUTE2
, L.TP_ATTRIBUTE3
, L.TP_ATTRIBUTE4
, L.TP_ATTRIBUTE5
, L.TP_ATTRIBUTE6
, L.TP_ATTRIBUTE7
, L.TP_ATTRIBUTE8
, L.TP_ATTRIBUTE9
, L.TP_ATTRIBUTE10
, L.TP_ATTRIBUTE11
, L.TP_ATTRIBUTE12
, L.TP_ATTRIBUTE13
, L.TP_ATTRIBUTE14
, L.TP_ATTRIBUTE15
, L.CREATION_DATE
, L.CREATED_BY
, L.LAST_UPDATE_DATE
, L.LAST_UPDATED_BY
, L.LAST_UPDATE_LOGIN
, L.PROGRAM_APPLICATION_ID
, L.PROGRAM_ID
, L.PROGRAM_UPDATE_DATE
, L.REQUEST_ID
, L.SHIP_MODEL_COMPLETE_FLAG
, L.ATO_LINE_ID
, L.CONFIGURATION_ID
, L.TOP_MODEL_LINE_ID
, L.LINK_TO_LINE_ID
, L.EXPLOSION_DATE
, L.COMPONENT_SEQUENCE_ID
, L.COMPONENT_CODE
, L.CONFIG_DISPLAY_SEQUENCE
, L.SORT_ORDER
, L.ITEM_TYPE_CODE
, L.OPTION_NUMBER
, L.COMPONENT_NUMBER
, L.MODEL_GROUP_NUMBER
, L.OPTION_FLAG
, L.DEP_PLAN_REQUIRED_FLAG
, L.VISIBLE_DEMAND_FLAG
, L.ACTUAL_ARRIVAL_DATE
, L.ACTUAL_SHIPMENT_DATE
, L.EARLIEST_ACCEPTABLE_DATE
, L.LATEST_ACCEPTABLE_DATE
, LT.NAME LINE_TYPE
, NULL AGREEMENT
, PL.NAME PRICE_LIST
, -PL1.ROUNDING_FACTOR ROUNDING_FACTOR
, ACCRULE.NAME ACCOUNTING_RULE
, INVRULE.NAME INVOICING_RULE
, TERM.NAME TERMS
, NULL COMMITMENT
, PARTY.PARTY_NAME SOLD_TO
, CUST_ACCT.ACCOUNT_NUMBER CUSTOMER_NUMBER
, SHIP_FROM_ORG.ORGANIZATION_CODE SHIP_FROM
, L.SUBINVENTORY SUBINVENTORY
, NULL SHIP_FROM_LOCATION
, SHIP_SU.LOCATION SHIP_TO
, SHIP_SU.LOCATION SHIP_TO_LOCATION
, SHIP_LOC.ADDRESS1 SHIP_TO_ADDRESS1
, SHIP_LOC.ADDRESS2 SHIP_TO_ADDRESS2
, SHIP_LOC.ADDRESS3 SHIP_TO_ADDRESS3
, SHIP_LOC.ADDRESS4 SHIP_TO_ADDRESS4
, DECODE(SHIP_LOC.CITY
, NULL
, NULL
, SHIP_LOC.CITY || '
, ') || DECODE(SHIP_LOC.STATE
, NULL
, NULL
, SHIP_LOC.STATE || '
, ') || DECODE(SHIP_LOC.POSTAL_CODE
, NULL
, NULL
, SHIP_LOC.POSTAL_CODE || '
, ') || DECODE(SHIP_LOC.COUNTRY
, NULL
, NULL
, SHIP_LOC.COUNTRY) SHIP_TO_ADDRESS5
, NULL DELIVER_TO
, NULL DELIVER_TO_LOCATION
, NULL DELIVER_TO_ADDRESS1
, NULL DELIVER_TO_ADDRESS2
, NULL DELIVER_TO_ADDRESS3
, NULL DELIVER_TO_ADDRESS4
, NULL INTMED_SHIP_TO
, NULL INTMED_SHIP_TO_LOCATION
, NULL INTMED_SHIP_TO_ADDRESS1
, NULL INTMED_SHIP_TO_ADDRESS2
, NULL INTMED_SHIP_TO_ADDRESS3
, NULL INTMED_SHIP_TO_ADDRESS4
, BILL_SU.LOCATION INVOICE_TO
, BILL_SU.LOCATION INVOICE_TO_LOCATION
, BILL_LOC.ADDRESS1 INVOICE_TO_ADDRESS1
, BILL_LOC.ADDRESS2 INVOICE_TO_ADDRESS2
, BILL_LOC.ADDRESS3 INVOICE_TO_ADDRESS3
, BILL_LOC.ADDRESS4 INVOICE_TO_ADDRESS4
, DECODE(BILL_LOC.CITY
, NULL
, NULL
, BILL_LOC.CITY || '
, ') || DECODE(BILL_LOC.STATE
, NULL
, NULL
, BILL_LOC.STATE || '
, ') || DECODE(BILL_LOC.POSTAL_CODE
, NULL
, NULL
, BILL_LOC.POSTAL_CODE || '
, ') || DECODE(BILL_LOC.COUNTRY
, NULL
, NULL
, BILL_LOC.COUNTRY) INVOICE_TO_ADDRESS5
, SHIP_PARTY.PERSON_LAST_NAME || DECODE(SHIP_PARTY.PERSON_FIRST_NAME
, NULL
, NULL
, '
, ' || SHIP_PARTY.PERSON_FIRST_NAME) || DECODE(SHIP_ARL.MEANING
, NULL
, NULL
, ' '||SHIP_ARL.MEANING) SHIP_TO_CONTACT
, NULL INTMED_SHIP_TO_CONTACT
, INVOICE_PARTY.PERSON_LAST_NAME || DECODE(INVOICE_PARTY.PERSON_FIRST_NAME
, NULL
, NULL
, '
, ' || INVOICE_PARTY.PERSON_FIRST_NAME) || DECODE(INVOICE_ARL.MEANING
, NULL
, NULL
, ' '||INVOICE_ARL.MEANING) INVOICE_TO_CONTACT
, NULL DELIVER_TO_CONTACT
, NULL SOURCE_DOCUMENT_TYPE
, H.ORDER_NUMBER ORDER_NUMBER
, H.VERSION_NUMBER VERSION_NUMBER
, H.ORDER_TYPE_ID
, NULL ORDER_TYPE
, H.ORDERED_DATE ORDERED_DATE
, H.ORDER_SOURCE_ID
, L.SALESREP_ID
, L.RETURN_REASON_CODE
, L.SPLIT_FROM_LINE_ID
, L.LINE_SET_ID
, L.SPLIT_BY
, L.CUST_PRODUCTION_SEQ_NUM
, L.AUTHORIZED_TO_SHIP_FLAG
, L.VEH_CUS_ITEM_CUM_KEY_ID
, L.INVOICE_INTERFACE_STATUS_CODE
, L.OVER_SHIP_REASON_CODE
, L.OVER_SHIP_RESOLVED_FLAG
, L.SHIP_SET_ID
, L.ARRIVAL_SET_ID
, NULL ARRIVAL_SET
, NULL SHIP_SET
, NULL OVER_SHIP_REASON
, L.ORDERED_ITEM_ID
, L.ITEM_IDENTIFIER_TYPE
, L.COMMITMENT_ID
, L.SHIPPING_INTERFACED_FLAG
, L.CREDIT_INVOICE_LINE_ID
, L.FIRST_ACK_CODE
, L.FIRST_ACK_DATE
, L.LAST_ACK_CODE
, L.LAST_ACK_DATE
, NULL CREDIT_INVOICE_NUMBER
, L.PLANNING_PRIORITY
, L.CONFIG_HEADER_ID
, L.CONFIG_REV_NBR
, L.BOOKED_FLAG
, L.CANCELLED_FLAG
, L.OPEN_FLAG
, L.SOLD_FROM_ORG_ID
, L.FULFILLED_FLAG
, NULL PROJECT_NUMBER
, NULL TASK_NUMBER
, L.SHIPPING_INSTRUCTIONS
, L.PACKING_INSTRUCTIONS
, L.INVOICED_QUANTITY
, L.SERVICE_TXN_REASON_CODE
, L.SERVICE_TXN_COMMENTS
, L.SERVICE_DURATION
, L.SERVICE_PERIOD
, L.SERVICE_START_DATE
, L.SERVICE_END_DATE
, L.SERVICE_COTERMINATE_FLAG
, L.UNIT_SELLING_PERCENT
, L.UNIT_LIST_PERCENT
, L.UNIT_PERCENT_BASE_PRICE
, L.SERVICE_NUMBER
, L.SERVICE_REFERENCE_TYPE_CODE
, L.SERVICE_REFERENCE_LINE_ID
, L.SERVICE_REFERENCE_SYSTEM_ID
, L.FLOW_STATUS_CODE
, L.MODEL_REMNANT_FLAG
, L.FULFILLMENT_METHOD_CODE
, L.CALCULATE_PRICE_FLAG
, L.REVENUE_AMOUNT
, L.FULFILLMENT_DATE
, L.PREFERRED_GRADE
, L.ORDERED_QUANTITY2
, L.ORDERED_QUANTITY_UOM2
, L.SHIPPED_QUANTITY2
, L.CANCELLED_QUANTITY2
, L.SHIPPING_QUANTITY2
, L.SHIPPING_QUANTITY_UOM2
, L.FULFILLED_QUANTITY2
, L.UNIT_SELLING_PRICE_PER_PQTY
, L.UNIT_LIST_PRICE_PER_PQTY
, L.CUSTOMER_LINE_NUMBER
, L.CUSTOMER_SHIPMENT_NUMBER
, L.CUSTOMER_ITEM_NET_PRICE
, L.CUSTOMER_PAYMENT_TERM_ID
, L.ORIGINAL_INVENTORY_ITEM_ID
, L.ORIGINAL_ITEM_IDENTIFIER_TYPE
, L.ORIGINAL_ORDERED_ITEM_ID
, L.ORIGINAL_ORDERED_ITEM
, L.ITEM_SUBSTITUTION_TYPE_CODE
, L.LATE_DEMAND_PENALTY_FACTOR
, L.OVERRIDE_ATP_DATE_CODE
, L.USER_ITEM_DESCRIPTION
, L.ITEM_RELATIONSHIP_TYPE
, L.BLANKET_NUMBER
, L.BLANKET_LINE_NUMBER
, L.BLANKET_VERSION_NUMBER
, L.RETROBILL_REQUEST_ID
, L.MINISITE_ID
, L.END_CUSTOMER_ID
, L.END_CUSTOMER_CONTACT_ID
, L.END_CUSTOMER_SITE_USE_ID
, NULL END_CUSTOMER_NAME
, NULL END_CUSTOMER_NUMBER
, NULL END_CUSTOMER_CONTACT
, NULL END_CUSTOMER_LOCATION
, NULL END_CUSTOMER_ADDRESS1
, NULL END_CUSTOMER_ADDRESS2
, NULL END_CUSTOMER_ADDRESS3
, NULL END_CUSTOMER_ADDRESS4
, NULL END_CUSTOMER_ADDRESS5
, L.IB_OWNER
, L.IB_CURRENT_LOCATION
, L.IB_INSTALLED_AT_LOCATION
, L.PHASE_CHANGE_FLAG
, L.VERSION_FLAG
, H.VERSION_FLAG HDR_VERSION_FLAG
, L.AUDIT_FLAG
, L.REASON_ID
, L.FIRM_DEMAND_FLAG
, L.EARLIEST_SHIP_DATE
, L.SERVICE_CREDIT_ELIGIBLE_CODE
, L.ORDER_FIRMED_DATE
, L.ACTUAL_FULFILLMENT_DATE
, L.CHARGE_PERIODICITY_CODE
, L.CONTINGENCY_ID
, L.REVREC_EVENT_CODE
, L.REVREC_EXPIRATION_DAYS
, L.ACCEPTED_QUANTITY
, L.ACCEPTED_BY
, L.REVREC_COMMENTS
, L.REVREC_REFERENCE_DOCUMENT
, L.REVREC_SIGNATURE
, L.REVREC_SIGNATURE_DATE
, L.REVREC_IMPLICIT_FLAG
, L.SERVICE_BILL_PROFILE_ID
, L.SERVICE_COV_TEMPLATE_ID
, L.SERVICE_SUBS_TEMPLATE_ID
, L.SERVICE_BILL_OPTION_CODE
, L.SERVICE_FIRST_PERIOD_AMOUNT
, L.SERVICE_FIRST_PERIOD_ENDDATE
, L.SUBSCRIPTION_ENABLE_FLAG
FROM MTL_PARAMETERS SHIP_FROM_ORG
, HZ_CUST_SITE_USES_ALL SHIP_SU
, HZ_PARTY_SITES SHIP_PS
, HZ_LOCATIONS SHIP_LOC
, HZ_CUST_ACCT_SITES_ALL SHIP_CAS
, HZ_CUST_SITE_USES_ALL BILL_SU
, HZ_PARTY_SITES BILL_PS
, HZ_LOCATIONS BILL_LOC
, HZ_CUST_ACCT_SITES_ALL BILL_CAS
, HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
, HZ_CUST_ACCOUNT_ROLES SHIP_ROLES
, HZ_PARTIES SHIP_PARTY
, HZ_RELATIONSHIPS SHIP_REL
, HZ_CUST_ACCOUNTS SHIP_ACCT
, AR_LOOKUPS SHIP_ARL
, HZ_CUST_ACCOUNT_ROLES INVOICE_ROLES
, HZ_PARTIES INVOICE_PARTY
, HZ_RELATIONSHIPS INVOICE_REL
, HZ_CUST_ACCOUNTS INVOICE_ACCT
, AR_LOOKUPS INVOICE_ARL
, OE_ORDER_HEADER_HISTORY H
, OE_ORDER_LINES_HISTORY L
, QP_LIST_HEADERS_TL PL
, QP_LIST_HEADERS_B PL1
, RA_RULES ACCRULE
, RA_RULES INVRULE
, RA_TERMS_TL TERM
, OE_TRANSACTION_TYPES_TL LT
WHERE L.LINE_TYPE_ID = LT.TRANSACTION_TYPE_ID
AND LT.LANGUAGE = USERENV('LANG')
AND L.PRICE_LIST_ID = PL.LIST_HEADER_ID (+)
AND PL.LANGUAGE(+) = USERENV('LANG')
AND PL.LIST_HEADER_ID = PL1.LIST_HEADER_ID (+)
AND L.ACCOUNTING_RULE_ID = ACCRULE.RULE_ID (+)
AND L.INVOICING_RULE_ID = INVRULE.RULE_ID (+)
AND L.PAYMENT_TERM_ID = TERM.TERM_ID (+)
AND TERM.LANGUAGE(+) = USERENV('LANG')
AND L.SOLD_TO_ORG_ID = CUST_ACCT.CUST_ACCOUNT_ID(+)
AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID(+)
AND L.SHIP_FROM_ORG_ID = SHIP_FROM_ORG.ORGANIZATION_ID (+)
AND L.SHIP_TO_ORG_ID = SHIP_SU.SITE_USE_ID(+)
AND SHIP_SU.CUST_ACCT_SITE_ID= SHIP_CAS.CUST_ACCT_SITE_ID(+)
AND SHIP_CAS.PARTY_SITE_ID = SHIP_PS.PARTY_SITE_ID(+)
AND SHIP_LOC.LOCATION_ID(+) = SHIP_PS.LOCATION_ID
AND L.INVOICE_TO_ORG_ID = BILL_SU.SITE_USE_ID(+)
AND BILL_SU.CUST_ACCT_SITE_ID= BILL_CAS.CUST_ACCT_SITE_ID(+)
AND BILL_CAS.PARTY_SITE_ID = BILL_PS.PARTY_SITE_ID(+)
AND BILL_LOC.LOCATION_ID(+) = BILL_PS.LOCATION_ID
AND L.SHIP_TO_CONTACT_ID = SHIP_ROLES.CUST_ACCOUNT_ROLE_ID(+)
AND SHIP_ROLES.PARTY_ID = SHIP_REL.PARTY_ID(+)
AND SHIP_ROLES.ROLE_TYPE(+) = 'CONTACT'
AND SHIP_REL.SUBJECT_ID = SHIP_PARTY.PARTY_ID(+)
AND SHIP_ARL.LOOKUP_TYPE(+) = 'CONTACT_TITLE'
AND SHIP_ARL.LOOKUP_CODE(+) = SHIP_PARTY.PERSON_PRE_NAME_ADJUNCT
AND SHIP_ROLES.CUST_ACCOUNT_ID = SHIP_ACCT.CUST_ACCOUNT_ID(+)
AND NVL(SHIP_REL.OBJECT_ID
, -1) = NVL(SHIP_ACCT.PARTY_ID
, -1)
AND L.INVOICE_TO_CONTACT_ID = INVOICE_ROLES.CUST_ACCOUNT_ROLE_ID(+)
AND INVOICE_ROLES.PARTY_ID = INVOICE_REL.PARTY_ID(+)
AND INVOICE_ROLES.ROLE_TYPE(+) = 'CONTACT'
AND INVOICE_REL.SUBJECT_ID = INVOICE_PARTY.PARTY_ID(+)
AND INVOICE_ROLES.CUST_ACCOUNT_ID = INVOICE_ACCT.CUST_ACCOUNT_ID(+)
AND NVL(INVOICE_REL.OBJECT_ID
, -1) = NVL(INVOICE_ACCT.PARTY_ID
, -1)
AND INVOICE_ARL.LOOKUP_TYPE(+) = 'CONTACT_TITLE'
AND INVOICE_ARL.LOOKUP_CODE(+) = INVOICE_PARTY.PERSON_PRE_NAME_ADJUNCT
AND L.HEADER_ID = H.HEADER_ID
AND L.VERSION_NUMBER=H.VERSION_NUMBER
AND L.TRANSACTION_PHASE_CODE=H.TRANSACTION_PHASE_CODE
AND SHIP_REL.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
AND INVOICE_REL.OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
AND INVOICE_REL.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
AND SHIP_REL.OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'