[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ACCOUNTING_RULE_ID
, ACCOUNTING_RULE_DURATION
, AGREEMENT_ID
, ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE2
, ATTRIBUTE20
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, BLANKET_NUMBER
, BOOKED_FLAG
, BOOKED_DATE
, CANCELLED_FLAG
, CONTEXT
, CONVERSION_RATE
, CONVERSION_RATE_DATE
, CONVERSION_TYPE_CODE
, CUSTOMER_PREFERENCE_SET_CODE
, CREATED_BY
, CREATION_DATE
, CUST_PO_NUMBER
, DELIVER_TO_CONTACT_ID
, DELIVER_TO_ORG_ID
, DEMAND_CLASS_CODE
, FIRST_ACK_CODE
, FIRST_ACK_DATE
, EXPIRATION_DATE
, EARLIEST_SCHEDULE_LIMIT
, FOB_POINT_CODE
, FREIGHT_CARRIER_CODE
, FREIGHT_TERMS_CODE
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE_CATEGORY
, HEADER_ID
, INVOICE_TO_CONTACT_ID
, INVOICE_TO_ORG_ID
, INVOICING_RULE_ID
, LAST_ACK_CODE
, LAST_ACK_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LATEST_SCHEDULE_LIMIT
, OPEN_FLAG
, ORDERED_DATE
, ORDER_DATE_TYPE_CODE
, ORDER_NUMBER
, ORDER_SOURCE_ID
, ORDER_TYPE_ID
, ORDER_CATEGORY_CODE
, ORG_ID
, ORIG_SYS_DOCUMENT_REF
, PARTIAL_SHIPMENTS_ALLOWED
, PAYMENT_TERM_ID
, PRICE_LIST_ID
, PRICE_REQUEST_CODE -- PROMOTIONS SEP/01
, PRICING_DATE
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_DATE
, REQUEST_ID
, RETURN_REASON_CODE
, SALESREP_ID
, SALES_CHANNEL_CODe
, SHIPMENT_PRIORITY_CODE
, SHIPPING_METHOD_CODE
, SHIP_FROM_ORG_ID
, SHIP_TOLERANCE_ABOVE
, SHIP_TOLERANCE_BELOW
, SHIP_TO_CONTACT_ID
, SHIP_TO_ORG_ID
, SOLD_FROM_ORG_ID
, SOLD_TO_CONTACT_ID
, SOLD_TO_ORG_ID
, SOLD_TO_PHONE_ID
, SOURCE_DOCUMENT_ID
, SOURCE_DOCUMENT_TYPE_ID
, TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE
, TAX_POINT_CODE
, TRANSACTIONAL_CURR_CODE
, VERSION_NUMBER
, PAYMENT_TYPE_CODE
, PAYMENT_AMOUNT
, CHECK_NUMBER
, CREDIT_CARD_CODE
, CREDIT_CARD_HOLDER_NAME
, CREDIT_CARD_NUMBER
, CREDIT_CARD_EXPIRATION_DATE
, CREDIT_CARD_APPROVAL_DATE
, CREDIT_CARD_APPROVAL_CODE
, SHIPPING_INSTRUCTIONS
, PACKING_INSTRUCTIONS
, FLOW_STATUS_CODE
, MARKETING_SOURCE_CODE_ID
-- , DEFAULT_FULFILLMENT_SET
-- , FULFILLMENT_SET_NAME
-- , LINE_SET_NAME
, TP_ATTRIBUTE1
, TP_ATTRIBUTE10
, TP_ATTRIBUTE11
, TP_ATTRIBUTE12
, TP_ATTRIBUTE13
, TP_ATTRIBUTE14
, TP_ATTRIBUTE15
, TP_ATTRIBUTE2
, TP_ATTRIBUTE3
, TP_ATTRIBUTE4
, TP_ATTRIBUTE5
, TP_ATTRIBUTE6
, TP_ATTRIBUTE7
, TP_ATTRIBUTE8
, TP_ATTRIBUTE9
, TP_CONTEXT
-- , XML_MESSAGE_ID
, upgraded_flag
, LOCK_CONTROL
, quote_date
, quote_number
, sales_document_name
, transaction_phase_code
, user_status_code
, draft_submitted_flag
, source_document_version_number
, sold_to_site_use_id
, MINISITE_ID
, IB_OWNER
, IB_INSTALLED_AT_LOCATION
, IB_CURRENT_LOCATION
, END_CUSTOMER_ID
, END_CUSTOMER_CONTACT_ID
, END_CUSTOMER_SITE_USE_ID
, SUPPLIER_SIGNATURE
, SUPPLIER_SIGNATURE_DATE
, CUSTOMER_SIGNATURE
, CUSTOMER_SIGNATURE_DATE
, INSTRUMENT_ID
INTO x_header_rec.accounting_rule_id
, x_header_rec.accounting_rule_duration
, x_header_rec.agreement_id
, x_header_rec.attribute1
, x_header_rec.attribute10
, x_header_rec.attribute11
, x_header_rec.attribute12
, x_header_rec.attribute13
, x_header_rec.attribute14
, x_header_rec.attribute15
, x_header_rec.attribute16
, x_header_rec.attribute17
, x_header_rec.attribute18
, x_header_rec.attribute19
, x_header_rec.attribute2
, x_header_rec.attribute20
, x_header_rec.attribute3
, x_header_rec.attribute4
, x_header_rec.attribute5
, x_header_rec.attribute6
, x_header_rec.attribute7
, x_header_rec.attribute8
, x_header_rec.attribute9
, x_header_rec.Blanket_Number
, x_header_rec.booked_flag
, x_header_rec.booked_date
, x_header_rec.cancelled_flag
, x_header_rec.context
, x_header_rec.conversion_rate
, x_header_rec.conversion_rate_date
, x_header_rec.conversion_type_code
, x_header_rec.CUSTOMER_PREFERENCE_SET_CODE
, x_header_rec.created_by
, x_header_rec.creation_date
, x_header_rec.cust_po_number
, x_header_rec.deliver_to_contact_id
, x_header_rec.deliver_to_org_id
, x_header_rec.demand_class_code
, x_header_rec.first_ack_code
, x_header_rec.first_ack_date
, x_header_rec.expiration_date
, x_header_rec.earliest_schedule_limit
, x_header_rec.fob_point_code
, x_header_rec.freight_carrier_code
, x_header_rec.freight_terms_code
, x_header_rec.global_attribute1
, x_header_rec.global_attribute10
, x_header_rec.global_attribute11
, x_header_rec.global_attribute12
, x_header_rec.global_attribute13
, x_header_rec.global_attribute14
, x_header_rec.global_attribute15
, x_header_rec.global_attribute16
, x_header_rec.global_attribute17
, x_header_rec.global_attribute18
, x_header_rec.global_attribute19
, x_header_rec.global_attribute2
, x_header_rec.global_attribute20
, x_header_rec.global_attribute3
, x_header_rec.global_attribute4
, x_header_rec.global_attribute5
, x_header_rec.global_attribute6
, x_header_rec.global_attribute7
, x_header_rec.global_attribute8
, x_header_rec.global_attribute9
, x_header_rec.global_attribute_category
, x_header_rec.header_id
, x_header_rec.invoice_to_contact_id
, x_header_rec.invoice_to_org_id
, x_header_rec.invoicing_rule_id
, x_header_rec.last_ack_code
, x_header_rec.last_ack_date
, x_header_rec.last_updated_by
, x_header_rec.last_update_date
, x_header_rec.last_update_login
, x_header_rec.latest_schedule_limit
, x_header_rec.open_flag
, x_header_rec.ordered_date
, x_header_rec.order_date_type_code
, x_header_rec.order_number
, x_header_rec.order_source_id
, x_header_rec.order_type_id
, x_header_rec.order_category_code
, x_header_rec.org_id
, x_header_rec.orig_sys_document_ref
, x_header_rec.partial_shipments_allowed
, x_header_rec.payment_term_id
, x_header_rec.price_list_id
, x_header_rec.price_request_code -- PROMOTIONS SEP/01
, x_header_rec.pricing_date
, x_header_rec.program_application_id
, x_header_rec.program_id
, x_header_rec.program_update_date
, x_header_rec.request_date
, x_header_rec.request_id
, x_header_rec.return_reason_code
, x_header_rec.salesrep_id
, x_header_rec.sales_channel_code
, x_header_rec.shipment_priority_code
, x_header_rec.shipping_method_code
, x_header_rec.ship_from_org_id
, x_header_rec.ship_tolerance_above
, x_header_rec.ship_tolerance_below
, x_header_rec.ship_to_contact_id
, x_header_rec.ship_to_org_id
, x_header_rec.sold_from_org_id
, x_header_rec.sold_to_contact_id
, x_header_rec.sold_to_org_id
, x_header_rec.sold_to_phone_id
, x_header_rec.source_document_id
, x_header_rec.source_document_type_id
, x_header_rec.tax_exempt_flag
, x_header_rec.tax_exempt_number
, x_header_rec.tax_exempt_reason_code
, x_header_rec.tax_point_code
, x_header_rec.transactional_curr_code
, x_header_rec.version_number
, x_header_rec.payment_type_code
, x_header_rec.payment_amount
, x_header_rec.check_number
, x_header_rec.credit_card_code
, x_header_rec.credit_card_holder_name
, x_header_rec.credit_card_number
, x_header_rec.credit_card_expiration_date
, x_header_rec.credit_card_approval_date
, x_header_rec.credit_card_approval_code
, x_header_rec.shipping_instructions
, x_header_rec.packing_instructions
, x_header_rec.flow_status_code
, x_header_rec.marketing_source_code_id
-- , x_header_rec.default_fulfillment_set
-- , x_header_rec.fulfillment_set_name
-- , x_header_rec.line_set_name
, x_header_rec.tp_attribute1
, x_header_rec.tp_attribute10
, x_header_rec.tp_attribute11
, x_header_rec.tp_attribute12
, x_header_rec.tp_attribute13
, x_header_rec.tp_attribute14
, x_header_rec.tp_attribute15
, x_header_rec.tp_attribute2
, x_header_rec.tp_attribute3
, x_header_rec.tp_attribute4
, x_header_rec.tp_attribute5
, x_header_rec.tp_attribute6
, x_header_rec.tp_attribute7
, x_header_rec.tp_attribute8
, x_header_rec.tp_attribute9
, x_header_rec.tp_context
-- , x_header_rec.xml_message_id
, x_header_rec.upgraded_flag
, x_header_rec.lock_control
, x_header_rec.quote_date
, x_header_rec.quote_number
, x_header_rec.sales_document_name
, x_header_rec.transaction_phase_code
, x_header_rec.user_status_code
, x_header_rec.draft_submitted_flag
, x_header_rec.source_document_version_number
, x_header_rec.sold_to_site_use_id
, x_header_rec.MINISITE_ID
, x_header_rec.IB_OWNER
, x_header_rec.IB_INSTALLED_AT_LOCATION
, x_header_rec.IB_CURRENT_LOCATION
, x_header_rec.END_CUSTOMER_ID
, x_header_rec.END_CUSTOMER_CONTACT_ID
, x_header_rec.END_CUSTOMER_SITE_USE_ID
, x_header_rec.SUPPLIER_SIGNATURE
, x_header_rec.SUPPLIER_SIGNATURE_DATE
, x_header_rec.CUSTOMER_SIGNATURE
, x_header_rec.CUSTOMER_SIGNATURE_DATE
, x_header_rec.CC_INSTRUMENT_ID
FROM OE_ORDER_HEADER_HISTORY
WHERE HEADER_ID = p_header_id
AND VERSION_NUMBER = p_version
AND (PHASE_CHANGE_FLAG = p_phase_change_flag
OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'
AND VERSION_FLAG = 'Y'));
SELECT ACCOUNTING_RULE_ID
, ACCOUNTING_RULE_DURATION
, AGREEMENT_ID
, ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE2
, ATTRIBUTE20
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, BLANKET_NUMBER
, BOOKED_FLAG
, BOOKED_DATE
, CANCELLED_FLAG
, CONTEXT
, CONVERSION_RATE
, CONVERSION_RATE_DATE
, CONVERSION_TYPE_CODE
, CUSTOMER_PREFERENCE_SET_CODE
, CREATED_BY
, CREATION_DATE
, CUST_PO_NUMBER
, DELIVER_TO_CONTACT_ID
, DELIVER_TO_ORG_ID
, DEMAND_CLASS_CODE
, FIRST_ACK_CODE
, FIRST_ACK_DATE
, EXPIRATION_DATE
, EARLIEST_SCHEDULE_LIMIT
, FOB_POINT_CODE
, FREIGHT_CARRIER_CODE
, FREIGHT_TERMS_CODE
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE_CATEGORY
, HEADER_ID
, INVOICE_TO_CONTACT_ID
, INVOICE_TO_ORG_ID
, INVOICING_RULE_ID
, LAST_ACK_CODE
, LAST_ACK_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LATEST_SCHEDULE_LIMIT
, OPEN_FLAG
, ORDERED_DATE
, ORDER_DATE_TYPE_CODE
, ORDER_NUMBER
, ORDER_SOURCE_ID
, ORDER_TYPE_ID
, ORDER_CATEGORY_CODE
, ORG_ID
, ORIG_SYS_DOCUMENT_REF
, PARTIAL_SHIPMENTS_ALLOWED
, PAYMENT_TERM_ID
, PRICE_LIST_ID
, PRICE_REQUEST_CODE -- PROMOTIONS SEP/01
, PRICING_DATE
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_DATE
, REQUEST_ID
, RETURN_REASON_CODE
, SALESREP_ID
, SALES_CHANNEL_CODe
, SHIPMENT_PRIORITY_CODE
, SHIPPING_METHOD_CODE
, SHIP_FROM_ORG_ID
, SHIP_TOLERANCE_ABOVE
, SHIP_TOLERANCE_BELOW
, SHIP_TO_CONTACT_ID
, SHIP_TO_ORG_ID
, SOLD_FROM_ORG_ID
, SOLD_TO_CONTACT_ID
, SOLD_TO_ORG_ID
, SOLD_TO_PHONE_ID
, SOURCE_DOCUMENT_ID
, SOURCE_DOCUMENT_TYPE_ID
, TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE
, TAX_POINT_CODE
, TRANSACTIONAL_CURR_CODE
, VERSION_NUMBER
, PAYMENT_TYPE_CODE
, PAYMENT_AMOUNT
, CHECK_NUMBER
, CREDIT_CARD_CODE
, CREDIT_CARD_HOLDER_NAME
, CREDIT_CARD_NUMBER
, CREDIT_CARD_EXPIRATION_DATE
, CREDIT_CARD_APPROVAL_DATE
, CREDIT_CARD_APPROVAL_CODE
, SHIPPING_INSTRUCTIONS
, PACKING_INSTRUCTIONS
, FLOW_STATUS_CODE
, MARKETING_SOURCE_CODE_ID
-- , DEFAULT_FULFILLMENT_SET
-- , FULFILLMENT_SET_NAME
-- , LINE_SET_NAME
, TP_ATTRIBUTE1
, TP_ATTRIBUTE10
, TP_ATTRIBUTE11
, TP_ATTRIBUTE12
, TP_ATTRIBUTE13
, TP_ATTRIBUTE14
, TP_ATTRIBUTE15
, TP_ATTRIBUTE2
, TP_ATTRIBUTE3
, TP_ATTRIBUTE4
, TP_ATTRIBUTE5
, TP_ATTRIBUTE6
, TP_ATTRIBUTE7
, TP_ATTRIBUTE8
, TP_ATTRIBUTE9
, TP_CONTEXT
-- , XML_MESSAGE_ID
, upgraded_flag
, LOCK_CONTROL
, quote_date
, quote_number
, sales_document_name
, transaction_phase_code
, user_status_code
, draft_submitted_flag
, source_document_version_number
, sold_to_site_use_id
, MINISITE_ID
, IB_OWNER
, IB_INSTALLED_AT_LOCATION
, IB_CURRENT_LOCATION
, END_CUSTOMER_ID
, END_CUSTOMER_CONTACT_ID
, END_CUSTOMER_SITE_USE_ID
, SUPPLIER_SIGNATURE
, SUPPLIER_SIGNATURE_DATE
, CUSTOMER_SIGNATURE
, CUSTOMER_SIGNATURE_DATE
INTO x_header_rec.accounting_rule_id
, x_header_rec.accounting_rule_duration
, x_header_rec.agreement_id
, x_header_rec.attribute1
, x_header_rec.attribute10
, x_header_rec.attribute11
, x_header_rec.attribute12
, x_header_rec.attribute13
, x_header_rec.attribute14
, x_header_rec.attribute15
, x_header_rec.attribute16
, x_header_rec.attribute17
, x_header_rec.attribute18
, x_header_rec.attribute19
, x_header_rec.attribute2
, x_header_rec.attribute20
, x_header_rec.attribute3
, x_header_rec.attribute4
, x_header_rec.attribute5
, x_header_rec.attribute6
, x_header_rec.attribute7
, x_header_rec.attribute8
, x_header_rec.attribute9
, x_header_rec.Blanket_Number
, x_header_rec.booked_flag
, x_header_rec.booked_date
, x_header_rec.cancelled_flag
, x_header_rec.context
, x_header_rec.conversion_rate
, x_header_rec.conversion_rate_date
, x_header_rec.conversion_type_code
, x_header_rec.CUSTOMER_PREFERENCE_SET_CODE
, x_header_rec.created_by
, x_header_rec.creation_date
, x_header_rec.cust_po_number
, x_header_rec.deliver_to_contact_id
, x_header_rec.deliver_to_org_id
, x_header_rec.demand_class_code
, x_header_rec.first_ack_code
, x_header_rec.first_ack_date
, x_header_rec.expiration_date
, x_header_rec.earliest_schedule_limit
, x_header_rec.fob_point_code
, x_header_rec.freight_carrier_code
, x_header_rec.freight_terms_code
, x_header_rec.global_attribute1
, x_header_rec.global_attribute10
, x_header_rec.global_attribute11
, x_header_rec.global_attribute12
, x_header_rec.global_attribute13
, x_header_rec.global_attribute14
, x_header_rec.global_attribute15
, x_header_rec.global_attribute16
, x_header_rec.global_attribute17
, x_header_rec.global_attribute18
, x_header_rec.global_attribute19
, x_header_rec.global_attribute2
, x_header_rec.global_attribute20
, x_header_rec.global_attribute3
, x_header_rec.global_attribute4
, x_header_rec.global_attribute5
, x_header_rec.global_attribute6
, x_header_rec.global_attribute7
, x_header_rec.global_attribute8
, x_header_rec.global_attribute9
, x_header_rec.global_attribute_category
, x_header_rec.header_id
, x_header_rec.invoice_to_contact_id
, x_header_rec.invoice_to_org_id
, x_header_rec.invoicing_rule_id
, x_header_rec.last_ack_code
, x_header_rec.last_ack_date
, x_header_rec.last_updated_by
, x_header_rec.last_update_date
, x_header_rec.last_update_login
, x_header_rec.latest_schedule_limit
, x_header_rec.open_flag
, x_header_rec.ordered_date
, x_header_rec.order_date_type_code
, x_header_rec.order_number
, x_header_rec.order_source_id
, x_header_rec.order_type_id
, x_header_rec.order_category_code
, x_header_rec.org_id
, x_header_rec.orig_sys_document_ref
, x_header_rec.partial_shipments_allowed
, x_header_rec.payment_term_id
, x_header_rec.price_list_id
, x_header_rec.price_request_code -- PROMOTIONS SEP/01
, x_header_rec.pricing_date
, x_header_rec.program_application_id
, x_header_rec.program_id
, x_header_rec.program_update_date
, x_header_rec.request_date
, x_header_rec.request_id
, x_header_rec.return_reason_code
, x_header_rec.salesrep_id
, x_header_rec.sales_channel_code
, x_header_rec.shipment_priority_code
, x_header_rec.shipping_method_code
, x_header_rec.ship_from_org_id
, x_header_rec.ship_tolerance_above
, x_header_rec.ship_tolerance_below
, x_header_rec.ship_to_contact_id
, x_header_rec.ship_to_org_id
, x_header_rec.sold_from_org_id
, x_header_rec.sold_to_contact_id
, x_header_rec.sold_to_org_id
, x_header_rec.sold_to_phone_id
, x_header_rec.source_document_id
, x_header_rec.source_document_type_id
, x_header_rec.tax_exempt_flag
, x_header_rec.tax_exempt_number
, x_header_rec.tax_exempt_reason_code
, x_header_rec.tax_point_code
, x_header_rec.transactional_curr_code
, x_header_rec.version_number
, x_header_rec.payment_type_code
, x_header_rec.payment_amount
, x_header_rec.check_number
, x_header_rec.credit_card_code
, x_header_rec.credit_card_holder_name
, x_header_rec.credit_card_number
, x_header_rec.credit_card_expiration_date
, x_header_rec.credit_card_approval_date
, x_header_rec.credit_card_approval_code
, x_header_rec.shipping_instructions
, x_header_rec.packing_instructions
, x_header_rec.flow_status_code
, x_header_rec.marketing_source_code_id
-- , x_header_rec.default_fulfillment_set
-- , x_header_rec.fulfillment_set_name
-- , x_header_rec.line_set_name
, x_header_rec.tp_attribute1
, x_header_rec.tp_attribute10
, x_header_rec.tp_attribute11
, x_header_rec.tp_attribute12
, x_header_rec.tp_attribute13
, x_header_rec.tp_attribute14
, x_header_rec.tp_attribute15
, x_header_rec.tp_attribute2
, x_header_rec.tp_attribute3
, x_header_rec.tp_attribute4
, x_header_rec.tp_attribute5
, x_header_rec.tp_attribute6
, x_header_rec.tp_attribute7
, x_header_rec.tp_attribute8
, x_header_rec.tp_attribute9
, x_header_rec.tp_context
-- , x_header_rec.xml_message_id
, x_header_rec.upgraded_flag
, x_header_rec.lock_control
, x_header_rec.quote_date
, x_header_rec.quote_number
, x_header_rec.sales_document_name
, x_header_rec.transaction_phase_code
, x_header_rec.user_status_code
, x_header_rec.draft_submitted_flag
, x_header_rec.source_document_version_number
, x_header_rec.sold_to_site_use_id
, x_header_rec.MINISITE_ID
, x_header_rec.IB_OWNER
, x_header_rec.IB_INSTALLED_AT_LOCATION
, x_header_rec.IB_CURRENT_LOCATION
, x_header_rec.END_CUSTOMER_ID
, x_header_rec.END_CUSTOMER_CONTACT_ID
, x_header_rec.END_CUSTOMER_SITE_USE_ID
, x_header_rec.SUPPLIER_SIGNATURE
, x_header_rec.SUPPLIER_SIGNATURE_DATE
, x_header_rec.CUSTOMER_SIGNATURE
, x_header_rec.CUSTOMER_SIGNATURE_DATE
FROM OE_ORDER_HEADERS_ALL
WHERE HEADER_ID = p_header_id
AND VERSION_NUMBER = p_version;
select
DECODE(x_deliver_to_location, NULL, NULL,x_deliver_to_location|| ', ') ||
DECODE(x_deliver_to_address1, NULL, NULL,x_deliver_to_address1 || ', ') ||
DECODE(x_deliver_to_address2, NULL, NULL,x_deliver_to_address3 || ', ') ||
DECODE(x_deliver_to_address3, NULL, NULL,x_deliver_to_address3 || ', ') ||
DECODE(x_deliver_to_address4, NULL, NULL,x_deliver_to_address4 || ', ') ||
DECODE(x_deliver_to_city, NULL, NULL,x_deliver_to_city || ', ') ||
DECODE(x_deliver_to_state, NULL, NULL,x_deliver_to_state || ', ') ||
DECODE(x_deliver_to_postal_code, NULL, NULL,x_deliver_to_postal_code || ', ') ||
DECODE(x_deliver_to_country, NULL,x_deliver_to_country)
into x_prior_deliver_to_address from dual;
select
DECODE(x_deliver_to_location, NULL, NULL,x_deliver_to_location|| ', ') ||
DECODE(x_deliver_to_address1, NULL, NULL,x_deliver_to_address1 || ', ') ||
DECODE(x_deliver_to_address2, NULL, NULL,x_deliver_to_address3 || ', ') ||
DECODE(x_deliver_to_address3, NULL, NULL,x_deliver_to_address3 || ', ') ||
DECODE(x_deliver_to_address4, NULL, NULL,x_deliver_to_address4 || ', ') ||
DECODE(x_deliver_to_city, NULL, NULL,x_deliver_to_city || ', ') ||
DECODE(x_deliver_to_state, NULL, NULL,x_deliver_to_state || ', ') ||
DECODE(x_deliver_to_postal_code, NULL, NULL,x_deliver_to_postal_code || ', ') ||
DECODE(x_deliver_to_country, NULL,x_deliver_to_country)
into x_current_deliver_to_address from dual;
select
DECODE(x_deliver_to_location, NULL, NULL,x_deliver_to_location|| ', ') ||
DECODE(x_deliver_to_address1, NULL, NULL,x_deliver_to_address1 || ', ') ||
DECODE(x_deliver_to_address2, NULL, NULL,x_deliver_to_address3 || ', ') ||
DECODE(x_deliver_to_address3, NULL, NULL,x_deliver_to_address3 || ', ') ||
DECODE(x_deliver_to_address4, NULL, NULL,x_deliver_to_address4 || ', ') ||
DECODE(x_deliver_to_city, NULL, NULL,x_deliver_to_city || ', ') ||
DECODE(x_deliver_to_state, NULL, NULL,x_deliver_to_state || ', ') ||
DECODE(x_deliver_to_postal_code, NULL, NULL,x_deliver_to_postal_code || ', ') ||
DECODE(x_deliver_to_country, NULL,NULL,x_deliver_to_country)
into x_prior_deliver_to_address from dual;
select
DECODE(x_deliver_to_location, NULL, NULL,x_deliver_to_location|| ', ') ||
DECODE(x_deliver_to_address1, NULL, NULL,x_deliver_to_address1 || ', ') ||
DECODE(x_deliver_to_address2, NULL, NULL,x_deliver_to_address3 || ', ') ||
DECODE(x_deliver_to_address3, NULL, NULL,x_deliver_to_address3 || ', ') ||
DECODE(x_deliver_to_address4, NULL, NULL,x_deliver_to_address4 || ', ') ||
DECODE(x_deliver_to_city, NULL, NULL,x_deliver_to_city || ', ') ||
DECODE(x_deliver_to_state, NULL, NULL,x_deliver_to_state || ', ') ||
DECODE(x_deliver_to_postal_code, NULL, NULL,x_deliver_to_postal_code || ', ') ||
DECODE(x_deliver_to_country, NULL,NULL,x_deliver_to_country)
into x_current_deliver_to_address from dual;
select
DECODE(x_deliver_to_location, NULL, NULL,x_deliver_to_location|| ', ') ||
DECODE(x_deliver_to_address1, NULL, NULL,x_deliver_to_address1 || ', ') ||
DECODE(x_deliver_to_address2, NULL, NULL,x_deliver_to_address3 || ', ') ||
DECODE(x_deliver_to_address3, NULL, NULL,x_deliver_to_address3 || ', ') ||
DECODE(x_deliver_to_address4, NULL, NULL,x_deliver_to_address4 || ', ') ||
DECODE(x_deliver_to_city, NULL, NULL,x_deliver_to_city || ', ') ||
DECODE(x_deliver_to_state, NULL, NULL,x_deliver_to_state || ', ') ||
DECODE(x_deliver_to_postal_code, NULL, NULL,x_deliver_to_postal_code || ', ') ||
DECODE(x_deliver_to_country, NULL,NULL,x_deliver_to_country)
into x_next_deliver_to_address from dual;
select
DECODE(x_invoice_to_location, NULL, NULL,x_invoice_to_location|| ', ') ||
DECODE(x_invoice_to_address1, NULL, NULL,x_invoice_to_address1 || ', ') ||
DECODE(x_invoice_to_address2, NULL, NULL,x_invoice_to_address3 || ', ') ||
DECODE(x_invoice_to_address3, NULL, NULL,x_invoice_to_address3 || ', ') ||
DECODE(x_invoice_to_address4, NULL, NULL,x_invoice_to_address4 || ', ') ||
DECODE(x_invoice_to_city, NULL, NULL,x_invoice_to_city || ', ') ||
DECODE(x_invoice_to_state, NULL, NULL,x_invoice_to_state || ', ') ||
DECODE(x_invoice_to_postal_code, NULL, NULL,x_invoice_to_postal_code || ', ') ||
DECODE(x_invoice_to_country, NULL,NULL,x_invoice_to_country)
into x_current_invoice_to_address from dual;
select
DECODE(x_invoice_to_location, NULL, NULL,x_invoice_to_location|| ', ') ||
DECODE(x_invoice_to_address1, NULL, NULL,x_invoice_to_address1 || ', ') ||
DECODE(x_invoice_to_address2, NULL, NULL,x_invoice_to_address3 || ', ') ||
DECODE(x_invoice_to_address3, NULL, NULL,x_invoice_to_address3 || ', ') ||
DECODE(x_invoice_to_address4, NULL, NULL,x_invoice_to_address4 || ', ') ||
DECODE(x_invoice_to_city, NULL, NULL,x_invoice_to_city || ', ') ||
DECODE(x_invoice_to_state, NULL, NULL,x_invoice_to_state || ', ') ||
DECODE(x_invoice_to_postal_code, NULL, NULL,x_invoice_to_postal_code || ', ') ||
DECODE(x_invoice_to_country, NULL,NULL,x_invoice_to_country)
into x_prior_invoice_to_address from dual;
select
DECODE(x_invoice_to_location, NULL, NULL,x_invoice_to_location|| ', ') ||
DECODE(x_invoice_to_address1, NULL, NULL,x_invoice_to_address1 || ', ') ||
DECODE(x_invoice_to_address2, NULL, NULL,x_invoice_to_address3 || ', ') ||
DECODE(x_invoice_to_address3, NULL, NULL,x_invoice_to_address3 || ', ') ||
DECODE(x_invoice_to_address4, NULL, NULL,x_invoice_to_address4 || ', ') ||
DECODE(x_invoice_to_city, NULL, NULL,x_invoice_to_city || ', ') ||
DECODE(x_invoice_to_state, NULL, NULL,x_invoice_to_state || ', ') ||
DECODE(x_invoice_to_postal_code, NULL, NULL,x_invoice_to_postal_code || ', ') ||
DECODE(x_invoice_to_country, NULL,NULL,x_invoice_to_country)
into x_prior_invoice_to_address from dual;
select
DECODE(x_invoice_to_location, NULL, NULL,x_invoice_to_location|| ', ') ||
DECODE(x_invoice_to_address1, NULL, NULL,x_invoice_to_address1 || ', ') ||
DECODE(x_invoice_to_address2, NULL, NULL,x_invoice_to_address3 || ', ') ||
DECODE(x_invoice_to_address3, NULL, NULL,x_invoice_to_address3 || ', ') ||
DECODE(x_invoice_to_address4, NULL, NULL,x_invoice_to_address4 || ', ') ||
DECODE(x_invoice_to_city, NULL, NULL,x_invoice_to_city || ', ') ||
DECODE(x_invoice_to_state, NULL, NULL,x_invoice_to_state || ', ') ||
DECODE(x_invoice_to_postal_code, NULL, NULL,x_invoice_to_postal_code || ', ') ||
DECODE(x_invoice_to_country, NULL,NULL,x_invoice_to_country)
into x_current_invoice_to_address from dual;
select
DECODE(x_invoice_to_location, NULL, NULL,x_invoice_to_location|| ', ') ||
DECODE(x_invoice_to_address1, NULL, NULL,x_invoice_to_address1 || ', ') ||
DECODE(x_invoice_to_address2, NULL, NULL,x_invoice_to_address3 || ', ') ||
DECODE(x_invoice_to_address3, NULL, NULL,x_invoice_to_address3 || ', ') ||
DECODE(x_invoice_to_address4, NULL, NULL,x_invoice_to_address4 || ', ') ||
DECODE(x_invoice_to_city, NULL, NULL,x_invoice_to_city || ', ') ||
DECODE(x_invoice_to_state, NULL, NULL,x_invoice_to_state || ', ') ||
DECODE(x_invoice_to_postal_code, NULL, NULL,x_invoice_to_postal_code || ', ') ||
DECODE(x_invoice_to_country, NULL,NULL,x_invoice_to_country)
into x_next_invoice_to_address from dual;
select
DECODE(x_ship_from_location, NULL, NULL,x_ship_from_location|| ', ') ||
DECODE(x_ship_from_address1, NULL, NULL,x_ship_from_address1 || ', ') ||
DECODE(x_ship_from_address2, NULL, NULL,x_ship_from_address3 || ', ') ||
DECODE(x_ship_from_address3, NULL, NULL,x_ship_from_address3 || ', ') ||
DECODE(x_ship_from_address4, NULL, NULL,x_ship_from_address4 || ', ')
into x_current_ship_from_address from dual;
select
DECODE(x_ship_from_location, NULL, NULL,x_ship_from_location|| ', ') ||
DECODE(x_ship_from_address1, NULL, NULL,x_ship_from_address1 || ', ') ||
DECODE(x_ship_from_address2, NULL, NULL,x_ship_from_address3 || ', ') ||
DECODE(x_ship_from_address3, NULL, NULL,x_ship_from_address3 || ', ') ||
DECODE(x_ship_from_address4, NULL, NULL,x_ship_from_address4 || ', ')
into x_prior_ship_from_address from dual;
select
DECODE(x_ship_from_location, NULL, NULL,x_ship_from_location|| ', ') ||
DECODE(x_ship_from_address1, NULL, NULL,x_ship_from_address1 || ', ') ||
DECODE(x_ship_from_address2, NULL, NULL,x_ship_from_address3 || ', ') ||
DECODE(x_ship_from_address3, NULL, NULL,x_ship_from_address3 || ', ') ||
DECODE(x_ship_from_address4, NULL, NULL,x_ship_from_address4 || ', ')
into x_prior_ship_from_address from dual;
select
DECODE(x_ship_from_location, NULL, NULL,x_ship_from_location|| ', ') ||
DECODE(x_ship_from_address1, NULL, NULL,x_ship_from_address1 || ', ') ||
DECODE(x_ship_from_address2, NULL, NULL,x_ship_from_address3 || ', ') ||
DECODE(x_ship_from_address3, NULL, NULL,x_ship_from_address3 || ', ') ||
DECODE(x_ship_from_address4, NULL, NULL,x_ship_from_address4 || ', ')
into x_current_ship_from_address from dual;
select
DECODE(x_ship_from_location, NULL, NULL,x_ship_from_location|| ', ') ||
DECODE(x_ship_from_address1, NULL, NULL,x_ship_from_address1 || ', ') ||
DECODE(x_ship_from_address2, NULL, NULL,x_ship_from_address3 || ', ') ||
DECODE(x_ship_from_address3, NULL, NULL,x_ship_from_address3 || ', ') ||
DECODE(x_ship_from_address4, NULL, NULL,x_ship_from_address4 || ', ')
into x_next_ship_from_address from dual;
select
DECODE(x_ship_to_location, NULL, NULL,x_ship_to_location|| ', ') ||
DECODE(x_ship_to_address1, NULL, NULL,x_ship_to_address1 || ', ') ||
DECODE(x_ship_to_address2, NULL, NULL,x_ship_to_address3 || ', ') ||
DECODE(x_ship_to_address3, NULL, NULL,x_ship_to_address3 || ', ') ||
DECODE(x_ship_to_address4, NULL, NULL,x_ship_to_address4 || ', ') ||
DECODE(x_ship_to_city, NULL, NULL,x_ship_to_city || ', ') ||
DECODE(x_ship_to_state, NULL, NULL,x_ship_to_state || ', ') ||
DECODE(x_ship_to_postal_code, NULL, NULL,x_ship_to_postal_code || ', ') ||
DECODE(x_ship_to_country, NULL,NULL,x_ship_to_country)
into x_current_ship_to_address from dual;
select
DECODE(x_ship_to_location, NULL, NULL,x_ship_to_location|| ', ') ||
DECODE(x_ship_to_address1, NULL, NULL,x_ship_to_address1 || ', ') ||
DECODE(x_ship_to_address2, NULL, NULL,x_ship_to_address3 || ', ') ||
DECODE(x_ship_to_address3, NULL, NULL,x_ship_to_address3 || ', ') ||
DECODE(x_ship_to_address4, NULL, NULL,x_ship_to_address4 || ', ') ||
DECODE(x_ship_to_city, NULL, NULL,x_ship_to_city || ', ') ||
DECODE(x_ship_to_state, NULL, NULL,x_ship_to_state || ', ') ||
DECODE(x_ship_to_postal_code, NULL, NULL,x_ship_to_postal_code || ', ') ||
DECODE(x_ship_to_country, NULL,NULL,x_ship_to_country)
into x_prior_ship_to_address from dual;
select
DECODE(x_ship_to_location, NULL, NULL,x_ship_to_location|| ', ') ||
DECODE(x_ship_to_address1, NULL, NULL,x_ship_to_address1 || ', ') ||
DECODE(x_ship_to_address2, NULL, NULL,x_ship_to_address3 || ', ') ||
DECODE(x_ship_to_address3, NULL, NULL,x_ship_to_address3 || ', ') ||
DECODE(x_ship_to_address4, NULL, NULL,x_ship_to_address4 || ', ') ||
DECODE(x_ship_to_city, NULL, NULL,x_ship_to_city || ', ') ||
DECODE(x_ship_to_state, NULL, NULL,x_ship_to_state || ', ') ||
DECODE(x_ship_to_postal_code, NULL, NULL,x_ship_to_postal_code || ', ') ||
DECODE(x_ship_to_country, NULL,NULL,x_ship_to_country)
into x_prior_ship_to_address from dual;
select
DECODE(x_ship_to_location, NULL, NULL,x_ship_to_location|| ', ') ||
DECODE(x_ship_to_address1, NULL, NULL,x_ship_to_address1 || ', ') ||
DECODE(x_ship_to_address2, NULL, NULL,x_ship_to_address3 || ', ') ||
DECODE(x_ship_to_address3, NULL, NULL,x_ship_to_address3 || ', ') ||
DECODE(x_ship_to_address4, NULL, NULL,x_ship_to_address4 || ', ') ||
DECODE(x_ship_to_city, NULL, NULL,x_ship_to_city || ', ') ||
DECODE(x_ship_to_state, NULL, NULL,x_ship_to_state || ', ') ||
DECODE(x_ship_to_postal_code, NULL, NULL,x_ship_to_postal_code || ', ') ||
DECODE(x_ship_to_country, NULL,NULL,x_ship_to_country)
into x_current_ship_to_address from dual;
select
DECODE(x_ship_to_location, NULL, NULL,x_ship_to_location|| ', ') ||
DECODE(x_ship_to_address1, NULL, NULL,x_ship_to_address1 || ', ') ||
DECODE(x_ship_to_address2, NULL, NULL,x_ship_to_address3 || ', ') ||
DECODE(x_ship_to_address3, NULL, NULL,x_ship_to_address3 || ', ') ||
DECODE(x_ship_to_address4, NULL, NULL,x_ship_to_address4 || ', ') ||
DECODE(x_ship_to_city, NULL, NULL,x_ship_to_city || ', ') ||
DECODE(x_ship_to_state, NULL, NULL,x_ship_to_state || ', ') ||
DECODE(x_ship_to_postal_code, NULL, NULL,x_ship_to_postal_code || ', ') ||
DECODE(x_ship_to_country, NULL,NULL,x_ship_to_country)
into x_next_ship_to_address from dual;
select encrypted
into l_encrypted
from iby_creditcard
where instrid=p_prior_rec.cc_instrument_id;
select encrypted
into l_encrypted
from iby_creditcard_h
where card_history_change_id=p_prior_rec.cc_instrument_id;
select encrypted
into l_encrypted1
from iby_creditcard
where instrid=p_curr_rec.cc_instrument_id;
select encrypted
into l_encrypted1
from iby_creditcard_h
where card_history_change_id=p_curr_rec.cc_instrument_id;
select encrypted
into l_encrypted
from iby_creditcard
where instrid=p_next_rec.cc_instrument_id;
select encrypted
into l_encrypted
from iby_creditcard_h
where card_history_change_id=p_next_rec.cc_instrument_id;
select encrypted
into l_encrypted1
from iby_creditcard
where instrid=p_curr_rec.cc_instrument_id;
select encrypted
into l_encrypted1
from iby_creditcard_h
where card_history_change_id=p_curr_rec.cc_instrument_id;
select
DECODE(x_sold_to_location, NULL, NULL,x_sold_to_location|| ', ') ||
DECODE(x_sold_to_location_address1, NULL, NULL,x_sold_to_location_address1 || ', ') ||
DECODE(x_sold_to_location_address2, NULL, NULL,x_sold_to_location_address3 || ', ') ||
DECODE(x_sold_to_location_address3, NULL, NULL,x_sold_to_location_address3 || ', ') ||
DECODE(x_sold_to_location_address4, NULL, NULL,x_sold_to_location_address4 || ', ') ||
DECODE(x_sold_to_location_city, NULL, NULL,x_sold_to_location_city || ', ') ||
DECODE(x_sold_to_location_state, NULL, NULL,x_sold_to_location_state || ', ') ||
DECODE(x_sold_to_location_postal_code, NULL, NULL,x_sold_to_location_postal_code || ', ') ||
DECODE(x_sold_to_location_country, NULL,NULL,x_sold_to_location_country)
into x_current_sold_to_location from dual;
select
DECODE(x_sold_to_location, NULL, NULL,x_sold_to_location|| ', ') ||
DECODE(x_sold_to_location_address1, NULL, NULL,x_sold_to_location_address1 || ', ') ||
DECODE(x_sold_to_location_address2, NULL, NULL,x_sold_to_location_address3 || ', ') ||
DECODE(x_sold_to_location_address3, NULL, NULL,x_sold_to_location_address3 || ', ') ||
DECODE(x_sold_to_location_address4, NULL, NULL,x_sold_to_location_address4 || ', ') ||
DECODE(x_sold_to_location_city, NULL, NULL,x_sold_to_location_city || ', ') ||
DECODE(x_sold_to_location_state, NULL, NULL,x_sold_to_location_state || ', ') ||
DECODE(x_sold_to_location_postal_code, NULL, NULL,x_sold_to_location_postal_code || ', ') ||
DECODE(x_sold_to_location_country, NULL,NULL,x_sold_to_location_country)
into x_prior_sold_to_location from dual;
select
DECODE(x_sold_to_location, NULL, NULL,x_sold_to_location|| ', ') ||
DECODE(x_sold_to_location_address1, NULL, NULL,x_sold_to_location_address1 || ', ') ||
DECODE(x_sold_to_location_address2, NULL, NULL,x_sold_to_location_address3 || ', ') ||
DECODE(x_sold_to_location_address3, NULL, NULL,x_sold_to_location_address3 || ', ') ||
DECODE(x_sold_to_location_address4, NULL, NULL,x_sold_to_location_address4 || ', ') ||
DECODE(x_sold_to_location_city, NULL, NULL,x_sold_to_location_city || ', ') ||
DECODE(x_sold_to_location_state, NULL, NULL,x_sold_to_location_state || ', ') ||
DECODE(x_sold_to_location_postal_code, NULL, NULL,x_sold_to_location_postal_code || ', ') ||
DECODE(x_sold_to_location_country, NULL,NULL,x_sold_to_location_country)
into x_prior_sold_to_location from dual;
select
DECODE(x_sold_to_location, NULL, NULL,x_sold_to_location|| ', ') ||
DECODE(x_sold_to_location_address1, NULL, NULL,x_sold_to_location_address1 || ', ') ||
DECODE(x_sold_to_location_address2, NULL, NULL,x_sold_to_location_address3 || ', ') ||
DECODE(x_sold_to_location_address3, NULL, NULL,x_sold_to_location_address3 || ', ') ||
DECODE(x_sold_to_location_address4, NULL, NULL,x_sold_to_location_address4 || ', ') ||
DECODE(x_sold_to_location_city, NULL, NULL,x_sold_to_location_city || ', ') ||
DECODE(x_sold_to_location_state, NULL, NULL,x_sold_to_location_state || ', ') ||
DECODE(x_sold_to_location_postal_code, NULL, NULL,x_sold_to_location_postal_code || ', ') ||
DECODE(x_sold_to_location_country, NULL,NULL,x_sold_to_location_country)
into x_current_sold_to_location from dual;
select
DECODE(x_sold_to_location, NULL, NULL,x_sold_to_location|| ', ') ||
DECODE(x_sold_to_location_address1, NULL, NULL,x_sold_to_location_address1 || ', ') ||
DECODE(x_sold_to_location_address2, NULL, NULL,x_sold_to_location_address3 || ', ') ||
DECODE(x_sold_to_location_address3, NULL, NULL,x_sold_to_location_address3 || ', ') ||
DECODE(x_sold_to_location_address4, NULL, NULL,x_sold_to_location_address4 || ', ') ||
DECODE(x_sold_to_location_city, NULL, NULL,x_sold_to_location_city || ', ') ||
DECODE(x_sold_to_location_state, NULL, NULL,x_sold_to_location_state || ', ') ||
DECODE(x_sold_to_location_postal_code, NULL, NULL,x_sold_to_location_postal_code || ', ') ||
DECODE(x_sold_to_location_country, NULL,NULL,x_sold_to_location_country)
into x_next_sold_to_location from dual;
SELECT ACCOUNTING_RULE_ID
, ACCOUNTING_RULE_DURATION
, ACTUAL_ARRIVAL_DATE
, ACTUAL_SHIPMENT_DATE
, AGREEMENT_ID
, ARRIVAL_SET_ID
, ATO_LINE_ID
, ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE2
, ATTRIBUTE20
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, AUTO_SELECTED_QUANTITY
, AUTHORIZED_TO_SHIP_FLAG
, BOOKED_FLAG
, CANCELLED_FLAG
, CANCELLED_QUANTITY
, COMPONENT_CODE
, COMPONENT_NUMBER
, COMPONENT_SEQUENCE_ID
, CONFIG_HEADER_ID
, CONFIG_REV_NBR
, CONFIG_DISPLAY_SEQUENCE
, CONFIGURATION_ID
, CONTEXT
, CREATED_BY
, CREATION_DATE
, CREDIT_INVOICE_LINE_ID
, CUSTOMER_DOCK_CODE
, CUSTOMER_JOB
, CUSTOMER_PRODUCTION_LINE
, CUST_PRODUCTION_SEQ_NUM
, CUSTOMER_TRX_LINE_ID
, CUST_MODEL_SERIAL_NUMBER
, CUST_PO_NUMBER
, CUSTOMER_LINE_NUMBER
, DELIVERY_LEAD_TIME
, DELIVER_TO_CONTACT_ID
, DELIVER_TO_ORG_ID
, DEMAND_BUCKET_TYPE_CODE
, DEMAND_CLASS_CODE
, DEP_PLAN_REQUIRED_FLAG
, EARLIEST_ACCEPTABLE_DATE
, END_ITEM_UNIT_NUMBER
, EXPLOSION_DATE
, FIRST_ACK_CODE
, FIRST_ACK_DATE
, FOB_POINT_CODE
, FREIGHT_CARRIER_CODE
, FREIGHT_TERMS_CODE
, FULFILLED_QUANTITY
, FULFILLED_FLAG
, FULFILLMENT_METHOD_CODE
, FULFILLMENT_DATE
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE_CATEGORY
, HEADER_ID
, INDUSTRY_ATTRIBUTE1
, INDUSTRY_ATTRIBUTE10
, INDUSTRY_ATTRIBUTE11
, INDUSTRY_ATTRIBUTE12
, INDUSTRY_ATTRIBUTE13
, INDUSTRY_ATTRIBUTE14
, INDUSTRY_ATTRIBUTE15
, INDUSTRY_ATTRIBUTE16
, INDUSTRY_ATTRIBUTE17
, INDUSTRY_ATTRIBUTE18
, INDUSTRY_ATTRIBUTE19
, INDUSTRY_ATTRIBUTE20
, INDUSTRY_ATTRIBUTE21
, INDUSTRY_ATTRIBUTE22
, INDUSTRY_ATTRIBUTE23
, INDUSTRY_ATTRIBUTE24
, INDUSTRY_ATTRIBUTE25
, INDUSTRY_ATTRIBUTE26
, INDUSTRY_ATTRIBUTE27
, INDUSTRY_ATTRIBUTE28
, INDUSTRY_ATTRIBUTE29
, INDUSTRY_ATTRIBUTE30
, INDUSTRY_ATTRIBUTE2
, INDUSTRY_ATTRIBUTE3
, INDUSTRY_ATTRIBUTE4
, INDUSTRY_ATTRIBUTE5
, INDUSTRY_ATTRIBUTE6
, INDUSTRY_ATTRIBUTE7
, INDUSTRY_ATTRIBUTE8
, INDUSTRY_ATTRIBUTE9
, INDUSTRY_CONTEXT
, INTMED_SHIP_TO_CONTACT_ID
, INTMED_SHIP_TO_ORG_ID
, INVENTORY_ITEM_ID
, INVOICE_INTERFACE_STATUS_CODE
, INVOICE_TO_CONTACT_ID
, INVOICE_TO_ORG_ID
, INVOICED_QUANTITY
, INVOICING_RULE_ID
, ORDERED_ITEM_ID
, ITEM_IDENTIFIER_TYPE
, ORDERED_ITEM
, ITEM_REVISION
, ITEM_TYPE_CODE
, LAST_ACK_CODE
, LAST_ACK_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LATEST_ACCEPTABLE_DATE
, LINE_CATEGORY_CODE
, LINE_ID
, LINE_NUMBER
, LINE_TYPE_ID
, LINK_TO_LINE_ID
, MODEL_GROUP_NUMBER
-- , MFG_COMPONENT_SEQUENCE_ID
-- , MFG_LEAD_TIME
, OPEN_FLAG
, OPTION_FLAG
, OPTION_NUMBER
, ORDERED_QUANTITY
, ORDERED_QUANTITY2
, ORDER_QUANTITY_UOM
, ORDERED_QUANTITY_UOM2
, ORG_ID
, ORIG_SYS_DOCUMENT_REF
, ORIG_SYS_LINE_REF
, ORIG_SYS_SHIPMENT_REF
, OVER_SHIP_REASON_CODE
, OVER_SHIP_RESOLVED_FLAG
, PAYMENT_TERM_ID
, PLANNING_PRIORITY
, PREFERRED_GRADE
, PRICE_LIST_ID
, PRICE_REQUEST_CODE
, PRICING_ATTRIBUTE1
, PRICING_ATTRIBUTE10
, PRICING_ATTRIBUTE2
, PRICING_ATTRIBUTE3
, PRICING_ATTRIBUTE4
, PRICING_ATTRIBUTE5
, PRICING_ATTRIBUTE6
, PRICING_ATTRIBUTE7
, PRICING_ATTRIBUTE8
, PRICING_ATTRIBUTE9
, PRICING_CONTEXT
, PRICING_DATE
, PRICING_QUANTITY
, PRICING_QUANTITY_UOM
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PROJECT_ID
, PROMISE_DATE
, RE_SOURCE_FLAG
, REFERENCE_CUSTOMER_TRX_LINE_ID
, REFERENCE_HEADER_ID
, REFERENCE_LINE_ID
, REFERENCE_TYPE
, REQUEST_DATE
, REQUEST_ID
, RETURN_ATTRIBUTE1
, RETURN_ATTRIBUTE10
, RETURN_ATTRIBUTE11
, RETURN_ATTRIBUTE12
, RETURN_ATTRIBUTE13
, RETURN_ATTRIBUTE14
, RETURN_ATTRIBUTE15
, RETURN_ATTRIBUTE2
, RETURN_ATTRIBUTE3
, RETURN_ATTRIBUTE4
, RETURN_ATTRIBUTE5
, RETURN_ATTRIBUTE6
, RETURN_ATTRIBUTE7
, RETURN_ATTRIBUTE8
, RETURN_ATTRIBUTE9
, RETURN_CONTEXT
, RETURN_REASON_CODE
, RLA_SCHEDULE_TYPE_CODE
, SALESREP_ID
, SCHEDULE_ARRIVAL_DATE
, SCHEDULE_SHIP_DATE
, SCHEDULE_STATUS_CODE
, SHIPMENT_NUMBER
, SHIPMENT_PRIORITY_CODE
, SHIPPED_QUANTITY
, SHIPPED_QUANTITY2
, SHIPPING_METHOD_CODE
, SHIPPING_QUANTITY
, SHIPPING_QUANTITY2
, SHIPPING_QUANTITY_UOM
, SHIP_FROM_ORG_ID
, SUBINVENTORY
, SHIP_SET_ID
, SHIP_TOLERANCE_ABOVE
, SHIP_TOLERANCE_BELOW
, SHIPPABLE_FLAG
, SHIPPING_INTERFACED_FLAG
, SHIP_TO_CONTACT_ID
, SHIP_TO_ORG_ID
, SHIP_MODEL_COMPLETE_FLAG
, SOLD_TO_ORG_ID
, SOLD_FROM_ORG_ID
, SORT_ORDER
, SOURCE_DOCUMENT_ID
, SOURCE_DOCUMENT_LINE_ID
, SOURCE_DOCUMENT_TYPE_ID
, SOURCE_TYPE_CODE
, SPLIT_FROM_LINE_ID
, LINE_SET_ID
, SPLIT_BY
, MODEL_REMNANT_FLAG
, TASK_ID
, TAX_CODE
, TAX_DATE
, TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE
, TAX_POINT_CODE
, TAX_RATE
, TAX_VALUE
, TOP_MODEL_LINE_ID
, UNIT_LIST_PRICE
, UNIT_LIST_PRICE_PER_PQTY
, UNIT_SELLING_PRICE
, UNIT_SELLING_PRICE_PER_PQTY
, VISIBLE_DEMAND_FLAG
, VEH_CUS_ITEM_CUM_KEY_ID
, SHIPPING_INSTRUCTIONS
, PACKING_INSTRUCTIONS
, SERVICE_TXN_REASON_CODE
, SERVICE_TXN_COMMENTS
, SERVICE_DURATION
, SERVICE_PERIOD
, SERVICE_START_DATE
, SERVICE_END_DATE
, SERVICE_COTERMINATE_FLAG
, UNIT_LIST_PERCENT
, UNIT_SELLING_PERCENT
, UNIT_PERCENT_BASE_PRICE
, SERVICE_NUMBER
, SERVICE_REFERENCE_TYPE_CODE
, SERVICE_REFERENCE_LINE_ID
, SERVICE_REFERENCE_SYSTEM_ID
, TP_CONTEXT
, TP_ATTRIBUTE1
, TP_ATTRIBUTE2
, TP_ATTRIBUTE3
, TP_ATTRIBUTE4
, TP_ATTRIBUTE5
, TP_ATTRIBUTE6
, TP_ATTRIBUTE7
, TP_ATTRIBUTE8
, TP_ATTRIBUTE9
, TP_ATTRIBUTE10
, TP_ATTRIBUTE11
, TP_ATTRIBUTE12
, TP_ATTRIBUTE13
, TP_ATTRIBUTE14
, TP_ATTRIBUTE15
, FLOW_STATUS_CODE
-- , MARKETING_SOURCE_CODE_ID
, CALCULATE_PRICE_FLAG
, COMMITMENT_ID
, ORDER_SOURCE_ID
-- , UPGRADED_FLAG
, ORIGINAL_INVENTORY_ITEM_ID
, ORIGINAL_ITEM_IDENTIFIER_TYPE
, ORIGINAL_ORDERED_ITEM_ID
, ORIGINAL_ORDERED_ITEM
, ITEM_RELATIONSHIP_TYPE
, ITEM_SUBSTITUTION_TYPE_CODE
, LATE_DEMAND_PENALTY_FACTOR
, OVERRIDE_ATP_DATE_CODE
-- , FIRM_DEMAND_FLAG
-- , EARLIEST_SHIP_DATE
, USER_ITEM_DESCRIPTION
, BLANKET_NUMBER
, BLANKET_LINE_NUMBER
, BLANKET_VERSION_NUMBER
-- , UNIT_COST
-- , LOCK_CONTROL
, NVL(OPTION_NUMBER, -1)
, NVL(COMPONENT_NUMBER, -1)
, NVL(SERVICE_NUMBER, -1)
, CHANGE_SEQUENCE
, transaction_phase_code
, source_document_version_number
-- sol_ord_er #16014165
, SERVICE_BILL_PROFILE_ID
, SERVICE_COV_TEMPLATE_ID
, SERVICE_SUBS_TEMPLATE_ID
, SERVICE_BILL_OPTION_CODE
, SERVICE_FIRST_PERIOD_AMOUNT
, SUBSCRIPTION_ENABLE_FLAG
, SERVICE_FIRST_PERIOD_ENDDATE
INTO x_line_rec.ACCOUNTING_RULE_ID
,x_line_rec.ACCOUNTING_RULE_DURATION
,x_line_rec.ACTUAL_ARRIVAL_DATE
,x_line_rec.ACTUAL_SHIPMENT_DATE
,x_line_rec.AGREEMENT_ID
,x_line_rec.ARRIVAL_SET_ID
,x_line_rec.ATO_LINE_ID
,x_line_rec.ATTRIBUTE1
,x_line_rec.ATTRIBUTE10
,x_line_rec.ATTRIBUTE11
,x_line_rec.ATTRIBUTE12
,x_line_rec.ATTRIBUTE13
,x_line_rec.ATTRIBUTE14
,x_line_rec.ATTRIBUTE15
,x_line_rec.ATTRIBUTE16
,x_line_rec.ATTRIBUTE17
,x_line_rec.ATTRIBUTE18
,x_line_rec.ATTRIBUTE19
,x_line_rec.ATTRIBUTE2
,x_line_rec.ATTRIBUTE20
,x_line_rec.ATTRIBUTE3
,x_line_rec.ATTRIBUTE4
,x_line_rec.ATTRIBUTE5
,x_line_rec.ATTRIBUTE6
,x_line_rec.ATTRIBUTE7
,x_line_rec.ATTRIBUTE8
,x_line_rec.ATTRIBUTE9
,x_line_rec.AUTO_SELECTED_QUANTITY
,x_line_rec.AUTHORIZED_TO_SHIP_FLAG
,x_line_rec.BOOKED_FLAG
,x_line_rec.CANCELLED_FLAG
,x_line_rec.CANCELLED_QUANTITY
,x_line_rec.COMPONENT_CODE
,x_line_rec.COMPONENT_NUMBER
,x_line_rec.COMPONENT_SEQUENCE_ID
,x_line_rec.CONFIG_HEADER_ID
,x_line_rec.CONFIG_REV_NBR
,x_line_rec.CONFIG_DISPLAY_SEQUENCE
,x_line_rec.CONFIGURATION_ID
,x_line_rec.CONTEXT
,x_line_rec.CREATED_BY
,x_line_rec.CREATION_DATE
,x_line_rec.CREDIT_INVOICE_LINE_ID
,x_line_rec.CUSTOMER_DOCK_CODE
,x_line_rec.CUSTOMER_JOB
,x_line_rec.CUSTOMER_PRODUCTION_LINE
,x_line_rec.CUST_PRODUCTION_SEQ_NUM
,x_line_rec.CUSTOMER_TRX_LINE_ID
,x_line_rec.CUST_MODEL_SERIAL_NUMBER
,x_line_rec.CUST_PO_NUMBER
,x_line_rec.CUSTOMER_LINE_NUMBER
,x_line_rec.DELIVERY_LEAD_TIME
,x_line_rec.DELIVER_TO_CONTACT_ID
,x_line_rec.DELIVER_TO_ORG_ID
,x_line_rec.DEMAND_BUCKET_TYPE_CODE
,x_line_rec.DEMAND_CLASS_CODE
,x_line_rec.DEP_PLAN_REQUIRED_FLAG
,x_line_rec.EARLIEST_ACCEPTABLE_DATE
,x_line_rec.END_ITEM_UNIT_NUMBER
,x_line_rec.EXPLOSION_DATE
,x_line_rec.FIRST_ACK_CODE
,x_line_rec.FIRST_ACK_DATE
,x_line_rec.FOB_POINT_CODE
,x_line_rec.FREIGHT_CARRIER_CODE
,x_line_rec.FREIGHT_TERMS_CODE
,x_line_rec.FULFILLED_QUANTITY
,x_line_rec.FULFILLED_FLAG
,x_line_rec.FULFILLMENT_METHOD_CODE
,x_line_rec.FULFILLMENT_DATE
,x_line_rec.GLOBAL_ATTRIBUTE1
,x_line_rec.GLOBAL_ATTRIBUTE10
,x_line_rec.GLOBAL_ATTRIBUTE11
,x_line_rec.GLOBAL_ATTRIBUTE12
,x_line_rec.GLOBAL_ATTRIBUTE13
,x_line_rec.GLOBAL_ATTRIBUTE14
,x_line_rec.GLOBAL_ATTRIBUTE15
,x_line_rec.GLOBAL_ATTRIBUTE16
,x_line_rec.GLOBAL_ATTRIBUTE17
,x_line_rec.GLOBAL_ATTRIBUTE18
,x_line_rec.GLOBAL_ATTRIBUTE19
,x_line_rec.GLOBAL_ATTRIBUTE2
,x_line_rec.GLOBAL_ATTRIBUTE20
,x_line_rec.GLOBAL_ATTRIBUTE3
,x_line_rec.GLOBAL_ATTRIBUTE4
,x_line_rec.GLOBAL_ATTRIBUTE5
,x_line_rec.GLOBAL_ATTRIBUTE6
,x_line_rec.GLOBAL_ATTRIBUTE7
,x_line_rec.GLOBAL_ATTRIBUTE8
,x_line_rec.GLOBAL_ATTRIBUTE9
,x_line_rec.GLOBAL_ATTRIBUTE_CATEGORY
,x_line_rec.HEADER_ID
,x_line_rec.INDUSTRY_ATTRIBUTE1
,x_line_rec.INDUSTRY_ATTRIBUTE10
,x_line_rec.INDUSTRY_ATTRIBUTE11
,x_line_rec.INDUSTRY_ATTRIBUTE12
,x_line_rec.INDUSTRY_ATTRIBUTE13
,x_line_rec.INDUSTRY_ATTRIBUTE14
,x_line_rec.INDUSTRY_ATTRIBUTE15
,x_line_rec.INDUSTRY_ATTRIBUTE16
,x_line_rec.INDUSTRY_ATTRIBUTE17
,x_line_rec.INDUSTRY_ATTRIBUTE18
,x_line_rec.INDUSTRY_ATTRIBUTE19
,x_line_rec.INDUSTRY_ATTRIBUTE20
,x_line_rec.INDUSTRY_ATTRIBUTE21
,x_line_rec.INDUSTRY_ATTRIBUTE22
,x_line_rec.INDUSTRY_ATTRIBUTE23
,x_line_rec.INDUSTRY_ATTRIBUTE24
,x_line_rec.INDUSTRY_ATTRIBUTE25
,x_line_rec.INDUSTRY_ATTRIBUTE26
,x_line_rec.INDUSTRY_ATTRIBUTE27
,x_line_rec.INDUSTRY_ATTRIBUTE28
,x_line_rec.INDUSTRY_ATTRIBUTE29
,x_line_rec.INDUSTRY_ATTRIBUTE30
,x_line_rec.INDUSTRY_ATTRIBUTE2
,x_line_rec.INDUSTRY_ATTRIBUTE3
,x_line_rec.INDUSTRY_ATTRIBUTE4
,x_line_rec.INDUSTRY_ATTRIBUTE5
,x_line_rec.INDUSTRY_ATTRIBUTE6
,x_line_rec.INDUSTRY_ATTRIBUTE7
,x_line_rec.INDUSTRY_ATTRIBUTE8
,x_line_rec.INDUSTRY_ATTRIBUTE9
,x_line_rec.INDUSTRY_CONTEXT
,x_line_rec.INTerMED_SHIP_TO_CONTACT_ID
,x_line_rec.INTerMED_SHIP_TO_ORG_ID
,x_line_rec.INVENTORY_ITEM_ID
,x_line_rec.INVOICE_INTERFACE_STATUS_CODE
,x_line_rec.INVOICE_TO_CONTACT_ID
,x_line_rec.INVOICE_TO_ORG_ID
,x_line_rec.INVOICED_QUANTITY
,x_line_rec.INVOICING_RULE_ID
,x_line_rec.ORDERED_ITEM_ID
,x_line_rec.ITEM_IDENTIFIER_TYPE
,x_line_rec.ORDERED_ITEM
,x_line_rec.ITEM_REVISION
,x_line_rec.ITEM_TYPE_CODE
,x_line_rec.LAST_ACK_CODE
,x_line_rec.LAST_ACK_DATE
,x_line_rec.LAST_UPDATED_BY
,x_line_rec.LAST_UPDATE_DATE
,x_line_rec.LAST_UPDATE_LOGIN
,x_line_rec.LATEST_ACCEPTABLE_DATE
,x_line_rec.LINE_CATEGORY_CODE
,x_line_rec.LINE_ID
,x_line_rec.LINE_NUMBER
,x_line_rec.LINE_TYPE_ID
,x_line_rec.LINK_TO_LINE_ID
,x_line_rec.MODEL_GROUP_NUMBER
-- ,x_line_rec.MFG_COMPONENT_SEQUENCE_ID
-- ,x_line_rec.MFG_LEAD_TIME
,x_line_rec.OPEN_FLAG
,x_line_rec.OPTION_FLAG
,x_line_rec.OPTION_NUMBER
,x_line_rec.ORDERED_QUANTITY
,x_line_rec.ORDERED_QUANTITY2
,x_line_rec.ORDER_QUANTITY_UOM
,x_line_rec.ORDERED_QUANTITY_UOM2
,x_line_rec.ORG_ID
,x_line_rec.ORIG_SYS_DOCUMENT_REF
,x_line_rec.ORIG_SYS_LINE_REF
,x_line_rec.ORIG_SYS_SHIPMENT_REF
,x_line_rec.OVER_SHIP_REASON_CODE
,x_line_rec.OVER_SHIP_RESOLVED_FLAG
,x_line_rec.PAYMENT_TERM_ID
,x_line_rec.PLANNING_PRIORITY
,x_line_rec.PREFERRED_GRADE
,x_line_rec.PRICE_LIST_ID
,x_line_rec.PRICE_REQUEST_CODE
,x_line_rec.PRICING_ATTRIBUTE1
,x_line_rec.PRICING_ATTRIBUTE10
,x_line_rec.PRICING_ATTRIBUTE2
,x_line_rec.PRICING_ATTRIBUTE3
,x_line_rec.PRICING_ATTRIBUTE4
,x_line_rec.PRICING_ATTRIBUTE5
,x_line_rec.PRICING_ATTRIBUTE6
,x_line_rec.PRICING_ATTRIBUTE7
,x_line_rec.PRICING_ATTRIBUTE8
,x_line_rec.PRICING_ATTRIBUTE9
,x_line_rec.PRICING_CONTEXT
,x_line_rec.PRICING_DATE
,x_line_rec.PRICING_QUANTITY
,x_line_rec.PRICING_QUANTITY_UOM
,x_line_rec.PROGRAM_APPLICATION_ID
,x_line_rec.PROGRAM_ID
,x_line_rec.PROGRAM_UPDATE_DATE
,x_line_rec.PROJECT_ID
,x_line_rec.PROMISE_DATE
,x_line_rec.RE_SOURCE_FLAG
,x_line_rec.REFERENCE_CUSTOMER_TRX_LINE_ID
,x_line_rec.REFERENCE_HEADER_ID
,x_line_rec.REFERENCE_LINE_ID
,x_line_rec.REFERENCE_TYPE
,x_line_rec.REQUEST_DATE
,x_line_rec.REQUEST_ID
,x_line_rec.RETURN_ATTRIBUTE1
,x_line_rec.RETURN_ATTRIBUTE10
,x_line_rec.RETURN_ATTRIBUTE11
,x_line_rec.RETURN_ATTRIBUTE12
,x_line_rec.RETURN_ATTRIBUTE13
,x_line_rec.RETURN_ATTRIBUTE14
,x_line_rec.RETURN_ATTRIBUTE15
,x_line_rec.RETURN_ATTRIBUTE2
,x_line_rec.RETURN_ATTRIBUTE3
,x_line_rec.RETURN_ATTRIBUTE4
,x_line_rec.RETURN_ATTRIBUTE5
,x_line_rec.RETURN_ATTRIBUTE6
,x_line_rec.RETURN_ATTRIBUTE7
,x_line_rec.RETURN_ATTRIBUTE8
,x_line_rec.RETURN_ATTRIBUTE9
,x_line_rec.RETURN_CONTEXT
,x_line_rec.RETURN_REASON_CODE
,x_line_rec.RLA_SCHEDULE_TYPE_CODE
,x_line_rec.SALESREP_ID
,x_line_rec.SCHEDULE_ARRIVAL_DATE
,x_line_rec.SCHEDULE_SHIP_DATE
,x_line_rec.SCHEDULE_STATUS_CODE
,x_line_rec.SHIPMENT_NUMBER
,x_line_rec.SHIPMENT_PRIORITY_CODE
,x_line_rec.SHIPPED_QUANTITY
,x_line_rec.SHIPPED_QUANTITY2
,x_line_rec.SHIPPING_METHOD_CODE
,x_line_rec.SHIPPING_QUANTITY
,x_line_rec.SHIPPING_QUANTITY2
,x_line_rec.SHIPPING_QUANTITY_UOM
,x_line_rec.SHIP_FROM_ORG_ID
,x_line_rec.SUBINVENTORY
,x_line_rec.SHIP_SET_ID
,x_line_rec.SHIP_TOLERANCE_ABOVE
,x_line_rec.SHIP_TOLERANCE_BELOW
,x_line_rec.SHIPPABLE_FLAG
,x_line_rec.SHIPPING_INTERFACED_FLAG
,x_line_rec.SHIP_TO_CONTACT_ID
,x_line_rec.SHIP_TO_ORG_ID
,x_line_rec.SHIP_MODEL_COMPLETE_FLAG
,x_line_rec.SOLD_TO_ORG_ID
,x_line_rec.SOLD_FROM_ORG_ID
,x_line_rec.SORT_ORDER
,x_line_rec.SOURCE_DOCUMENT_ID
,x_line_rec.SOURCE_DOCUMENT_LINE_ID
,x_line_rec.SOURCE_DOCUMENT_TYPE_ID
,x_line_rec.SOURCE_TYPE_CODE
,x_line_rec.SPLIT_FROM_LINE_ID
,x_line_rec.LINE_SET_ID
,x_line_rec.SPLIT_BY
,x_line_rec.MODEL_REMNANT_FLAG
,x_line_rec.TASK_ID
,x_line_rec.TAX_CODE
,x_line_rec.TAX_DATE
,x_line_rec.TAX_EXEMPT_FLAG
,x_line_rec.TAX_EXEMPT_NUMBER
,x_line_rec.TAX_EXEMPT_REASON_CODE
,x_line_rec.TAX_POINT_CODE
,x_line_rec.TAX_RATE
,x_line_rec.TAX_VALUE
,x_line_rec.TOP_MODEL_LINE_ID
,x_line_rec.UNIT_LIST_PRICE
,x_line_rec.UNIT_LIST_PRICE_PER_PQTY
,x_line_rec.UNIT_SELLING_PRICE
,x_line_rec.UNIT_SELLING_PRICE_PER_PQTY
,x_line_rec.VISIBLE_DEMAND_FLAG
,x_line_rec.VEH_CUS_ITEM_CUM_KEY_ID
,x_line_rec.SHIPPING_INSTRUCTIONS
,x_line_rec.PACKING_INSTRUCTIONS
,x_line_rec.SERVICE_TXN_REASON_CODE
,x_line_rec.SERVICE_TXN_COMMENTS
,x_line_rec.SERVICE_DURATION
,x_line_rec.SERVICE_PERIOD
,x_line_rec.SERVICE_START_DATE
,x_line_rec.SERVICE_END_DATE
,x_line_rec.SERVICE_COTERMINATE_FLAG
,x_line_rec.UNIT_LIST_PERCENT
,x_line_rec.UNIT_SELLING_PERCENT
,x_line_rec.UNIT_PERCENT_BASE_PRICE
,x_line_rec.SERVICE_NUMBER
,x_line_rec.SERVICE_REFERENCE_TYPE_CODE
,x_line_rec.SERVICE_REFERENCE_LINE_ID
,x_line_rec.SERVICE_REFERENCE_SYSTEM_ID
,x_line_rec.TP_CONTEXT
,x_line_rec.TP_ATTRIBUTE1
,x_line_rec.TP_ATTRIBUTE2
,x_line_rec.TP_ATTRIBUTE3
,x_line_rec.TP_ATTRIBUTE4
,x_line_rec.TP_ATTRIBUTE5
,x_line_rec.TP_ATTRIBUTE6
,x_line_rec.TP_ATTRIBUTE7
,x_line_rec.TP_ATTRIBUTE8
,x_line_rec.TP_ATTRIBUTE9
,x_line_rec.TP_ATTRIBUTE10
,x_line_rec.TP_ATTRIBUTE11
,x_line_rec.TP_ATTRIBUTE12
,x_line_rec.TP_ATTRIBUTE13
,x_line_rec.TP_ATTRIBUTE14
,x_line_rec.TP_ATTRIBUTE15
,x_line_rec.FLOW_STATUS_CODE
-- ,x_line_rec.MARKETING_SOURCE_CODE_ID
,x_line_rec.CALCULATE_PRICE_FLAG
,x_line_rec.COMMITMENT_ID
,x_line_rec.ORDER_SOURCE_ID
--,x_line_rec.UPGRADED_FLAG
,x_line_rec.ORIGINAL_INVENTORY_ITEM_ID
,x_line_rec.ORIGINAL_ITEM_IDENTIFIER_TYPE
,x_line_rec.ORIGINAL_ORDERED_ITEM_ID
,x_line_rec.ORIGINAL_ORDERED_ITEM
,x_line_rec.ITEM_RELATIONSHIP_TYPE
,x_line_rec.ITEM_SUBSTITUTION_TYPE_CODE
,x_line_rec.LATE_DEMAND_PENALTY_FACTOR
,x_line_rec.OVERRIDE_ATP_DATE_CODE
-- ,x_line_rec.FIRM_DEMAND_FLAG
-- ,x_line_rec.EARLIEST_SHIP_DATE
,x_line_rec.USER_ITEM_DESCRIPTION
,x_line_rec.BLANKET_NUMBER
,x_line_rec.BLANKET_LINE_NUMBER
,x_line_rec.BLANKET_VERSION_NUMBER
-- ,x_line_rec.UNIT_COST
-- ,x_line_rec.LOCK_CONTROL
,x_line_rec.OPTION_NUMBER
,x_line_rec.COMPONENT_NUMBER
,x_line_rec.SERVICE_NUMBER
,x_line_rec.CHANGE_SEQUENCE
,x_line_rec.transaction_phase_code
,x_line_rec.source_document_version_number
-- sol_ord_er #16014165
,x_line_rec.SERVICE_BILL_PROFILE_ID
,x_line_rec.SERVICE_COV_TEMPLATE_ID
,x_line_rec.SERVICE_SUBS_TEMPLATE_ID
,x_line_rec.SERVICE_BILL_OPTION_CODE
,x_line_rec.SERVICE_FIRST_PERIOD_AMOUNT
,x_line_rec.SUBSCRIPTION_ENABLE_FLAG
,x_line_rec.SERVICE_FIRST_PERIOD_ENDDATE
FROM OE_ORDER_LINES_HISTORY
WHERE LINE_ID = p_line_id
and version_number = p_version
and header_id=p_header_id
AND (PHASE_CHANGE_FLAG = p_phase_change_flag
OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'
AND VERSION_FLAG = 'Y'));
SELECT ACCOUNTING_RULE_ID
, ACCOUNTING_RULE_DURATION
, ACTUAL_ARRIVAL_DATE
, ACTUAL_SHIPMENT_DATE
, AGREEMENT_ID
, ARRIVAL_SET_ID
, ATO_LINE_ID
, ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE2
, ATTRIBUTE20
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, AUTO_SELECTED_QUANTITY
, AUTHORIZED_TO_SHIP_FLAG
, BOOKED_FLAG
, CANCELLED_FLAG
, CANCELLED_QUANTITY
, COMPONENT_CODE
, COMPONENT_NUMBER
, COMPONENT_SEQUENCE_ID
, CONFIG_HEADER_ID
, CONFIG_REV_NBR
, CONFIG_DISPLAY_SEQUENCE
, CONFIGURATION_ID
, CONTEXT
, CREATED_BY
, CREATION_DATE
, CREDIT_INVOICE_LINE_ID
, CUSTOMER_DOCK_CODE
, CUSTOMER_JOB
, CUSTOMER_PRODUCTION_LINE
, CUST_PRODUCTION_SEQ_NUM
, CUSTOMER_TRX_LINE_ID
, CUST_MODEL_SERIAL_NUMBER
, CUST_PO_NUMBER
, CUSTOMER_LINE_NUMBER
, DELIVERY_LEAD_TIME
, DELIVER_TO_CONTACT_ID
, DELIVER_TO_ORG_ID
, DEMAND_BUCKET_TYPE_CODE
, DEMAND_CLASS_CODE
, DEP_PLAN_REQUIRED_FLAG
, EARLIEST_ACCEPTABLE_DATE
, END_ITEM_UNIT_NUMBER
, EXPLOSION_DATE
, FIRST_ACK_CODE
, FIRST_ACK_DATE
, FOB_POINT_CODE
, FREIGHT_CARRIER_CODE
, FREIGHT_TERMS_CODE
, FULFILLED_QUANTITY
, FULFILLED_FLAG
, FULFILLMENT_METHOD_CODE
, FULFILLMENT_DATE
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE_CATEGORY
, HEADER_ID
, INDUSTRY_ATTRIBUTE1
, INDUSTRY_ATTRIBUTE10
, INDUSTRY_ATTRIBUTE11
, INDUSTRY_ATTRIBUTE12
, INDUSTRY_ATTRIBUTE13
, INDUSTRY_ATTRIBUTE14
, INDUSTRY_ATTRIBUTE15
, INDUSTRY_ATTRIBUTE16
, INDUSTRY_ATTRIBUTE17
, INDUSTRY_ATTRIBUTE18
, INDUSTRY_ATTRIBUTE19
, INDUSTRY_ATTRIBUTE20
, INDUSTRY_ATTRIBUTE21
, INDUSTRY_ATTRIBUTE22
, INDUSTRY_ATTRIBUTE23
, INDUSTRY_ATTRIBUTE24
, INDUSTRY_ATTRIBUTE25
, INDUSTRY_ATTRIBUTE26
, INDUSTRY_ATTRIBUTE27
, INDUSTRY_ATTRIBUTE28
, INDUSTRY_ATTRIBUTE29
, INDUSTRY_ATTRIBUTE30
, INDUSTRY_ATTRIBUTE2
, INDUSTRY_ATTRIBUTE3
, INDUSTRY_ATTRIBUTE4
, INDUSTRY_ATTRIBUTE5
, INDUSTRY_ATTRIBUTE6
, INDUSTRY_ATTRIBUTE7
, INDUSTRY_ATTRIBUTE8
, INDUSTRY_ATTRIBUTE9
, INDUSTRY_CONTEXT
, INTMED_SHIP_TO_CONTACT_ID
, INTMED_SHIP_TO_ORG_ID
, INVENTORY_ITEM_ID
, INVOICE_INTERFACE_STATUS_CODE
, INVOICE_TO_CONTACT_ID
, INVOICE_TO_ORG_ID
, INVOICED_QUANTITY
, INVOICING_RULE_ID
, ORDERED_ITEM_ID
, ITEM_IDENTIFIER_TYPE
, ORDERED_ITEM
, ITEM_REVISION
, ITEM_TYPE_CODE
, LAST_ACK_CODE
, LAST_ACK_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LATEST_ACCEPTABLE_DATE
, LINE_CATEGORY_CODE
, LINE_ID
, LINE_NUMBER
, LINE_TYPE_ID
, LINK_TO_LINE_ID
, MODEL_GROUP_NUMBER
-- , MFG_COMPONENT_SEQUENCE_ID
-- , MFG_LEAD_TIME
, OPEN_FLAG
, OPTION_FLAG
, OPTION_NUMBER
, ORDERED_QUANTITY
, ORDERED_QUANTITY2
, ORDER_QUANTITY_UOM
, ORDERED_QUANTITY_UOM2
, ORG_ID
, ORIG_SYS_DOCUMENT_REF
, ORIG_SYS_LINE_REF
, ORIG_SYS_SHIPMENT_REF
, OVER_SHIP_REASON_CODE
, OVER_SHIP_RESOLVED_FLAG
, PAYMENT_TERM_ID
, PLANNING_PRIORITY
, PREFERRED_GRADE
, PRICE_LIST_ID
, PRICE_REQUEST_CODE
, PRICING_ATTRIBUTE1
, PRICING_ATTRIBUTE10
, PRICING_ATTRIBUTE2
, PRICING_ATTRIBUTE3
, PRICING_ATTRIBUTE4
, PRICING_ATTRIBUTE5
, PRICING_ATTRIBUTE6
, PRICING_ATTRIBUTE7
, PRICING_ATTRIBUTE8
, PRICING_ATTRIBUTE9
, PRICING_CONTEXT
, PRICING_DATE
, PRICING_QUANTITY
, PRICING_QUANTITY_UOM
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PROJECT_ID
, PROMISE_DATE
, RE_SOURCE_FLAG
, REFERENCE_CUSTOMER_TRX_LINE_ID
, REFERENCE_HEADER_ID
, REFERENCE_LINE_ID
, REFERENCE_TYPE
, REQUEST_DATE
, REQUEST_ID
, RETURN_ATTRIBUTE1
, RETURN_ATTRIBUTE10
, RETURN_ATTRIBUTE11
, RETURN_ATTRIBUTE12
, RETURN_ATTRIBUTE13
, RETURN_ATTRIBUTE14
, RETURN_ATTRIBUTE15
, RETURN_ATTRIBUTE2
, RETURN_ATTRIBUTE3
, RETURN_ATTRIBUTE4
, RETURN_ATTRIBUTE5
, RETURN_ATTRIBUTE6
, RETURN_ATTRIBUTE7
, RETURN_ATTRIBUTE8
, RETURN_ATTRIBUTE9
, RETURN_CONTEXT
, RETURN_REASON_CODE
, RLA_SCHEDULE_TYPE_CODE
, SALESREP_ID
, SCHEDULE_ARRIVAL_DATE
, SCHEDULE_SHIP_DATE
, SCHEDULE_STATUS_CODE
, SHIPMENT_NUMBER
, SHIPMENT_PRIORITY_CODE
, SHIPPED_QUANTITY
, SHIPPED_QUANTITY2
, SHIPPING_METHOD_CODE
, SHIPPING_QUANTITY
, SHIPPING_QUANTITY2
, SHIPPING_QUANTITY_UOM
, SHIP_FROM_ORG_ID
, SUBINVENTORY
, SHIP_SET_ID
, SHIP_TOLERANCE_ABOVE
, SHIP_TOLERANCE_BELOW
, SHIPPABLE_FLAG
, SHIPPING_INTERFACED_FLAG
, SHIP_TO_CONTACT_ID
, SHIP_TO_ORG_ID
, SHIP_MODEL_COMPLETE_FLAG
, SOLD_TO_ORG_ID
, SOLD_FROM_ORG_ID
, SORT_ORDER
, SOURCE_DOCUMENT_ID
, SOURCE_DOCUMENT_LINE_ID
, SOURCE_DOCUMENT_TYPE_ID
, SOURCE_TYPE_CODE
, SPLIT_FROM_LINE_ID
, LINE_SET_ID
, SPLIT_BY
, MODEL_REMNANT_FLAG
, TASK_ID
, TAX_CODE
, TAX_DATE
, TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE
, TAX_POINT_CODE
, TAX_RATE
, TAX_VALUE
, TOP_MODEL_LINE_ID
, UNIT_LIST_PRICE
, UNIT_LIST_PRICE_PER_PQTY
, UNIT_SELLING_PRICE
, UNIT_SELLING_PRICE_PER_PQTY
, VISIBLE_DEMAND_FLAG
, VEH_CUS_ITEM_CUM_KEY_ID
, SHIPPING_INSTRUCTIONS
, PACKING_INSTRUCTIONS
, SERVICE_TXN_REASON_CODE
, SERVICE_TXN_COMMENTS
, SERVICE_DURATION
, SERVICE_PERIOD
, SERVICE_START_DATE
, SERVICE_END_DATE
, SERVICE_COTERMINATE_FLAG
, UNIT_LIST_PERCENT
, UNIT_SELLING_PERCENT
, UNIT_PERCENT_BASE_PRICE
, SERVICE_NUMBER
, SERVICE_REFERENCE_TYPE_CODE
, SERVICE_REFERENCE_LINE_ID
, SERVICE_REFERENCE_SYSTEM_ID
, TP_CONTEXT
, TP_ATTRIBUTE1
, TP_ATTRIBUTE2
, TP_ATTRIBUTE3
, TP_ATTRIBUTE4
, TP_ATTRIBUTE5
, TP_ATTRIBUTE6
, TP_ATTRIBUTE7
, TP_ATTRIBUTE8
, TP_ATTRIBUTE9
, TP_ATTRIBUTE10
, TP_ATTRIBUTE11
, TP_ATTRIBUTE12
, TP_ATTRIBUTE13
, TP_ATTRIBUTE14
, TP_ATTRIBUTE15
, FLOW_STATUS_CODE
-- , MARKETING_SOURCE_CODE_ID
, CALCULATE_PRICE_FLAG
, COMMITMENT_ID
, ORDER_SOURCE_ID
-- , UPGRADED_FLAG
, ORIGINAL_INVENTORY_ITEM_ID
, ORIGINAL_ITEM_IDENTIFIER_TYPE
, ORIGINAL_ORDERED_ITEM_ID
, ORIGINAL_ORDERED_ITEM
, ITEM_RELATIONSHIP_TYPE
, ITEM_SUBSTITUTION_TYPE_CODE
, LATE_DEMAND_PENALTY_FACTOR
, OVERRIDE_ATP_DATE_CODE
-- , FIRM_DEMAND_FLAG
-- , EARLIEST_SHIP_DATE
, USER_ITEM_DESCRIPTION
, BLANKET_NUMBER
, BLANKET_LINE_NUMBER
, BLANKET_VERSION_NUMBER
-- , UNIT_COST
-- , LOCK_CONTROL
, NVL(OPTION_NUMBER, -1)
, NVL(COMPONENT_NUMBER, -1)
, NVL(SERVICE_NUMBER, -1)
, CHANGE_SEQUENCE
, transaction_phase_code
, source_document_version_number
-- sol_ord_er #16014165
, SERVICE_BILL_PROFILE_ID
, SERVICE_COV_TEMPLATE_ID
, SERVICE_SUBS_TEMPLATE_ID
, SERVICE_BILL_OPTION_CODE
, SERVICE_FIRST_PERIOD_AMOUNT
, SUBSCRIPTION_ENABLE_FLAG
, SERVICE_FIRST_PERIOD_ENDDATE
INTO x_line_rec.ACCOUNTING_RULE_ID
,x_line_rec.ACCOUNTING_RULE_DURATION
,x_line_rec.ACTUAL_ARRIVAL_DATE
,x_line_rec.ACTUAL_SHIPMENT_DATE
,x_line_rec.AGREEMENT_ID
,x_line_rec.ARRIVAL_SET_ID
,x_line_rec.ATO_LINE_ID
,x_line_rec.ATTRIBUTE1
,x_line_rec.ATTRIBUTE10
,x_line_rec.ATTRIBUTE11
,x_line_rec.ATTRIBUTE12
,x_line_rec.ATTRIBUTE13
,x_line_rec.ATTRIBUTE14
,x_line_rec.ATTRIBUTE15
,x_line_rec.ATTRIBUTE16
,x_line_rec.ATTRIBUTE17
,x_line_rec.ATTRIBUTE18
,x_line_rec.ATTRIBUTE19
,x_line_rec.ATTRIBUTE2
,x_line_rec.ATTRIBUTE20
,x_line_rec.ATTRIBUTE3
,x_line_rec.ATTRIBUTE4
,x_line_rec.ATTRIBUTE5
,x_line_rec.ATTRIBUTE6
,x_line_rec.ATTRIBUTE7
,x_line_rec.ATTRIBUTE8
,x_line_rec.ATTRIBUTE9
,x_line_rec.AUTO_SELECTED_QUANTITY
,x_line_rec.AUTHORIZED_TO_SHIP_FLAG
,x_line_rec.BOOKED_FLAG
,x_line_rec.CANCELLED_FLAG
,x_line_rec.CANCELLED_QUANTITY
,x_line_rec.COMPONENT_CODE
,x_line_rec.COMPONENT_NUMBER
,x_line_rec.COMPONENT_SEQUENCE_ID
,x_line_rec.CONFIG_HEADER_ID
,x_line_rec.CONFIG_REV_NBR
,x_line_rec.CONFIG_DISPLAY_SEQUENCE
,x_line_rec.CONFIGURATION_ID
,x_line_rec.CONTEXT
,x_line_rec.CREATED_BY
,x_line_rec.CREATION_DATE
,x_line_rec.CREDIT_INVOICE_LINE_ID
,x_line_rec.CUSTOMER_DOCK_CODE
,x_line_rec.CUSTOMER_JOB
,x_line_rec.CUSTOMER_PRODUCTION_LINE
,x_line_rec.CUST_PRODUCTION_SEQ_NUM
,x_line_rec.CUSTOMER_TRX_LINE_ID
,x_line_rec.CUST_MODEL_SERIAL_NUMBER
,x_line_rec.CUST_PO_NUMBER
,x_line_rec.CUSTOMER_LINE_NUMBER
,x_line_rec.DELIVERY_LEAD_TIME
,x_line_rec.DELIVER_TO_CONTACT_ID
,x_line_rec.DELIVER_TO_ORG_ID
,x_line_rec.DEMAND_BUCKET_TYPE_CODE
,x_line_rec.DEMAND_CLASS_CODE
,x_line_rec.DEP_PLAN_REQUIRED_FLAG
,x_line_rec.EARLIEST_ACCEPTABLE_DATE
,x_line_rec.END_ITEM_UNIT_NUMBER
,x_line_rec.EXPLOSION_DATE
,x_line_rec.FIRST_ACK_CODE
,x_line_rec.FIRST_ACK_DATE
,x_line_rec.FOB_POINT_CODE
,x_line_rec.FREIGHT_CARRIER_CODE
,x_line_rec.FREIGHT_TERMS_CODE
,x_line_rec.FULFILLED_QUANTITY
,x_line_rec.FULFILLED_FLAG
,x_line_rec.FULFILLMENT_METHOD_CODE
,x_line_rec.FULFILLMENT_DATE
,x_line_rec.GLOBAL_ATTRIBUTE1
,x_line_rec.GLOBAL_ATTRIBUTE10
,x_line_rec.GLOBAL_ATTRIBUTE11
,x_line_rec.GLOBAL_ATTRIBUTE12
,x_line_rec.GLOBAL_ATTRIBUTE13
,x_line_rec.GLOBAL_ATTRIBUTE14
,x_line_rec.GLOBAL_ATTRIBUTE15
,x_line_rec.GLOBAL_ATTRIBUTE16
,x_line_rec.GLOBAL_ATTRIBUTE17
,x_line_rec.GLOBAL_ATTRIBUTE18
,x_line_rec.GLOBAL_ATTRIBUTE19
,x_line_rec.GLOBAL_ATTRIBUTE2
,x_line_rec.GLOBAL_ATTRIBUTE20
,x_line_rec.GLOBAL_ATTRIBUTE3
,x_line_rec.GLOBAL_ATTRIBUTE4
,x_line_rec.GLOBAL_ATTRIBUTE5
,x_line_rec.GLOBAL_ATTRIBUTE6
,x_line_rec.GLOBAL_ATTRIBUTE7
,x_line_rec.GLOBAL_ATTRIBUTE8
,x_line_rec.GLOBAL_ATTRIBUTE9
,x_line_rec.GLOBAL_ATTRIBUTE_CATEGORY
,x_line_rec.HEADER_ID
,x_line_rec.INDUSTRY_ATTRIBUTE1
,x_line_rec.INDUSTRY_ATTRIBUTE10
,x_line_rec.INDUSTRY_ATTRIBUTE11
,x_line_rec.INDUSTRY_ATTRIBUTE12
,x_line_rec.INDUSTRY_ATTRIBUTE13
,x_line_rec.INDUSTRY_ATTRIBUTE14
,x_line_rec.INDUSTRY_ATTRIBUTE15
,x_line_rec.INDUSTRY_ATTRIBUTE16
,x_line_rec.INDUSTRY_ATTRIBUTE17
,x_line_rec.INDUSTRY_ATTRIBUTE18
,x_line_rec.INDUSTRY_ATTRIBUTE19
,x_line_rec.INDUSTRY_ATTRIBUTE20
,x_line_rec.INDUSTRY_ATTRIBUTE21
,x_line_rec.INDUSTRY_ATTRIBUTE22
,x_line_rec.INDUSTRY_ATTRIBUTE23
,x_line_rec.INDUSTRY_ATTRIBUTE24
,x_line_rec.INDUSTRY_ATTRIBUTE25
,x_line_rec.INDUSTRY_ATTRIBUTE26
,x_line_rec.INDUSTRY_ATTRIBUTE27
,x_line_rec.INDUSTRY_ATTRIBUTE28
,x_line_rec.INDUSTRY_ATTRIBUTE29
,x_line_rec.INDUSTRY_ATTRIBUTE30
,x_line_rec.INDUSTRY_ATTRIBUTE2
,x_line_rec.INDUSTRY_ATTRIBUTE3
,x_line_rec.INDUSTRY_ATTRIBUTE4
,x_line_rec.INDUSTRY_ATTRIBUTE5
,x_line_rec.INDUSTRY_ATTRIBUTE6
,x_line_rec.INDUSTRY_ATTRIBUTE7
,x_line_rec.INDUSTRY_ATTRIBUTE8
,x_line_rec.INDUSTRY_ATTRIBUTE9
,x_line_rec.INDUSTRY_CONTEXT
,x_line_rec.INTerMED_SHIP_TO_CONTACT_ID
,x_line_rec.INTerMED_SHIP_TO_ORG_ID
,x_line_rec.INVENTORY_ITEM_ID
,x_line_rec.INVOICE_INTERFACE_STATUS_CODE
,x_line_rec.INVOICE_TO_CONTACT_ID
,x_line_rec.INVOICE_TO_ORG_ID
,x_line_rec.INVOICED_QUANTITY
,x_line_rec.INVOICING_RULE_ID
,x_line_rec.ORDERED_ITEM_ID
,x_line_rec.ITEM_IDENTIFIER_TYPE
,x_line_rec.ORDERED_ITEM
,x_line_rec.ITEM_REVISION
,x_line_rec.ITEM_TYPE_CODE
,x_line_rec.LAST_ACK_CODE
,x_line_rec.LAST_ACK_DATE
,x_line_rec.LAST_UPDATED_BY
,x_line_rec.LAST_UPDATE_DATE
,x_line_rec.LAST_UPDATE_LOGIN
,x_line_rec.LATEST_ACCEPTABLE_DATE
,x_line_rec.LINE_CATEGORY_CODE
,x_line_rec.LINE_ID
,x_line_rec.LINE_NUMBER
,x_line_rec.LINE_TYPE_ID
,x_line_rec.LINK_TO_LINE_ID
,x_line_rec.MODEL_GROUP_NUMBER
-- ,x_line_rec.MFG_COMPONENT_SEQUENCE_ID
-- ,x_line_rec.MFG_LEAD_TIME
,x_line_rec.OPEN_FLAG
,x_line_rec.OPTION_FLAG
,x_line_rec.OPTION_NUMBER
,x_line_rec.ORDERED_QUANTITY
,x_line_rec.ORDERED_QUANTITY2
,x_line_rec.ORDER_QUANTITY_UOM
,x_line_rec.ORDERED_QUANTITY_UOM2
,x_line_rec.ORG_ID
,x_line_rec.ORIG_SYS_DOCUMENT_REF
,x_line_rec.ORIG_SYS_LINE_REF
,x_line_rec.ORIG_SYS_SHIPMENT_REF
,x_line_rec.OVER_SHIP_REASON_CODE
,x_line_rec.OVER_SHIP_RESOLVED_FLAG
,x_line_rec.PAYMENT_TERM_ID
,x_line_rec.PLANNING_PRIORITY
,x_line_rec.PREFERRED_GRADE
,x_line_rec.PRICE_LIST_ID
,x_line_rec.PRICE_REQUEST_CODE
,x_line_rec.PRICING_ATTRIBUTE1
,x_line_rec.PRICING_ATTRIBUTE10
,x_line_rec.PRICING_ATTRIBUTE2
,x_line_rec.PRICING_ATTRIBUTE3
,x_line_rec.PRICING_ATTRIBUTE4
,x_line_rec.PRICING_ATTRIBUTE5
,x_line_rec.PRICING_ATTRIBUTE6
,x_line_rec.PRICING_ATTRIBUTE7
,x_line_rec.PRICING_ATTRIBUTE8
,x_line_rec.PRICING_ATTRIBUTE9
,x_line_rec.PRICING_CONTEXT
,x_line_rec.PRICING_DATE
,x_line_rec.PRICING_QUANTITY
,x_line_rec.PRICING_QUANTITY_UOM
,x_line_rec.PROGRAM_APPLICATION_ID
,x_line_rec.PROGRAM_ID
,x_line_rec.PROGRAM_UPDATE_DATE
,x_line_rec.PROJECT_ID
,x_line_rec.PROMISE_DATE
,x_line_rec.RE_SOURCE_FLAG
,x_line_rec.REFERENCE_CUSTOMER_TRX_LINE_ID
,x_line_rec.REFERENCE_HEADER_ID
,x_line_rec.REFERENCE_LINE_ID
,x_line_rec.REFERENCE_TYPE
,x_line_rec.REQUEST_DATE
,x_line_rec.REQUEST_ID
,x_line_rec.RETURN_ATTRIBUTE1
,x_line_rec.RETURN_ATTRIBUTE10
,x_line_rec.RETURN_ATTRIBUTE11
,x_line_rec.RETURN_ATTRIBUTE12
,x_line_rec.RETURN_ATTRIBUTE13
,x_line_rec.RETURN_ATTRIBUTE14
,x_line_rec.RETURN_ATTRIBUTE15
,x_line_rec.RETURN_ATTRIBUTE2
,x_line_rec.RETURN_ATTRIBUTE3
,x_line_rec.RETURN_ATTRIBUTE4
,x_line_rec.RETURN_ATTRIBUTE5
,x_line_rec.RETURN_ATTRIBUTE6
,x_line_rec.RETURN_ATTRIBUTE7
,x_line_rec.RETURN_ATTRIBUTE8
,x_line_rec.RETURN_ATTRIBUTE9
,x_line_rec.RETURN_CONTEXT
,x_line_rec.RETURN_REASON_CODE
,x_line_rec.RLA_SCHEDULE_TYPE_CODE
,x_line_rec.SALESREP_ID
,x_line_rec.SCHEDULE_ARRIVAL_DATE
,x_line_rec.SCHEDULE_SHIP_DATE
,x_line_rec.SCHEDULE_STATUS_CODE
,x_line_rec.SHIPMENT_NUMBER
,x_line_rec.SHIPMENT_PRIORITY_CODE
,x_line_rec.SHIPPED_QUANTITY
,x_line_rec.SHIPPED_QUANTITY2
,x_line_rec.SHIPPING_METHOD_CODE
,x_line_rec.SHIPPING_QUANTITY
,x_line_rec.SHIPPING_QUANTITY2
,x_line_rec.SHIPPING_QUANTITY_UOM
,x_line_rec.SHIP_FROM_ORG_ID
,x_line_rec.SUBINVENTORY
,x_line_rec.SHIP_SET_ID
,x_line_rec.SHIP_TOLERANCE_ABOVE
,x_line_rec.SHIP_TOLERANCE_BELOW
,x_line_rec.SHIPPABLE_FLAG
,x_line_rec.SHIPPING_INTERFACED_FLAG
,x_line_rec.SHIP_TO_CONTACT_ID
,x_line_rec.SHIP_TO_ORG_ID
,x_line_rec.SHIP_MODEL_COMPLETE_FLAG
,x_line_rec.SOLD_TO_ORG_ID
,x_line_rec.SOLD_FROM_ORG_ID
,x_line_rec.SORT_ORDER
,x_line_rec.SOURCE_DOCUMENT_ID
,x_line_rec.SOURCE_DOCUMENT_LINE_ID
,x_line_rec.SOURCE_DOCUMENT_TYPE_ID
,x_line_rec.SOURCE_TYPE_CODE
,x_line_rec.SPLIT_FROM_LINE_ID
,x_line_rec.LINE_SET_ID
,x_line_rec.SPLIT_BY
,x_line_rec.MODEL_REMNANT_FLAG
,x_line_rec.TASK_ID
,x_line_rec.TAX_CODE
,x_line_rec.TAX_DATE
,x_line_rec.TAX_EXEMPT_FLAG
,x_line_rec.TAX_EXEMPT_NUMBER
,x_line_rec.TAX_EXEMPT_REASON_CODE
,x_line_rec.TAX_POINT_CODE
,x_line_rec.TAX_RATE
,x_line_rec.TAX_VALUE
,x_line_rec.TOP_MODEL_LINE_ID
,x_line_rec.UNIT_LIST_PRICE
,x_line_rec.UNIT_LIST_PRICE_PER_PQTY
,x_line_rec.UNIT_SELLING_PRICE
,x_line_rec.UNIT_SELLING_PRICE_PER_PQTY
,x_line_rec.VISIBLE_DEMAND_FLAG
,x_line_rec.VEH_CUS_ITEM_CUM_KEY_ID
,x_line_rec.SHIPPING_INSTRUCTIONS
,x_line_rec.PACKING_INSTRUCTIONS
,x_line_rec.SERVICE_TXN_REASON_CODE
,x_line_rec.SERVICE_TXN_COMMENTS
,x_line_rec.SERVICE_DURATION
,x_line_rec.SERVICE_PERIOD
,x_line_rec.SERVICE_START_DATE
,x_line_rec.SERVICE_END_DATE
,x_line_rec.SERVICE_COTERMINATE_FLAG
,x_line_rec.UNIT_LIST_PERCENT
,x_line_rec.UNIT_SELLING_PERCENT
,x_line_rec.UNIT_PERCENT_BASE_PRICE
,x_line_rec.SERVICE_NUMBER
,x_line_rec.SERVICE_REFERENCE_TYPE_CODE
,x_line_rec.SERVICE_REFERENCE_LINE_ID
,x_line_rec.SERVICE_REFERENCE_SYSTEM_ID
,x_line_rec.TP_CONTEXT
,x_line_rec.TP_ATTRIBUTE1
,x_line_rec.TP_ATTRIBUTE2
,x_line_rec.TP_ATTRIBUTE3
,x_line_rec.TP_ATTRIBUTE4
,x_line_rec.TP_ATTRIBUTE5
,x_line_rec.TP_ATTRIBUTE6
,x_line_rec.TP_ATTRIBUTE7
,x_line_rec.TP_ATTRIBUTE8
,x_line_rec.TP_ATTRIBUTE9
,x_line_rec.TP_ATTRIBUTE10
,x_line_rec.TP_ATTRIBUTE11
,x_line_rec.TP_ATTRIBUTE12
,x_line_rec.TP_ATTRIBUTE13
,x_line_rec.TP_ATTRIBUTE14
,x_line_rec.TP_ATTRIBUTE15
,x_line_rec.FLOW_STATUS_CODE
-- ,x_line_rec.MARKETING_SOURCE_CODE_ID
,x_line_rec.CALCULATE_PRICE_FLAG
,x_line_rec.COMMITMENT_ID
,x_line_rec.ORDER_SOURCE_ID
--,x_line_rec.UPGRADED_FLAG
,x_line_rec.ORIGINAL_INVENTORY_ITEM_ID
,x_line_rec.ORIGINAL_ITEM_IDENTIFIER_TYPE
,x_line_rec.ORIGINAL_ORDERED_ITEM_ID
,x_line_rec.ORIGINAL_ORDERED_ITEM
,x_line_rec.ITEM_RELATIONSHIP_TYPE
,x_line_rec.ITEM_SUBSTITUTION_TYPE_CODE
,x_line_rec.LATE_DEMAND_PENALTY_FACTOR
,x_line_rec.OVERRIDE_ATP_DATE_CODE
-- ,x_line_rec.FIRM_DEMAND_FLAG
-- ,x_line_rec.EARLIEST_SHIP_DATE
,x_line_rec.USER_ITEM_DESCRIPTION
,x_line_rec.BLANKET_NUMBER
,x_line_rec.BLANKET_LINE_NUMBER
,x_line_rec.BLANKET_VERSION_NUMBER
-- ,x_line_rec.UNIT_COST
-- ,x_line_rec.LOCK_CONTROL
,x_line_rec.OPTION_NUMBER
,x_line_rec.COMPONENT_NUMBER
,x_line_rec.SERVICE_NUMBER
,x_line_rec.CHANGE_SEQUENCE
,x_line_rec.transaction_phase_code
,x_line_rec.source_document_version_number
-- sol_ord_er #16014165
,x_line_rec.SERVICE_BILL_PROFILE_ID
,x_line_rec.SERVICE_COV_TEMPLATE_ID
,x_line_rec.SERVICE_SUBS_TEMPLATE_ID
,x_line_rec.SERVICE_BILL_OPTION_CODE
,x_line_rec.SERVICE_FIRST_PERIOD_AMOUNT
,x_line_rec.SUBSCRIPTION_ENABLE_FLAG
,x_line_rec.SERVICE_FIRST_PERIOD_ENDDATE
FROM OE_ORDER_LINES
WHERE LINE_ID = p_line_id
-- and version_number = p_version
and header_id=p_header_id;
oe_debug_pub.add(' before finding deleted lines');
x_line_changed_attr_tbl(ind).current_value := 'DELETE';
x_line_changed_attr_tbl(ind).next_value := 'DELETE';
/* START AUTO_SELECTED_QUANTITY*/
prior_exists := 'N';
p_curr_rec.AUTO_SELECTED_QUANTITY,
p_prior_rec.AUTO_SELECTED_QUANTITY) THEN
null;
x_line_changed_attr_tbl(ind).attribute_name := 'AUTO_SELECTED_QUANTITY';
x_line_changed_attr_tbl(ind).current_value := p_curr_rec.AUTO_SELECTED_QUANTITY;
x_line_changed_attr_tbl(ind).prior_value := p_prior_rec.AUTO_SELECTED_QUANTITY;
p_curr_rec.AUTO_SELECTED_QUANTITY,
p_next_rec.AUTO_SELECTED_QUANTITY) THEN
IF prior_exists = 'Y' THEN
x_line_changed_attr_tbl(ind).next_value := p_curr_rec.AUTO_SELECTED_QUANTITY;
x_line_changed_attr_tbl(ind).attribute_name := 'AUTO_SELECTED_QUANTITY';
x_line_changed_attr_tbl(ind).prior_value := p_prior_rec.AUTO_SELECTED_QUANTITY;
x_line_changed_attr_tbl(ind).current_value := p_curr_rec.AUTO_SELECTED_QUANTITY;
x_line_changed_attr_tbl(ind).next_value := p_next_rec.AUTO_SELECTED_QUANTITY;
/* END AUTO_SELECTED_QUANTITY*/
/****************************/
/****************************/
/* START AUTHORIZED_TO_SHIP_FLAG*/
prior_exists := 'N';
select
DECODE(x_deliver_to_location, NULL, NULL,x_deliver_to_location|| ', ') ||
DECODE(x_deliver_to_address1, NULL, NULL,x_deliver_to_address1 || ', ') ||
DECODE(x_deliver_to_address2, NULL, NULL,x_deliver_to_address3 || ', ') ||
DECODE(x_deliver_to_address3, NULL, NULL,x_deliver_to_address3 || ', ') ||
DECODE(x_deliver_to_address4, NULL, NULL,x_deliver_to_address4 || ', ') ||
DECODE(x_deliver_to_city, NULL, NULL,x_deliver_to_city || ', ') ||
DECODE(x_deliver_to_state, NULL, NULL,x_deliver_to_state || ', ') ||
DECODE(x_deliver_to_postal_code, NULL, NULL,x_deliver_to_postal_code || ', ') ||
DECODE(x_deliver_to_country, NULL,x_deliver_to_country)
into x_current_deliver_to_address from dual;
select
DECODE(x_deliver_to_location, NULL, NULL,x_deliver_to_location|| ', ') ||
DECODE(x_deliver_to_address1, NULL, NULL,x_deliver_to_address1 || ', ') ||
DECODE(x_deliver_to_address2, NULL, NULL,x_deliver_to_address3 || ', ') ||
DECODE(x_deliver_to_address3, NULL, NULL,x_deliver_to_address3 || ', ') ||
DECODE(x_deliver_to_address4, NULL, NULL,x_deliver_to_address4 || ', ') ||
DECODE(x_deliver_to_city, NULL, NULL,x_deliver_to_city || ', ') ||
DECODE(x_deliver_to_state, NULL, NULL,x_deliver_to_state || ', ') ||
DECODE(x_deliver_to_postal_code, NULL, NULL,x_deliver_to_postal_code || ', ') ||
DECODE(x_deliver_to_country, NULL,x_deliver_to_country)
into x_prior_deliver_to_address from dual;
select
DECODE(x_deliver_to_location, NULL, NULL,x_deliver_to_location|| ', ') ||
DECODE(x_deliver_to_address1, NULL, NULL,x_deliver_to_address1 || ', ') ||
DECODE(x_deliver_to_address2, NULL, NULL,x_deliver_to_address3 || ', ') ||
DECODE(x_deliver_to_address3, NULL, NULL,x_deliver_to_address3 || ', ') ||
DECODE(x_deliver_to_address4, NULL, NULL,x_deliver_to_address4 || ', ') ||
DECODE(x_deliver_to_city, NULL, NULL,x_deliver_to_city || ', ') ||
DECODE(x_deliver_to_state, NULL, NULL,x_deliver_to_state || ', ') ||
DECODE(x_deliver_to_postal_code, NULL, NULL,x_deliver_to_postal_code || ', ') ||
DECODE(x_deliver_to_country, NULL,NULL,x_deliver_to_country)
into x_prior_deliver_to_address from dual;
select
DECODE(x_deliver_to_location, NULL, NULL,x_deliver_to_location|| ', ') ||
DECODE(x_deliver_to_address1, NULL, NULL,x_deliver_to_address1 || ', ') ||
DECODE(x_deliver_to_address2, NULL, NULL,x_deliver_to_address3 || ', ') ||
DECODE(x_deliver_to_address3, NULL, NULL,x_deliver_to_address3 || ', ') ||
DECODE(x_deliver_to_address4, NULL, NULL,x_deliver_to_address4 || ', ') ||
DECODE(x_deliver_to_city, NULL, NULL,x_deliver_to_city || ', ') ||
DECODE(x_deliver_to_state, NULL, NULL,x_deliver_to_state || ', ') ||
DECODE(x_deliver_to_postal_code, NULL, NULL,x_deliver_to_postal_code || ', ') ||
DECODE(x_deliver_to_country, NULL,NULL,x_deliver_to_country)
into x_current_deliver_to_address from dual;
select
DECODE(x_deliver_to_location, NULL, NULL,x_deliver_to_location|| ', ') ||
DECODE(x_deliver_to_address1, NULL, NULL,x_deliver_to_address1 || ', ') ||
DECODE(x_deliver_to_address2, NULL, NULL,x_deliver_to_address3 || ', ') ||
DECODE(x_deliver_to_address3, NULL, NULL,x_deliver_to_address3 || ', ') ||
DECODE(x_deliver_to_address4, NULL, NULL,x_deliver_to_address4 || ', ') ||
DECODE(x_deliver_to_city, NULL, NULL,x_deliver_to_city || ', ') ||
DECODE(x_deliver_to_state, NULL, NULL,x_deliver_to_state || ', ') ||
DECODE(x_deliver_to_postal_code, NULL, NULL,x_deliver_to_postal_code || ', ') ||
DECODE(x_deliver_to_country, NULL,NULL,x_deliver_to_country)
into x_next_deliver_to_address from dual;
select
DECODE(x_intermed_ship_to_location, NULL, NULL,x_intermed_ship_to_location|| ', ') ||
DECODE(x_intermed_ship_to_address1, NULL, NULL,x_intermed_ship_to_address1 || ', ') ||
DECODE(x_intermed_ship_to_address2, NULL, NULL,x_intermed_ship_to_address3 || ', ') ||
DECODE(x_intermed_ship_to_address3, NULL, NULL,x_intermed_ship_to_address3 || ', ') ||
DECODE(x_intermed_ship_to_address4, NULL, NULL,x_intermed_ship_to_address4 || ', ') ||
DECODE(x_intermed_ship_to_city, NULL, NULL,x_intermed_ship_to_city || ', ') ||
DECODE(x_intermed_ship_to_state, NULL, NULL,x_intermed_ship_to_state || ', ') ||
DECODE(x_intermed_ship_to_postal_code, NULL, NULL,x_intermed_ship_to_postal_code || ', ') ||
DECODE(x_intermed_ship_to_country, NULL,NULL,x_intermed_ship_to_country)
into x_current_intermed_address from dual;
select
DECODE(x_intermed_ship_to_location, NULL, NULL,x_intermed_ship_to_location|| ', ') ||
DECODE(x_intermed_ship_to_address1, NULL, NULL,x_intermed_ship_to_address1 || ', ') ||
DECODE(x_intermed_ship_to_address2, NULL, NULL,x_intermed_ship_to_address3 || ', ') ||
DECODE(x_intermed_ship_to_address3, NULL, NULL,x_intermed_ship_to_address3 || ', ') ||
DECODE(x_intermed_ship_to_address4, NULL, NULL,x_intermed_ship_to_address4 || ', ') ||
DECODE(x_intermed_ship_to_city, NULL, NULL,x_intermed_ship_to_city || ', ') ||
DECODE(x_intermed_ship_to_state, NULL, NULL,x_intermed_ship_to_state || ', ') ||
DECODE(x_intermed_ship_to_postal_code, NULL, NULL,x_intermed_ship_to_postal_code || ', ') ||
DECODE(x_intermed_ship_to_country, NULL,NULL,x_intermed_ship_to_country)
into x_prior_intermed_address from dual;
select
DECODE(x_intermed_ship_to_location, NULL, NULL,x_intermed_ship_to_location|| ', ') ||
DECODE(x_intermed_ship_to_address1, NULL, NULL,x_intermed_ship_to_address1 || ', ') ||
DECODE(x_intermed_ship_to_address2, NULL, NULL,x_intermed_ship_to_address3 || ', ') ||
DECODE(x_intermed_ship_to_address3, NULL, NULL,x_intermed_ship_to_address3 || ', ') ||
DECODE(x_intermed_ship_to_address4, NULL, NULL,x_intermed_ship_to_address4 || ', ') ||
DECODE(x_intermed_ship_to_city, NULL, NULL,x_intermed_ship_to_city || ', ') ||
DECODE(x_intermed_ship_to_state, NULL, NULL,x_intermed_ship_to_state || ', ') ||
DECODE(x_intermed_ship_to_postal_code, NULL, NULL,x_intermed_ship_to_postal_code || ', ') ||
DECODE(x_intermed_ship_to_country, NULL,NULL,x_intermed_ship_to_country)
into x_prior_intermed_address from dual;
select
DECODE(x_intermed_ship_to_location, NULL, NULL,x_intermed_ship_to_location|| ', ') ||
DECODE(x_intermed_ship_to_address1, NULL, NULL,x_intermed_ship_to_address1 || ', ') ||
DECODE(x_intermed_ship_to_address2, NULL, NULL,x_intermed_ship_to_address3 || ', ') ||
DECODE(x_intermed_ship_to_address3, NULL, NULL,x_intermed_ship_to_address3 || ', ') ||
DECODE(x_intermed_ship_to_address4, NULL, NULL,x_intermed_ship_to_address4 || ', ') ||
DECODE(x_intermed_ship_to_city, NULL, NULL,x_intermed_ship_to_city || ', ') ||
DECODE(x_intermed_ship_to_state, NULL, NULL,x_intermed_ship_to_state || ', ') ||
DECODE(x_intermed_ship_to_postal_code, NULL, NULL,x_intermed_ship_to_postal_code || ', ') ||
DECODE(x_intermed_ship_to_country, NULL,NULL,x_intermed_ship_to_country)
into x_current_intermed_address from dual;
select
DECODE(x_intermed_ship_to_location, NULL, NULL,x_intermed_ship_to_location|| ', ') ||
DECODE(x_intermed_ship_to_address1, NULL, NULL,x_intermed_ship_to_address1 || ', ') ||
DECODE(x_intermed_ship_to_address2, NULL, NULL,x_intermed_ship_to_address3 || ', ') ||
DECODE(x_intermed_ship_to_address3, NULL, NULL,x_intermed_ship_to_address3 || ', ') ||
DECODE(x_intermed_ship_to_address4, NULL, NULL,x_intermed_ship_to_address4 || ', ') ||
DECODE(x_intermed_ship_to_city, NULL, NULL,x_intermed_ship_to_city || ', ') ||
DECODE(x_intermed_ship_to_state, NULL, NULL,x_intermed_ship_to_state || ', ') ||
DECODE(x_intermed_ship_to_postal_code, NULL, NULL,x_intermed_ship_to_postal_code || ', ') ||
DECODE(x_intermed_ship_to_country, NULL,NULL,x_intermed_ship_to_country)
into x_next_intermed_address from dual;
select
DECODE(x_invoice_to_location, NULL, NULL,x_invoice_to_location|| ', ') ||
DECODE(x_invoice_to_address1, NULL, NULL,x_invoice_to_address1 || ', ') ||
DECODE(x_invoice_to_address2, NULL, NULL,x_invoice_to_address3 || ', ') ||
DECODE(x_invoice_to_address3, NULL, NULL,x_invoice_to_address3 || ', ') ||
DECODE(x_invoice_to_address4, NULL, NULL,x_invoice_to_address4 || ', ') ||
DECODE(x_invoice_to_city, NULL, NULL,x_invoice_to_city || ', ') ||
DECODE(x_invoice_to_state, NULL, NULL,x_invoice_to_state || ', ') ||
DECODE(x_invoice_to_postal_code, NULL, NULL,x_invoice_to_postal_code || ', ') ||
DECODE(x_invoice_to_country, NULL,NULL,x_invoice_to_country)
into x_current_invoice_to_address from dual;
select
DECODE(x_invoice_to_location, NULL, NULL,x_invoice_to_location|| ', ') ||
DECODE(x_invoice_to_address1, NULL, NULL,x_invoice_to_address1 || ', ') ||
DECODE(x_invoice_to_address2, NULL, NULL,x_invoice_to_address3 || ', ') ||
DECODE(x_invoice_to_address3, NULL, NULL,x_invoice_to_address3 || ', ') ||
DECODE(x_invoice_to_address4, NULL, NULL,x_invoice_to_address4 || ', ') ||
DECODE(x_invoice_to_city, NULL, NULL,x_invoice_to_city || ', ') ||
DECODE(x_invoice_to_state, NULL, NULL,x_invoice_to_state || ', ') ||
DECODE(x_invoice_to_postal_code, NULL, NULL,x_invoice_to_postal_code || ', ') ||
DECODE(x_invoice_to_country, NULL,NULL,x_invoice_to_country)
into x_prior_invoice_to_address from dual;
select
DECODE(x_invoice_to_location, NULL, NULL,x_invoice_to_location|| ', ') ||
DECODE(x_invoice_to_address1, NULL, NULL,x_invoice_to_address1 || ', ') ||
DECODE(x_invoice_to_address2, NULL, NULL,x_invoice_to_address3 || ', ') ||
DECODE(x_invoice_to_address3, NULL, NULL,x_invoice_to_address3 || ', ') ||
DECODE(x_invoice_to_address4, NULL, NULL,x_invoice_to_address4 || ', ') ||
DECODE(x_invoice_to_city, NULL, NULL,x_invoice_to_city || ', ') ||
DECODE(x_invoice_to_state, NULL, NULL,x_invoice_to_state || ', ') ||
DECODE(x_invoice_to_postal_code, NULL, NULL,x_invoice_to_postal_code || ', ') ||
DECODE(x_invoice_to_country, NULL,NULL,x_invoice_to_country)
into x_prior_invoice_to_address from dual;
select
DECODE(x_invoice_to_location, NULL, NULL,x_invoice_to_location|| ', ') ||
DECODE(x_invoice_to_address1, NULL, NULL,x_invoice_to_address1 || ', ') ||
DECODE(x_invoice_to_address2, NULL, NULL,x_invoice_to_address3 || ', ') ||
DECODE(x_invoice_to_address3, NULL, NULL,x_invoice_to_address3 || ', ') ||
DECODE(x_invoice_to_address4, NULL, NULL,x_invoice_to_address4 || ', ') ||
DECODE(x_invoice_to_city, NULL, NULL,x_invoice_to_city || ', ') ||
DECODE(x_invoice_to_state, NULL, NULL,x_invoice_to_state || ', ') ||
DECODE(x_invoice_to_postal_code, NULL, NULL,x_invoice_to_postal_code || ', ') ||
DECODE(x_invoice_to_country, NULL,NULL,x_invoice_to_country)
into x_current_invoice_to_address from dual;
select
DECODE(x_invoice_to_location, NULL, NULL,x_invoice_to_location|| ', ') ||
DECODE(x_invoice_to_address1, NULL, NULL,x_invoice_to_address1 || ', ') ||
DECODE(x_invoice_to_address2, NULL, NULL,x_invoice_to_address3 || ', ') ||
DECODE(x_invoice_to_address3, NULL, NULL,x_invoice_to_address3 || ', ') ||
DECODE(x_invoice_to_address4, NULL, NULL,x_invoice_to_address4 || ', ') ||
DECODE(x_invoice_to_city, NULL, NULL,x_invoice_to_city || ', ') ||
DECODE(x_invoice_to_state, NULL, NULL,x_invoice_to_state || ', ') ||
DECODE(x_invoice_to_postal_code, NULL, NULL,x_invoice_to_postal_code || ', ') ||
DECODE(x_invoice_to_country, NULL,NULL,x_invoice_to_country)
into x_next_invoice_to_address from dual;
select
DECODE(x_ship_from_location, NULL, NULL,x_ship_from_location|| ', ') ||
DECODE(x_ship_from_address1, NULL, NULL,x_ship_from_address1 || ', ') ||
DECODE(x_ship_from_address2, NULL, NULL,x_ship_from_address3 || ', ') ||
DECODE(x_ship_from_address3, NULL, NULL,x_ship_from_address3 || ', ') ||
DECODE(x_ship_from_address4, NULL, NULL,x_ship_from_address4 || ', ')
into x_ship_from_address from dual;
select
DECODE(x_ship_from_location, NULL, NULL,x_ship_from_location|| ', ') ||
DECODE(x_ship_from_address1, NULL, NULL,x_ship_from_address1 || ', ') ||
DECODE(x_ship_from_address2, NULL, NULL,x_ship_from_address3 || ', ') ||
DECODE(x_ship_from_address3, NULL, NULL,x_ship_from_address3 || ', ') ||
DECODE(x_ship_from_address4, NULL, NULL,x_ship_from_address4 || ', ')
into x_ship_from_address from dual;
select
DECODE(x_ship_from_location, NULL, NULL,x_ship_from_location|| ', ') ||
DECODE(x_ship_from_address1, NULL, NULL,x_ship_from_address1 || ', ') ||
DECODE(x_ship_from_address2, NULL, NULL,x_ship_from_address3 || ', ') ||
DECODE(x_ship_from_address3, NULL, NULL,x_ship_from_address3 || ', ') ||
DECODE(x_ship_from_address4, NULL, NULL,x_ship_from_address4 || ', ')
into x_ship_from_address from dual;
select
DECODE(x_ship_from_location, NULL, NULL,x_ship_from_location|| ', ') ||
DECODE(x_ship_from_address1, NULL, NULL,x_ship_from_address1 || ', ') ||
DECODE(x_ship_from_address2, NULL, NULL,x_ship_from_address3 || ', ') ||
DECODE(x_ship_from_address3, NULL, NULL,x_ship_from_address3 || ', ') ||
DECODE(x_ship_from_address4, NULL, NULL,x_ship_from_address4 || ', ')
into x_ship_from_address from dual;
select
DECODE(x_ship_from_location, NULL, NULL,x_ship_from_location|| ', ') ||
DECODE(x_ship_from_address1, NULL, NULL,x_ship_from_address1 || ', ') ||
DECODE(x_ship_from_address2, NULL, NULL,x_ship_from_address3 || ', ') ||
DECODE(x_ship_from_address3, NULL, NULL,x_ship_from_address3 || ', ') ||
DECODE(x_ship_from_address4, NULL, NULL,x_ship_from_address4 || ', ')
into x_ship_from_address from dual;
select
DECODE(x_ship_to_location, NULL, NULL,x_ship_to_location|| ', ') ||
DECODE(x_ship_to_address1, NULL, NULL,x_ship_to_address1 || ', ') ||
DECODE(x_ship_to_address2, NULL, NULL,x_ship_to_address3 || ', ') ||
DECODE(x_ship_to_address3, NULL, NULL,x_ship_to_address3 || ', ') ||
DECODE(x_ship_to_address4, NULL, NULL,x_ship_to_address4 || ', ') ||
DECODE(x_ship_to_city, NULL, NULL,x_ship_to_city || ', ') ||
DECODE(x_ship_to_state, NULL, NULL,x_ship_to_state || ', ') ||
DECODE(x_ship_to_postal_code, NULL, NULL,x_ship_to_postal_code || ', ') ||
DECODE(x_ship_to_country, NULL,NULL,x_ship_to_country)
into x_current_ship_to_address from dual;
select
DECODE(x_ship_to_location, NULL, NULL,x_ship_to_location|| ', ') ||
DECODE(x_ship_to_address1, NULL, NULL,x_ship_to_address1 || ', ') ||
DECODE(x_ship_to_address2, NULL, NULL,x_ship_to_address3 || ', ') ||
DECODE(x_ship_to_address3, NULL, NULL,x_ship_to_address3 || ', ') ||
DECODE(x_ship_to_address4, NULL, NULL,x_ship_to_address4 || ', ') ||
DECODE(x_ship_to_city, NULL, NULL,x_ship_to_city || ', ') ||
DECODE(x_ship_to_state, NULL, NULL,x_ship_to_state || ', ') ||
DECODE(x_ship_to_postal_code, NULL, NULL,x_ship_to_postal_code || ', ') ||
DECODE(x_ship_to_country, NULL,NULL,x_ship_to_country)
into x_prior_ship_to_address from dual;
select
DECODE(x_ship_to_location, NULL, NULL,x_ship_to_location|| ', ') ||
DECODE(x_ship_to_address1, NULL, NULL,x_ship_to_address1 || ', ') ||
DECODE(x_ship_to_address2, NULL, NULL,x_ship_to_address3 || ', ') ||
DECODE(x_ship_to_address3, NULL, NULL,x_ship_to_address3 || ', ') ||
DECODE(x_ship_to_address4, NULL, NULL,x_ship_to_address4 || ', ') ||
DECODE(x_ship_to_city, NULL, NULL,x_ship_to_city || ', ') ||
DECODE(x_ship_to_state, NULL, NULL,x_ship_to_state || ', ') ||
DECODE(x_ship_to_postal_code, NULL, NULL,x_ship_to_postal_code || ', ') ||
DECODE(x_ship_to_country, NULL,NULL,x_ship_to_country)
into x_prior_ship_to_address from dual;
select
DECODE(x_ship_to_location, NULL, NULL,x_ship_to_location|| ', ') ||
DECODE(x_ship_to_address1, NULL, NULL,x_ship_to_address1 || ', ') ||
DECODE(x_ship_to_address2, NULL, NULL,x_ship_to_address3 || ', ') ||
DECODE(x_ship_to_address3, NULL, NULL,x_ship_to_address3 || ', ') ||
DECODE(x_ship_to_address4, NULL, NULL,x_ship_to_address4 || ', ') ||
DECODE(x_ship_to_city, NULL, NULL,x_ship_to_city || ', ') ||
DECODE(x_ship_to_state, NULL, NULL,x_ship_to_state || ', ') ||
DECODE(x_ship_to_postal_code, NULL, NULL,x_ship_to_postal_code || ', ') ||
DECODE(x_ship_to_country, NULL,NULL,x_ship_to_country)
into x_current_ship_to_address from dual;
select
DECODE(x_ship_to_location, NULL, NULL,x_ship_to_location|| ', ') ||
DECODE(x_ship_to_address1, NULL, NULL,x_ship_to_address1 || ', ') ||
DECODE(x_ship_to_address2, NULL, NULL,x_ship_to_address3 || ', ') ||
DECODE(x_ship_to_address3, NULL, NULL,x_ship_to_address3 || ', ') ||
DECODE(x_ship_to_address4, NULL, NULL,x_ship_to_address4 || ', ') ||
DECODE(x_ship_to_city, NULL, NULL,x_ship_to_city || ', ') ||
DECODE(x_ship_to_state, NULL, NULL,x_ship_to_state || ', ') ||
DECODE(x_ship_to_postal_code, NULL, NULL,x_ship_to_postal_code || ', ') ||
DECODE(x_ship_to_country, NULL,NULL,x_ship_to_country)
into x_next_ship_to_address from dual;
SELECT distinct line_id
from oe_order_lines_history
where header_id = p_header_id
--Bug 8478088
and version_flag = 'Y'
--and transaction_phase_code = p_transaction_phase_code
and version_number in (p_prior_version,p_current_version,p_next_version)
union
SELECT line_id
from oe_order_lines_all
where header_id=p_header_id;
SELECT distinct line_id
from oe_order_lines_history
where header_id = p_header_id
--Bug 8478088
and version_flag = 'Y'
--and transaction_phase_code = p_transaction_phase_code
and version_number in (p_prior_version,p_current_version,p_next_version);
select oe_order_misc_pub.get_concat_line_number(l_line_id) into x_line_number from dual;
select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
select oe_order_misc_pub.get_concat_hist_line_number(l_line_id,p_current_version) into x_line_number from dual;
select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
select oe_order_misc_pub.get_concat_hist_line_number(l_line_id,p_current_version) into x_line_number from dual;
SELECT ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, CONTEXT
, CREATED_BY
, CREATION_DATE
, DW_UPDATE_ADVICE_FLAG
, HEADER_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LINE_ID
, PERCENT
, SALESREP_ID
, sales_credit_type_id
, SALES_CREDIT_ID
, WH_UPDATE_DATE
, SALES_GROUP_ID
, SALES_GROUP_UPDATED_FLAG
, LOCK_CONTROL
INTO
x_header_scredit_rec.ATTRIBUTE1
,x_header_scredit_rec.ATTRIBUTE10
,x_header_scredit_rec.ATTRIBUTE11
,x_header_scredit_rec.ATTRIBUTE12
,x_header_scredit_rec.ATTRIBUTE13
,x_header_scredit_rec.ATTRIBUTE14
,x_header_scredit_rec.ATTRIBUTE15
,x_header_scredit_rec.ATTRIBUTE2
,x_header_scredit_rec.ATTRIBUTE3
,x_header_scredit_rec.ATTRIBUTE4
,x_header_scredit_rec.ATTRIBUTE5
,x_header_scredit_rec.ATTRIBUTE6
,x_header_scredit_rec.ATTRIBUTE7
,x_header_scredit_rec.ATTRIBUTE8
,x_header_scredit_rec.ATTRIBUTE9
,x_header_scredit_rec.CONTEXT
,x_header_scredit_rec.CREATED_BY
,x_header_scredit_rec.CREATION_DATE
,x_header_scredit_rec.DW_UPDATE_ADVICE_FLAG
,x_header_scredit_rec.HEADER_ID
,x_header_scredit_rec.LAST_UPDATED_BY
,x_header_scredit_rec.LAST_UPDATE_DATE
,x_header_scredit_rec.LAST_UPDATE_LOGIN
,x_header_scredit_rec.LINE_ID
,x_header_scredit_rec.PERCENT
,x_header_scredit_rec.SALESREP_ID
,x_header_scredit_rec.sales_credit_type_id
,x_header_scredit_rec.SALES_CREDIT_ID
,x_header_scredit_rec.WH_UPDATE_DATE
,x_header_scredit_rec.SALES_GROUP_ID
,x_header_scredit_rec.SALES_GROUP_UPDATED_FLAG
,x_header_scredit_rec.LOCK_CONTROL
FROM OE_SALES_CREDIT_HISTORY
WHERE
HEADER_ID = p_header_id
AND sales_credit_id = p_sales_credit_id
AND LINE_ID IS NULL
AND VERSION_NUMBER = p_version
AND (PHASE_CHANGE_FLAG = p_phase_change_flag
OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'
AND VERSION_FLAG = 'Y'));
SELECT ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, CONTEXT
, CREATED_BY
, CREATION_DATE
, DW_UPDATE_ADVICE_FLAG
, HEADER_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LINE_ID
, PERCENT
, SALESREP_ID
, sales_credit_type_id
, SALES_CREDIT_ID
, WH_UPDATE_DATE
, SALES_GROUP_ID
, SALES_GROUP_UPDATED_FLAG
, LOCK_CONTROL
INTO
x_header_scredit_rec.ATTRIBUTE1
,x_header_scredit_rec.ATTRIBUTE10
,x_header_scredit_rec.ATTRIBUTE11
,x_header_scredit_rec.ATTRIBUTE12
,x_header_scredit_rec.ATTRIBUTE13
,x_header_scredit_rec.ATTRIBUTE14
,x_header_scredit_rec.ATTRIBUTE15
,x_header_scredit_rec.ATTRIBUTE2
,x_header_scredit_rec.ATTRIBUTE3
,x_header_scredit_rec.ATTRIBUTE4
,x_header_scredit_rec.ATTRIBUTE5
,x_header_scredit_rec.ATTRIBUTE6
,x_header_scredit_rec.ATTRIBUTE7
,x_header_scredit_rec.ATTRIBUTE8
,x_header_scredit_rec.ATTRIBUTE9
,x_header_scredit_rec.CONTEXT
,x_header_scredit_rec.CREATED_BY
,x_header_scredit_rec.CREATION_DATE
,x_header_scredit_rec.DW_UPDATE_ADVICE_FLAG
,x_header_scredit_rec.HEADER_ID
,x_header_scredit_rec.LAST_UPDATED_BY
,x_header_scredit_rec.LAST_UPDATE_DATE
,x_header_scredit_rec.LAST_UPDATE_LOGIN
,x_header_scredit_rec.LINE_ID
,x_header_scredit_rec.PERCENT
,x_header_scredit_rec.SALESREP_ID
,x_header_scredit_rec.sales_credit_type_id
,x_header_scredit_rec.SALES_CREDIT_ID
,x_header_scredit_rec.WH_UPDATE_DATE
,x_header_scredit_rec.SALES_GROUP_ID
,x_header_scredit_rec.SALES_GROUP_UPDATED_FLAG
,x_header_scredit_rec.LOCK_CONTROL
FROM OE_SALES_CREDITS
WHERE
HEADER_ID = p_header_id
AND sales_credit_id = p_sales_credit_id
AND LINE_ID IS NULL;
/* START sales_group_updated_flag*/
-- no prompt for sales_group_updated_flag in sales_credits block
/* END sales_group_updated_flag*/
/****************************/
/****************************/
/* START sales_group_id*/
prior_exists := 'N';
x_header_sc_changed_attr_tbl(ind).next_value := 'DELETE';
x_header_sc_changed_attr_tbl(ind).next_value := 'DELETE';
oe_debug_pub.add(' before finding deleted salesreps');
x_header_sc_changed_attr_tbl(ind).current_value := 'DELETE';
x_header_sc_changed_attr_tbl(ind).next_value := 'DELETE';
SELECT distinct sales_credit_id
from oe_sales_credit_history
where header_id = p_header_id
and line_id is null
--Bug 8478088
and version_flag = 'Y'
--and phase_change_flag = p_transaction_phase_code
and version_number in (p_prior_version,p_current_version,p_next_version)
union
SELECT sales_credit_id
from oe_sales_credits
where header_id=p_header_id
and line_id is null;
SELECT distinct sales_credit_id
from oe_sales_credit_history
where header_id = p_header_id
and line_id is null
--Bug 8478088
and version_flag = 'Y'
--and phase_change_flag = p_transaction_phase_code
and version_number in (p_prior_version,p_current_version,p_next_version);
SELECT ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, CONTEXT
, CREATED_BY
, CREATION_DATE
, DW_UPDATE_ADVICE_FLAG
, line_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LINE_ID
, PERCENT
, SALESREP_ID
, sales_credit_type_id
, SALES_CREDIT_ID
, WH_UPDATE_DATE
, SALES_GROUP_ID
, SALES_GROUP_UPDATED_FLAG
, LOCK_CONTROL
INTO
x_line_scredit_rec.ATTRIBUTE1
,x_line_scredit_rec.ATTRIBUTE10
,x_line_scredit_rec.ATTRIBUTE11
,x_line_scredit_rec.ATTRIBUTE12
,x_line_scredit_rec.ATTRIBUTE13
,x_line_scredit_rec.ATTRIBUTE14
,x_line_scredit_rec.ATTRIBUTE15
,x_line_scredit_rec.ATTRIBUTE2
,x_line_scredit_rec.ATTRIBUTE3
,x_line_scredit_rec.ATTRIBUTE4
,x_line_scredit_rec.ATTRIBUTE5
,x_line_scredit_rec.ATTRIBUTE6
,x_line_scredit_rec.ATTRIBUTE7
,x_line_scredit_rec.ATTRIBUTE8
,x_line_scredit_rec.ATTRIBUTE9
,x_line_scredit_rec.CONTEXT
,x_line_scredit_rec.CREATED_BY
,x_line_scredit_rec.CREATION_DATE
,x_line_scredit_rec.DW_UPDATE_ADVICE_FLAG
,x_line_scredit_rec.HEADER_ID
,x_line_scredit_rec.LAST_UPDATED_BY
,x_line_scredit_rec.LAST_UPDATE_DATE
,x_line_scredit_rec.LAST_UPDATE_LOGIN
,x_line_scredit_rec.LINE_ID
,x_line_scredit_rec.PERCENT
,x_line_scredit_rec.SALESREP_ID
,x_line_scredit_rec.sales_credit_type_id
,x_line_scredit_rec.SALES_CREDIT_ID
,x_line_scredit_rec.WH_UPDATE_DATE
,x_line_scredit_rec.SALES_GROUP_ID
,x_line_scredit_rec.SALES_GROUP_UPDATED_FLAG
,x_line_scredit_rec.LOCK_CONTROL
FROM OE_SALES_CREDIT_HISTORY
WHERE
HEADER_ID = p_header_id
AND sales_credit_id = p_sales_credit_id
AND VERSION_NUMBER=p_version
--Bug 8478088
AND version_flag = 'Y'
-- AND phase_change_flag = l_phase_change_flag
AND LINE_ID IS NOT NULL;
SELECT ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, CONTEXT
, CREATED_BY
, CREATION_DATE
, DW_UPDATE_ADVICE_FLAG
, HEADER_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LINE_ID
, PERCENT
, SALESREP_ID
, sales_credit_type_id
, SALES_CREDIT_ID
, WH_UPDATE_DATE
, SALES_GROUP_ID
, SALES_GROUP_UPDATED_FLAG
, LOCK_CONTROL
INTO
x_line_scredit_rec.ATTRIBUTE1
,x_line_scredit_rec.ATTRIBUTE10
,x_line_scredit_rec.ATTRIBUTE11
,x_line_scredit_rec.ATTRIBUTE12
,x_line_scredit_rec.ATTRIBUTE13
,x_line_scredit_rec.ATTRIBUTE14
,x_line_scredit_rec.ATTRIBUTE15
,x_line_scredit_rec.ATTRIBUTE2
,x_line_scredit_rec.ATTRIBUTE3
,x_line_scredit_rec.ATTRIBUTE4
,x_line_scredit_rec.ATTRIBUTE5
,x_line_scredit_rec.ATTRIBUTE6
,x_line_scredit_rec.ATTRIBUTE7
,x_line_scredit_rec.ATTRIBUTE8
,x_line_scredit_rec.ATTRIBUTE9
,x_line_scredit_rec.CONTEXT
,x_line_scredit_rec.CREATED_BY
,x_line_scredit_rec.CREATION_DATE
,x_line_scredit_rec.DW_UPDATE_ADVICE_FLAG
,x_line_scredit_rec.HEADER_ID
,x_line_scredit_rec.LAST_UPDATED_BY
,x_line_scredit_rec.LAST_UPDATE_DATE
,x_line_scredit_rec.LAST_UPDATE_LOGIN
,x_line_scredit_rec.LINE_ID
,x_line_scredit_rec.PERCENT
,x_line_scredit_rec.SALESREP_ID
,x_line_scredit_rec.sales_credit_type_id
,x_line_scredit_rec.SALES_CREDIT_ID
,x_line_scredit_rec.WH_UPDATE_DATE
,x_line_scredit_rec.SALES_GROUP_ID
,x_line_scredit_rec.SALES_GROUP_UPDATED_FLAG
,x_line_scredit_rec.LOCK_CONTROL
FROM OE_SALES_CREDITS
WHERE
HEADER_ID = p_header_id
AND sales_credit_id = p_sales_credit_id
AND LINE_ID IS NOT NULL;
x_line_sc_changed_attr_tbl(ind).next_value := 'DELETE';
x_line_sc_changed_attr_tbl(ind).next_value := 'DELETE';
oe_debug_pub.add(' before finding deleted salesreps');
x_line_sc_changed_attr_tbl(ind).current_value := 'DELETE';
x_line_sc_changed_attr_tbl(ind).next_value := 'DELETE';
SELECT distinct sales_credit_id,line_id
from oe_sales_credit_history
where header_id = p_header_id
and line_id is not null
--Bug 8478088
and version_flag = 'Y'
--and phase_change_flag = p_transaction_phase_code
and version_number in (p_prior_version,p_current_version,p_next_version)
union
SELECT sales_credit_id,line_id
from oe_sales_credits
where header_id=p_header_id
and line_id is not null;
SELECT distinct sales_credit_id,line_id
from oe_sales_credit_history
where header_id = p_header_id
and line_id is not null
--Bug 8478088
and version_flag = 'Y'
--and phase_change_flag = p_transaction_phase_code
and version_number in (p_prior_version,p_current_version,p_next_version);
select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
select oe_order_misc_pub.get_concat_hist_line_number(l_line_id,p_current_version) into x_line_number from dual;
select oe_order_misc_pub.get_concat_line_number(l_line_id) into x_line_number from dual;
select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
select oe_order_misc_pub.get_concat_hist_line_number(l_line_id,p_current_version) into x_line_number from dual;
SELECT MEANING
INTO l_line_status
FROM OE_LOOKUPS
WHERE LOOKUP_CODE = p_line_status_code
AND LOOKUP_TYPE = 'VERSION_COMP_LINE_STATUS';
SELECT CHNAME
INTO l_attribute_value1
FROM iby_creditcard_h
WHERE card_history_change_id = p_instrument_id1;
SELECT CHNAME
INTO l_attribute_value1
FROM iby_creditcard
WHERE instrid = p_instrument_id1;
SELECT CHNAME
INTO l_attribute_value2
FROM iby_creditcard_h
WHERE card_history_change_id = p_instrument_id2;
SELECT CHNAME
INTO l_attribute_value2
FROM iby_creditcard
WHERE instrid = p_instrument_id2;
SELECT card_issuer_code
INTO l_attribute_value1
FROM iby_creditcard_h
WHERE card_history_change_id = p_instrument_id1;
SELECT card_issuer_code
INTO l_attribute_value1
FROM iby_creditcard
WHERE instrid = p_instrument_id1;
SELECT card_issuer_code
INTO l_attribute_value2
FROM iby_creditcard_h
WHERE card_history_change_id = p_instrument_id2;
SELECT card_issuer_code
INTO l_attribute_value2
FROM iby_creditcard
WHERE instrid = p_instrument_id2;
select encrypted
into l_encrypted
from iby_creditcard
where instrid=p_instrument_id1;
select encrypted
into l_encrypted
from iby_creditcard_h
where card_history_change_id=p_instrument_id1;
SELECT expirydate
INTO l_attribute_value1
FROM iby_creditcard_h
WHERE card_history_change_id = p_instrument_id1;
select credit_card_expiration_date
INTO l_attribute_value1
FROM oe_order_header_history
WHERE instrument_id = p_instrument_id1
and rownum=1;
SELECT expirydate
INTO l_attribute_value1
FROM iby_creditcard
WHERE instrid = p_instrument_id1;
select encrypted
into l_encrypted
from iby_creditcard
where instrid=p_instrument_id2;
select encrypted
into l_encrypted
from iby_creditcard_h
where card_history_change_id=p_instrument_id2;
SELECT expirydate
INTO l_attribute_value2
FROM iby_creditcard_h
WHERE card_history_change_id = p_instrument_id2;
select credit_card_expiration_date
INTO l_attribute_value2
FROM oe_order_header_history
WHERE instrument_id = p_instrument_id2
and rownum=1;
SELECT expirydate
INTO l_attribute_value2
FROM iby_creditcard
WHERE instrid = p_instrument_id2;
SELECT authorization_code
INTO l_attribute_value1
FROM iby_trxn_ext_auths_v
WHERE authorization_id = p_instrument_id1;
SELECT authorization_code
INTO l_attribute_value2
FROM iby_trxn_ext_auths_v
WHERE authorization_id = p_instrument_id2;
SELECT authorization_date
INTO l_attribute_value1
FROM iby_trxn_ext_auths_v
WHERE authorization_id = p_instrument_id1;
SELECT authorization_date
INTO l_attribute_value2
FROM iby_trxn_ext_auths_v
WHERE authorization_id = p_instrument_id2;
CURSOR c1 Is select form_left_prompt from fnd_descr_flex_col_usage_vl
where application_id=660
and descriptive_flexfield_name= p_descriptive_flexfield_name
and application_column_name =p_application_column_name
and DESCRIPTIVE_FLEX_CONTEXT_CODE in (p_descriptive_flex_context_cod, p_desc_flex_context_cod_prior, p_desc_flex_context_cod_next, 'Global Data Elements');
select FORM_CONTEXT_PROMPT into l_prompt from FND_DESCRIPTIVE_FLEXS_VL
where APPLICATION_ID = p_application_id
and DESCRIPTIVE_FLEXFIELD_NAME = p_descriptive_flexfield_name;
select form_left_prompt into l_prompt from fnd_descr_flex_col_usage_vl where application_id=660
and descriptive_flexfield_name= p_descriptive_flexfield_name
and application_column_name =p_application_column_name;