[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT flow_status_code
INTO l_flow_status_code
FROM oe_order_lines_all
WHERE line_id=p_line_id;
SELECT sum(decode(released_status, 'Y', 1, 'C', 1, 0)), sum(1)
INTO released_count, total_count
FROM wsh_delivery_details
WHERE source_line_id = p_line_id
AND source_code = 'OE'
AND released_status <> 'D';
SELECT version_number
INTO l_version_number
FROM oe_order_headers
WHERE header_id = p_header_id;
SELECT ite.instrument_id
INTO l_instrument_id
FROM oe_payments op,
iby_trxn_extensions_v ite
WHERE op.header_id = p_header_id
AND op.trxn_extension_id = ite.trxn_extension_id;
SELECT u.instrument_id
INTO l_instrument_id
FROM oe_payments op,
iby_pmt_instr_uses_all u,
iby_fndcpt_tx_extensions x
WHERE op.header_id = p_header_id
AND op.payment_type_code = 'CREDIT_CARD'
AND nvl(op.payment_collection_event, 'PREPAY') = 'INVOICE'
AND op.trxn_extension_id = x.trxn_extension_id
AND op.line_id is null
AND x.instr_assignment_id = u.instrument_payment_use_id;
SELECT max(card_history_change_id)
INTO l_instrument_id
FROM iby_creditcard_h
WHERE instrid = l_instrument_id;
SELECT max(card_history_change_id)
INTO l_instrument_id
FROM iby_creditcard_h
WHERE instrid = l_instrument_id;
INSERT INTO OE_ORDER_HEADER_HISTORY
(
HEADER_ID,
HIST_CREATION_DATE,
ORG_ID,
ORDER_TYPE_ID,
ORDER_NUMBER,
VERSION_NUMBER,
EXPIRATION_DATE,
ORDER_SOURCE_ID,
SOURCE_DOCUMENT_TYPE_ID,
ORIG_SYS_DOCUMENT_REF,
SOURCE_DOCUMENT_ID,
ORDERED_DATE,
REQUEST_DATE,
PRICING_DATE,
SHIPMENT_PRIORITY_CODE,
DEMAND_CLASS_CODE,
PRICE_LIST_ID,
TAX_EXEMPT_FLAG,
TAX_EXEMPT_NUMBER,
TAX_EXEMPT_REASON_CODE,
CONVERSION_RATE,
CONVERSION_TYPE_CODE,
CONVERSION_RATE_DATE,
PARTIAL_SHIPMENTS_ALLOWED,
SHIP_TOLERANCE_ABOVE,
SHIP_TOLERANCE_BELOW,
TRANSACTIONAL_CURR_CODE,
AGREEMENT_ID,
TAX_POINT_CODE,
CUST_PO_NUMBER,
INVOICING_RULE_ID,
ACCOUNTING_RULE_ID,
PAYMENT_TERM_ID,
SHIPPING_METHOD_CODE,
FREIGHT_CARRIER_CODE,
FOB_POINT_CODE,
FREIGHT_TERMS_CODE,
SOLD_FROM_ORG_ID,
SOLD_TO_ORG_ID,
SHIP_FROM_ORG_ID,
SHIP_TO_ORG_ID,
INVOICE_TO_ORG_ID,
DELIVER_TO_ORG_ID,
SOLD_TO_CONTACT_ID,
SHIP_TO_CONTACT_ID,
INVOICE_TO_CONTACT_ID,
DELIVER_TO_CONTACT_ID,
CREATION_DATE,
CREATED_BY,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
REQUEST_ID,
CONTEXT,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
GLOBAL_ATTRIBUTE_CATEGORY,
GLOBAL_ATTRIBUTE1,
GLOBAL_ATTRIBUTE2,
GLOBAL_ATTRIBUTE3,
GLOBAL_ATTRIBUTE4,
GLOBAL_ATTRIBUTE5,
GLOBAL_ATTRIBUTE6,
GLOBAL_ATTRIBUTE7,
GLOBAL_ATTRIBUTE8,
GLOBAL_ATTRIBUTE9,
GLOBAL_ATTRIBUTE10,
GLOBAL_ATTRIBUTE11,
GLOBAL_ATTRIBUTE12,
GLOBAL_ATTRIBUTE13,
GLOBAL_ATTRIBUTE14,
GLOBAL_ATTRIBUTE15,
GLOBAL_ATTRIBUTE16,
GLOBAL_ATTRIBUTE17,
GLOBAL_ATTRIBUTE18,
GLOBAL_ATTRIBUTE19,
GLOBAL_ATTRIBUTE20,
CANCELLED_FLAG,
OPEN_FLAG,
BOOKED_FLAG,
SALESREP_ID,
RETURN_REASON_CODE,
ORDER_DATE_TYPE_CODE,
EARLIEST_SCHEDULE_LIMIT,
LATEST_SCHEDULE_LIMIT,
PAYMENT_TYPE_CODE,
PAYMENT_AMOUNT,
CHECK_NUMBER,
CREDIT_CARD_NUMBER,
CREDIT_CARD_CODE,
CREDIT_CARD_HOLDER_NAME,
CREDIT_CARD_EXPIRATION_DATE,
-- CREDIT_CARD_APPROVAL_CODE,
SALES_CHANNEL_CODE,
FIRST_ACK_CODE,
FIRST_ACK_DATE,
LAST_ACK_CODE,
LAST_ACK_DATE,
ORDER_CATEGORY_CODE,
CHANGE_SEQUENCE,
SHIPPING_INSTRUCTIONS,
PACKING_INSTRUCTIONS,
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,
CREDIT_CARD_APPROVAL_DATE,
UPGRADED_FLAG,
CUSTOMER_PREFERENCE_SET_CODE,
BOOKED_DATE,
LOCK_CONTROL,
REASON_CODE,
HIST_COMMENTS,
HIST_TYPE_CODE,
HIST_CREATED_BY,
RESPONSIBILITY_ID,
PRICE_REQUEST_CODE,
ACCOUNTING_RULE_DURATION,
ATTRIBUTE16,
ATTRIBUTE17,
ATTRIBUTE18,
ATTRIBUTE19,
ATTRIBUTE20,
ITEM_RELATIONSHIP_TYPE,
BLANKET_NUMBER,
SALES_DOCUMENT_TYPE_CODE,
SOLD_TO_PHONE_ID,
QUOTE_NUMBER,
SALES_DOCUMENT_NAME,
TRANSACTION_PHASE_CODE,
USER_STATUS_CODE,
DRAFT_SUBMITTED_FLAG,
SOURCE_DOCUMENT_VERSION_NUMBER,
SOLD_TO_SITE_USE_ID,
QUOTE_DATE,
SUPPLIER_SIGNATURE,
SUPPLIER_SIGNATURE_DATE,
CUSTOMER_SIGNATURE,
CUSTOMER_SIGNATURE_DATE,
AUDIT_FLAG,
VERSION_FLAG,
PHASE_CHANGE_FLAG,
--key Transaction Dates
ORDER_FIRMED_DATE,
INSTRUMENT_ID
)
SELECT
HEADER_ID,
sysdate,
ORG_ID,
ORDER_TYPE_ID,
ORDER_NUMBER,
VERSION_NUMBER,
EXPIRATION_DATE,
ORDER_SOURCE_ID,
SOURCE_DOCUMENT_TYPE_ID,
ORIG_SYS_DOCUMENT_REF,
SOURCE_DOCUMENT_ID,
ORDERED_DATE,
REQUEST_DATE,
PRICING_DATE,
SHIPMENT_PRIORITY_CODE,
DEMAND_CLASS_CODE,
PRICE_LIST_ID,
TAX_EXEMPT_FLAG,
TAX_EXEMPT_NUMBER,
TAX_EXEMPT_REASON_CODE,
CONVERSION_RATE,
CONVERSION_TYPE_CODE,
CONVERSION_RATE_DATE,
PARTIAL_SHIPMENTS_ALLOWED,
SHIP_TOLERANCE_ABOVE,
SHIP_TOLERANCE_BELOW,
TRANSACTIONAL_CURR_CODE,
AGREEMENT_ID,
TAX_POINT_CODE,
CUST_PO_NUMBER,
INVOICING_RULE_ID,
ACCOUNTING_RULE_ID,
PAYMENT_TERM_ID,
SHIPPING_METHOD_CODE,
FREIGHT_CARRIER_CODE,
FOB_POINT_CODE,
FREIGHT_TERMS_CODE,
SOLD_FROM_ORG_ID,
SOLD_TO_ORG_ID,
SHIP_FROM_ORG_ID,
SHIP_TO_ORG_ID,
INVOICE_TO_ORG_ID,
DELIVER_TO_ORG_ID,
SOLD_TO_CONTACT_ID,
SHIP_TO_CONTACT_ID,
INVOICE_TO_CONTACT_ID,
DELIVER_TO_CONTACT_ID,
CREATION_DATE,
CREATED_BY,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
REQUEST_ID,
CONTEXT,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
GLOBAL_ATTRIBUTE_CATEGORY,
GLOBAL_ATTRIBUTE1,
GLOBAL_ATTRIBUTE2,
GLOBAL_ATTRIBUTE3,
GLOBAL_ATTRIBUTE4,
GLOBAL_ATTRIBUTE5,
GLOBAL_ATTRIBUTE6,
GLOBAL_ATTRIBUTE7,
GLOBAL_ATTRIBUTE8,
GLOBAL_ATTRIBUTE9,
GLOBAL_ATTRIBUTE10,
GLOBAL_ATTRIBUTE11,
GLOBAL_ATTRIBUTE12,
GLOBAL_ATTRIBUTE13,
GLOBAL_ATTRIBUTE14,
GLOBAL_ATTRIBUTE15,
GLOBAL_ATTRIBUTE16,
GLOBAL_ATTRIBUTE17,
GLOBAL_ATTRIBUTE18,
GLOBAL_ATTRIBUTE19,
GLOBAL_ATTRIBUTE20,
CANCELLED_FLAG,
OPEN_FLAG,
BOOKED_FLAG,
SALESREP_ID,
RETURN_REASON_CODE,
ORDER_DATE_TYPE_CODE,
EARLIEST_SCHEDULE_LIMIT,
LATEST_SCHEDULE_LIMIT,
PAYMENT_TYPE_CODE,
PAYMENT_AMOUNT,
CHECK_NUMBER,
L_CREDIT_CARD_NUMBER,
L_CREDIT_CARD_CODE,
L_CREDIT_CARD_HOLDER_NAME,
L_CREDIT_CARD_EXPIRATION_DATE,
-- CREDIT_CARD_APPROVAL_CODE,
SALES_CHANNEL_CODE,
FIRST_ACK_CODE,
FIRST_ACK_DATE,
LAST_ACK_CODE,
LAST_ACK_DATE,
ORDER_CATEGORY_CODE,
CHANGE_SEQUENCE,
SHIPPING_INSTRUCTIONS,
PACKING_INSTRUCTIONS,
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,
CREDIT_CARD_APPROVAL_DATE,
UPGRADED_FLAG,
CUSTOMER_PREFERENCE_SET_CODE,
BOOKED_DATE,
LOCK_CONTROL,
NULL, --REASON_CODE,
NULL, --HIST_COMMENTS,
NULL, --HIST_TYPE_CODE,
nvl(FND_GLOBAL.USER_ID, -1), --HIST_CREATED_BY,
nvl(FND_GLOBAL.RESP_ID, -1), --RESPONSIBILITY_ID,
PRICE_REQUEST_CODE,
ACCOUNTING_RULE_DURATION,
ATTRIBUTE16,
ATTRIBUTE17,
ATTRIBUTE18,
ATTRIBUTE19,
ATTRIBUTE20,
NULL, --ITEM_RELATIONSHIP_TYPE,
BLANKET_NUMBER,
SALES_DOCUMENT_TYPE_CODE,
SOLD_TO_PHONE_ID,
QUOTE_NUMBER,
SALES_DOCUMENT_NAME,
TRANSACTION_PHASE_CODE,
USER_STATUS_CODE,
DRAFT_SUBMITTED_FLAG,
SOURCE_DOCUMENT_VERSION_NUMBER,
SOLD_TO_SITE_USE_ID,
QUOTE_DATE,
SUPPLIER_SIGNATURE,
SUPPLIER_SIGNATURE_DATE,
CUSTOMER_SIGNATURE,
CUSTOMER_SIGNATURE_DATE,
'N', -- AUDIT_FLAG,
l_version_flag, -- VERSION_FLAG,
p_phase_change_flag, --PHASE_CHANGE_FLAG
--key Transaction Dates
order_firmed_date,
l_instrument_id
FROM OE_ORDER_HEADERS a
WHERE a.header_id = p_header_id
AND NOT EXISTS (SELECT b.header_id
FROM OE_ORDER_HEADER_HISTORY b
WHERE a.header_id = b.header_id
AND b.version_number = l_version_number
AND b.version_flag = l_version_flag);
INSERT INTO oe_order_lines_history
(
LINE_ID,
ORG_ID,
HEADER_ID,
LINE_TYPE_ID,
LINE_NUMBER,
REQUEST_DATE,
PROMISE_DATE,
SCHEDULE_SHIP_DATE,
ORDER_QUANTITY_UOM,
PRICING_QUANTITY,
PRICING_QUANTITY_UOM,
CANCELLED_QUANTITY,
SHIPPED_QUANTITY,
ORDERED_QUANTITY,
FULFILLED_QUANTITY,
SHIPPING_QUANTITY,
SHIPPING_QUANTITY_UOM,
DELIVERY_LEAD_TIME,
TAX_EXEMPT_FLAG,
TAX_EXEMPT_NUMBER,
TAX_EXEMPT_REASON_CODE,
SHIP_FROM_ORG_ID,
SHIP_TO_ORG_ID,
INVOICE_TO_ORG_ID,
DELIVER_TO_ORG_ID,
SHIP_TO_CONTACT_ID,
DELIVER_TO_CONTACT_ID,
INVOICE_TO_CONTACT_ID,
SOLD_FROM_ORG_ID,
SOLD_TO_ORG_ID,
CUST_PO_NUMBER,
SHIP_TOLERANCE_ABOVE,
SHIP_TOLERANCE_BELOW,
DEMAND_BUCKET_TYPE_CODE,
VEH_CUS_ITEM_CUM_KEY_ID,
RLA_SCHEDULE_TYPE_CODE,
CUSTOMER_DOCK_CODE,
CUSTOMER_JOB,
CUSTOMER_PRODUCTION_LINE,
CUST_MODEL_SERIAL_NUMBER,
PROJECT_ID,
TASK_ID,
INVENTORY_ITEM_ID,
TAX_DATE,
TAX_CODE,
TAX_RATE,
DEMAND_CLASS_CODE,
PRICE_LIST_ID,
PRICING_DATE,
SHIPMENT_NUMBER,
AGREEMENT_ID,
SHIPMENT_PRIORITY_CODE,
SHIPPING_METHOD_CODE,
FREIGHT_CARRIER_CODE,
FREIGHT_TERMS_CODE,
FOB_POINT_CODE,
TAX_POINT_CODE,
PAYMENT_TERM_ID,
INVOICING_RULE_ID,
ACCOUNTING_RULE_ID,
SOURCE_DOCUMENT_TYPE_ID,
ORIG_SYS_DOCUMENT_REF,
SOURCE_DOCUMENT_ID,
ORIG_SYS_LINE_REF,
SOURCE_DOCUMENT_LINE_ID,
REFERENCE_LINE_ID,
REFERENCE_TYPE,
REFERENCE_HEADER_ID,
ITEM_REVISION,
UNIT_SELLING_PRICE,
UNIT_LIST_PRICE,
TAX_VALUE,
CONTEXT,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
GLOBAL_ATTRIBUTE_CATEGORY,
GLOBAL_ATTRIBUTE1,
GLOBAL_ATTRIBUTE2,
GLOBAL_ATTRIBUTE3,
GLOBAL_ATTRIBUTE4,
GLOBAL_ATTRIBUTE5,
GLOBAL_ATTRIBUTE6,
GLOBAL_ATTRIBUTE7,
GLOBAL_ATTRIBUTE8,
GLOBAL_ATTRIBUTE9,
GLOBAL_ATTRIBUTE10,
GLOBAL_ATTRIBUTE11,
GLOBAL_ATTRIBUTE12,
GLOBAL_ATTRIBUTE13,
GLOBAL_ATTRIBUTE14,
GLOBAL_ATTRIBUTE15,
GLOBAL_ATTRIBUTE16,
GLOBAL_ATTRIBUTE17,
GLOBAL_ATTRIBUTE18,
GLOBAL_ATTRIBUTE19,
GLOBAL_ATTRIBUTE20,
PRICING_CONTEXT,
PRICING_ATTRIBUTE1,
PRICING_ATTRIBUTE2,
PRICING_ATTRIBUTE3,
PRICING_ATTRIBUTE4,
PRICING_ATTRIBUTE5,
PRICING_ATTRIBUTE6,
PRICING_ATTRIBUTE7,
PRICING_ATTRIBUTE8,
PRICING_ATTRIBUTE9,
PRICING_ATTRIBUTE10,
INDUSTRY_CONTEXT,
INDUSTRY_ATTRIBUTE1,
INDUSTRY_ATTRIBUTE2,
INDUSTRY_ATTRIBUTE3,
INDUSTRY_ATTRIBUTE4,
INDUSTRY_ATTRIBUTE5,
INDUSTRY_ATTRIBUTE6,
INDUSTRY_ATTRIBUTE7,
INDUSTRY_ATTRIBUTE8,
INDUSTRY_ATTRIBUTE9,
INDUSTRY_ATTRIBUTE10,
INDUSTRY_ATTRIBUTE11,
INDUSTRY_ATTRIBUTE13,
INDUSTRY_ATTRIBUTE12,
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,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
REQUEST_ID,
CONFIGURATION_ID,
LINK_TO_LINE_ID,
COMPONENT_SEQUENCE_ID,
COMPONENT_CODE,
CONFIG_DISPLAY_SEQUENCE,
SORT_ORDER,
ITEM_TYPE_CODE,
OPTION_NUMBER,
OPTION_FLAG,
DEP_PLAN_REQUIRED_FLAG,
VISIBLE_DEMAND_FLAG,
LINE_CATEGORY_CODE,
ACTUAL_SHIPMENT_DATE,
CUSTOMER_TRX_LINE_ID,
RETURN_CONTEXT,
RETURN_ATTRIBUTE1,
RETURN_ATTRIBUTE2,
RETURN_ATTRIBUTE3,
RETURN_ATTRIBUTE4,
RETURN_ATTRIBUTE5,
RETURN_ATTRIBUTE6,
RETURN_ATTRIBUTE7,
RETURN_ATTRIBUTE8,
RETURN_ATTRIBUTE9,
RETURN_ATTRIBUTE10,
RETURN_ATTRIBUTE11,
RETURN_ATTRIBUTE12,
RETURN_ATTRIBUTE13,
RETURN_ATTRIBUTE14,
RETURN_ATTRIBUTE15,
INTMED_SHIP_TO_ORG_ID,
INTMED_SHIP_TO_CONTACT_ID,
ACTUAL_ARRIVAL_DATE,
ATO_LINE_ID,
AUTO_SELECTED_QUANTITY,
COMPONENT_NUMBER,
EARLIEST_ACCEPTABLE_DATE,
EXPLOSION_DATE,
LATEST_ACCEPTABLE_DATE,
MODEL_GROUP_NUMBER,
SCHEDULE_ARRIVAL_DATE,
SHIP_MODEL_COMPLETE_FLAG,
SCHEDULE_STATUS_CODE,
SOURCE_TYPE_CODE,
TOP_MODEL_LINE_ID,
BOOKED_FLAG,
CANCELLED_FLAG,
OPEN_FLAG,
LOAD_SEQ_NUMBER,
DELIVERY_ID,
SALESREP_ID,
RETURN_REASON_CODE,
WF_ACTIVITY_CODE,
WF_RESULT_CODE,
REASON_CODE,
HIST_COMMENTS,
HIST_TYPE_CODE,
HIST_CREATION_DATE,
HIST_CREATED_BY,
CUST_PRODUCTION_SEQ_NUM,
AUTHORIZED_TO_SHIP_FLAG,
SPLIT_FROM_LINE_ID,
OVER_SHIP_REASON_CODE,
OVER_SHIP_RESOLVED_FLAG,
ITEM_IDENTIFIER_TYPE,
ARRIVAL_SET_ID,
SHIP_SET_ID,
COMMITMENT_ID,
SHIPPING_INTERFACED_FLAG,
CREDIT_INVOICE_LINE_ID,
MFG_COMPONENT_SEQUENCE_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,
FULFILLMENT_METHOD_CODE,
SERVICE_REFERENCE_TYPE_CODE,
SERVICE_REFERENCE_LINE_ID,
SERVICE_REFERENCE_SYSTEM_ID,
INVOICE_INTERFACE_STATUS_CODE,
ORDERED_ITEM,
ORDERED_ITEM_ID,
SERVICE_NUMBER,
SERVICED_LINE_ID,
SERVICE_DURATION,
SERVICE_START_DATE,
RE_SOURCE_FLAG,
FLOW_STATUS_CODE,
SERVICE_END_DATE,
SERVICE_COTERMINATE_FLAG,
SHIPPABLE_FLAG,
ORDER_SOURCE_ID,
ORIG_SYS_SHIPMENT_REF,
CHANGE_SEQUENCE,
DROP_SHIP_FLAG,
CUSTOMER_LINE_NUMBER,
CUSTOMER_SHIPMENT_NUMBER,
CUSTOMER_ITEM_NET_PRICE,
CUSTOMER_PAYMENT_TERM_ID,
FIRST_ACK_DATE,
FIRST_ACK_CODE,
LAST_ACK_CODE,
LAST_ACK_DATE,
PLANNING_PRIORITY,
SERVICE_TXN_COMMENTS,
SERVICE_PERIOD,
UNIT_SELLING_PERCENT,
UNIT_LIST_PERCENT,
UNIT_PERCENT_BASE_PRICE,
MODEL_REMNANT_FLAG,
SERVICE_TXN_REASON_CODE,
CALCULATE_PRICE_FLAG,
ITEM_INPUT,
CUSTOMER_ITEM_ID,
CUSTOMER_ITEM_REVISION,
ITEM_ID,
INVOICE_COMPLETE_FLAG,
END_ITEM_UNIT_NUMBER,
FULFILLED_FLAG,
CONFIG_HEADER_ID,
CONFIG_REV_NBR,
SHIPPING_INSTRUCTIONS,
PACKING_INSTRUCTIONS,
INVOICED_QUANTITY,
REFERENCE_CUSTOMER_TRX_LINE_ID,
SPLIT_BY,
LINE_SET_ID,
REVENUE_AMOUNT,
FULFILLMENT_DATE,
PREFERRED_GRADE,
ORDERED_QUANTITY2,
ORDERED_QUANTITY_UOM2,
SHIPPED_QUANTITY2,
CANCELLED_QUANTITY2,
SHIPPING_QUANTITY2,
SHIPPING_QUANTITY_UOM2,
FULFILLED_QUANTITY2,
SUBINVENTORY,
RESPONSIBILITY_ID,
UNIT_LIST_PRICE_PER_PQTY,
UNIT_SELLING_PRICE_PER_PQTY,
LATEST_CANCELLED_QUANTITY,
PRICE_REQUEST_CODE,
LATE_DEMAND_PENALTY_FACTOR,
OVERRIDE_ATP_DATE_CODE,
ITEM_SUBSTITUTION_TYPE_CODE,
ORIGINAL_ITEM_IDENTIFIER_TYPE,
ORIGINAL_ORDERED_ITEM,
ORIGINAL_ORDERED_ITEM_ID,
ORIGINAL_INVENTORY_ITEM_ID,
ACCOUNTING_RULE_DURATION,
ATTRIBUTE16,
ATTRIBUTE17,
ATTRIBUTE18,
ATTRIBUTE19,
ATTRIBUTE20,
USER_ITEM_DESCRIPTION,
ITEM_RELATIONSHIP_TYPE,
BLANKET_NUMBER,
BLANKET_LINE_NUMBER,
BLANKET_VERSION_NUMBER,
VERSION_NUMBER,
SALES_DOCUMENT_TYPE_CODE,
AUDIT_FLAG,
VERSION_FLAG,
PHASE_CHANGE_FLAG,
TRANSACTION_PHASE_CODE,
SOURCE_DOCUMENT_VERSION_NUMBER,
--key Transaction Dates
ORDER_FIRMED_DATE,
CHARGE_PERIODICITY_CODE,
ACTUAL_FULFILLMENT_DATE,
-- 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
)
SELECT
LINE_ID,
ORG_ID,
HEADER_ID,
LINE_TYPE_ID,
LINE_NUMBER,
REQUEST_DATE,
PROMISE_DATE,
SCHEDULE_SHIP_DATE,
ORDER_QUANTITY_UOM,
PRICING_QUANTITY,
PRICING_QUANTITY_UOM,
CANCELLED_QUANTITY,
SHIPPED_QUANTITY,
ORDERED_QUANTITY,
FULFILLED_QUANTITY,
SHIPPING_QUANTITY,
SHIPPING_QUANTITY_UOM,
DELIVERY_LEAD_TIME,
TAX_EXEMPT_FLAG,
TAX_EXEMPT_NUMBER,
TAX_EXEMPT_REASON_CODE,
SHIP_FROM_ORG_ID,
SHIP_TO_ORG_ID,
INVOICE_TO_ORG_ID,
DELIVER_TO_ORG_ID,
SHIP_TO_CONTACT_ID,
DELIVER_TO_CONTACT_ID,
INVOICE_TO_CONTACT_ID,
SOLD_FROM_ORG_ID,
SOLD_TO_ORG_ID,
CUST_PO_NUMBER,
SHIP_TOLERANCE_ABOVE,
SHIP_TOLERANCE_BELOW,
DEMAND_BUCKET_TYPE_CODE,
VEH_CUS_ITEM_CUM_KEY_ID,
RLA_SCHEDULE_TYPE_CODE,
CUSTOMER_DOCK_CODE,
CUSTOMER_JOB,
CUSTOMER_PRODUCTION_LINE,
CUST_MODEL_SERIAL_NUMBER,
PROJECT_ID,
TASK_ID,
INVENTORY_ITEM_ID,
TAX_DATE,
TAX_CODE,
TAX_RATE,
DEMAND_CLASS_CODE,
PRICE_LIST_ID,
PRICING_DATE,
SHIPMENT_NUMBER,
AGREEMENT_ID,
SHIPMENT_PRIORITY_CODE,
SHIPPING_METHOD_CODE,
FREIGHT_CARRIER_CODE,
FREIGHT_TERMS_CODE,
FOB_POINT_CODE,
TAX_POINT_CODE,
PAYMENT_TERM_ID,
INVOICING_RULE_ID,
ACCOUNTING_RULE_ID,
SOURCE_DOCUMENT_TYPE_ID,
ORIG_SYS_DOCUMENT_REF,
SOURCE_DOCUMENT_ID,
ORIG_SYS_LINE_REF,
SOURCE_DOCUMENT_LINE_ID,
REFERENCE_LINE_ID,
REFERENCE_TYPE,
REFERENCE_HEADER_ID,
ITEM_REVISION,
UNIT_SELLING_PRICE,
UNIT_LIST_PRICE,
TAX_VALUE,
CONTEXT,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
GLOBAL_ATTRIBUTE_CATEGORY,
GLOBAL_ATTRIBUTE1,
GLOBAL_ATTRIBUTE2,
GLOBAL_ATTRIBUTE3,
GLOBAL_ATTRIBUTE4,
GLOBAL_ATTRIBUTE5,
GLOBAL_ATTRIBUTE6,
GLOBAL_ATTRIBUTE7,
GLOBAL_ATTRIBUTE8,
GLOBAL_ATTRIBUTE9,
GLOBAL_ATTRIBUTE10,
GLOBAL_ATTRIBUTE11,
GLOBAL_ATTRIBUTE12,
GLOBAL_ATTRIBUTE13,
GLOBAL_ATTRIBUTE14,
GLOBAL_ATTRIBUTE15,
GLOBAL_ATTRIBUTE16,
GLOBAL_ATTRIBUTE17,
GLOBAL_ATTRIBUTE18,
GLOBAL_ATTRIBUTE19,
GLOBAL_ATTRIBUTE20,
PRICING_CONTEXT,
PRICING_ATTRIBUTE1,
PRICING_ATTRIBUTE2,
PRICING_ATTRIBUTE3,
PRICING_ATTRIBUTE4,
PRICING_ATTRIBUTE5,
PRICING_ATTRIBUTE6,
PRICING_ATTRIBUTE7,
PRICING_ATTRIBUTE8,
PRICING_ATTRIBUTE9,
PRICING_ATTRIBUTE10,
INDUSTRY_CONTEXT,
INDUSTRY_ATTRIBUTE1,
INDUSTRY_ATTRIBUTE2,
INDUSTRY_ATTRIBUTE3,
INDUSTRY_ATTRIBUTE4,
INDUSTRY_ATTRIBUTE5,
INDUSTRY_ATTRIBUTE6,
INDUSTRY_ATTRIBUTE7,
INDUSTRY_ATTRIBUTE8,
INDUSTRY_ATTRIBUTE9,
INDUSTRY_ATTRIBUTE10,
INDUSTRY_ATTRIBUTE11,
INDUSTRY_ATTRIBUTE13,
INDUSTRY_ATTRIBUTE12,
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,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
REQUEST_ID,
CONFIGURATION_ID,
LINK_TO_LINE_ID,
COMPONENT_SEQUENCE_ID,
COMPONENT_CODE,
CONFIG_DISPLAY_SEQUENCE,
SORT_ORDER,
ITEM_TYPE_CODE,
OPTION_NUMBER,
OPTION_FLAG,
DEP_PLAN_REQUIRED_FLAG,
VISIBLE_DEMAND_FLAG,
LINE_CATEGORY_CODE,
ACTUAL_SHIPMENT_DATE,
CUSTOMER_TRX_LINE_ID,
RETURN_CONTEXT,
RETURN_ATTRIBUTE1,
RETURN_ATTRIBUTE2,
RETURN_ATTRIBUTE3,
RETURN_ATTRIBUTE4,
RETURN_ATTRIBUTE5,
RETURN_ATTRIBUTE6,
RETURN_ATTRIBUTE7,
RETURN_ATTRIBUTE8,
RETURN_ATTRIBUTE9,
RETURN_ATTRIBUTE10,
RETURN_ATTRIBUTE11,
RETURN_ATTRIBUTE12,
RETURN_ATTRIBUTE13,
RETURN_ATTRIBUTE14,
RETURN_ATTRIBUTE15,
INTMED_SHIP_TO_ORG_ID,
INTMED_SHIP_TO_CONTACT_ID,
ACTUAL_ARRIVAL_DATE,
ATO_LINE_ID,
AUTO_SELECTED_QUANTITY,
COMPONENT_NUMBER,
EARLIEST_ACCEPTABLE_DATE,
EXPLOSION_DATE,
LATEST_ACCEPTABLE_DATE,
MODEL_GROUP_NUMBER,
SCHEDULE_ARRIVAL_DATE,
SHIP_MODEL_COMPLETE_FLAG,
SCHEDULE_STATUS_CODE,
SOURCE_TYPE_CODE,
TOP_MODEL_LINE_ID,
BOOKED_FLAG,
CANCELLED_FLAG,
OPEN_FLAG,
NULL, --LOAD_SEQ_NUMBER,
NULL, --DELIVERY_ID,
SALESREP_ID,
RETURN_REASON_CODE,
NULL, --WF_ACTIVITY_CODE,
NULL, --WF_RESULT_CODE,
NULL, --REASON_CODE,
NULL, --HIST_COMMENTS,
'VERSIONING', --HIST_TYPE_CODE,
sysdate, --HIST_CREATION_DATE,
nvl(FND_GLOBAL.USER_ID, -1), -- HIST_CREATED_BY,
CUST_PRODUCTION_SEQ_NUM,
AUTHORIZED_TO_SHIP_FLAG,
SPLIT_FROM_LINE_ID,
OVER_SHIP_REASON_CODE,
OVER_SHIP_RESOLVED_FLAG,
ITEM_IDENTIFIER_TYPE,
ARRIVAL_SET_ID,
SHIP_SET_ID,
COMMITMENT_ID,
SHIPPING_INTERFACED_FLAG,
CREDIT_INVOICE_LINE_ID,
MFG_COMPONENT_SEQUENCE_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,
FULFILLMENT_METHOD_CODE,
SERVICE_REFERENCE_TYPE_CODE,
SERVICE_REFERENCE_LINE_ID,
SERVICE_REFERENCE_SYSTEM_ID,
INVOICE_INTERFACE_STATUS_CODE,
ORDERED_ITEM,
ORDERED_ITEM_ID,
SERVICE_NUMBER,
NULL, -- SERVICED_LINE_ID,
SERVICE_DURATION,
SERVICE_START_DATE,
RE_SOURCE_FLAG,
OE_VERSION_HISTORY_UTIL.get_status(line_id,flow_status_code),-- bug 9503990 FLOW_STATUS_CODE,
SERVICE_END_DATE,
SERVICE_COTERMINATE_FLAG,
SHIPPABLE_FLAG,
ORDER_SOURCE_ID,
ORIG_SYS_SHIPMENT_REF,
CHANGE_SEQUENCE,
DROP_SHIP_FLAG,
CUSTOMER_LINE_NUMBER,
CUSTOMER_SHIPMENT_NUMBER,
CUSTOMER_ITEM_NET_PRICE,
CUSTOMER_PAYMENT_TERM_ID,
FIRST_ACK_DATE,
FIRST_ACK_CODE,
LAST_ACK_CODE,
LAST_ACK_DATE,
PLANNING_PRIORITY,
SERVICE_TXN_COMMENTS,
SERVICE_PERIOD,
UNIT_SELLING_PERCENT,
UNIT_LIST_PERCENT,
UNIT_PERCENT_BASE_PRICE,
MODEL_REMNANT_FLAG,
SERVICE_TXN_REASON_CODE,
CALCULATE_PRICE_FLAG,
NULL, -- ITEM_INPUT,
NULL, -- CUSTOMER_ITEM_ID,
NULL, -- CUSTOMER_ITEM_REVISION,
NULL, -- ITEM_ID ?? check the source
NULL, -- INVOICE_COMPLETE_FLAG ?? check the source
END_ITEM_UNIT_NUMBER,
FULFILLED_FLAG,
CONFIG_HEADER_ID,
CONFIG_REV_NBR,
SHIPPING_INSTRUCTIONS,
PACKING_INSTRUCTIONS,
INVOICED_QUANTITY,
REFERENCE_CUSTOMER_TRX_LINE_ID,
SPLIT_BY,
LINE_SET_ID,
REVENUE_AMOUNT,
FULFILLMENT_DATE,
PREFERRED_GRADE,
ORDERED_QUANTITY2,
ORDERED_QUANTITY_UOM2,
SHIPPED_QUANTITY2,
CANCELLED_QUANTITY2,
SHIPPING_QUANTITY2,
SHIPPING_QUANTITY_UOM2,
FULFILLED_QUANTITY2,
SUBINVENTORY,
nvl(FND_GLOBAL.RESP_ID, -1), --RESPONSIBILITY_ID
UNIT_LIST_PRICE_PER_PQTY,
UNIT_SELLING_PRICE_PER_PQTY,
NULL, -- LATEST_CANCELLED_QUANTITY
PRICE_REQUEST_CODE,
LATE_DEMAND_PENALTY_FACTOR,
OVERRIDE_ATP_DATE_CODE,
ITEM_SUBSTITUTION_TYPE_CODE,
ORIGINAL_ITEM_IDENTIFIER_TYPE,
ORIGINAL_ORDERED_ITEM,
ORIGINAL_ORDERED_ITEM_ID,
ORIGINAL_INVENTORY_ITEM_ID,
ACCOUNTING_RULE_DURATION,
ATTRIBUTE16,
ATTRIBUTE17,
ATTRIBUTE18,
ATTRIBUTE19,
ATTRIBUTE20,
USER_ITEM_DESCRIPTION,
ITEM_RELATIONSHIP_TYPE,
BLANKET_NUMBER,
BLANKET_LINE_NUMBER,
BLANKET_VERSION_NUMBER,
l_version_number, -- VERSION_NUMBER,
SALES_DOCUMENT_TYPE_CODE,
'N', -- AUDIT_FLAG
l_version_flag, -- VERSION_FLAG
p_phase_change_flag, --PHASE_CHANGE_FLAG,
TRANSACTION_PHASE_CODE,
SOURCE_DOCUMENT_VERSION_NUMBER,
--key Transaction Dates
order_firmed_date,
CHARGE_PERIODICITY_CODE,
actual_fulfillment_date,
-- 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
FROM OE_ORDER_LINES_ALL a
WHERE header_id = p_header_id
AND NOT EXISTS (select b.line_id
FROM oe_order_lines_history b
WHERE a.line_id = b.line_id
AND a.header_id = b.header_id
AND b.version_number = l_version_number
AND b.version_flag = l_version_flag);
INSERT INTO OE_PRICE_ADJS_HISTORY(
PRICE_ADJUSTMENT_ID,
HEADER_ID,
HIST_CREATION_DATE,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
REQUEST_ID,
DISCOUNT_ID,
DISCOUNT_LINE_ID,
AUTOMATIC_FLAG,
PERCENT,
LINE_ID,
CONTEXT,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ORIG_SYS_DISCOUNT_REF,
CHANGE_SEQUENCE,
LIST_HEADER_ID,
LIST_LINE_ID,
LIST_LINE_TYPE_CODE,
MODIFIED_FROM,
MODIFIED_TO,
UPDATE_ALLOWED,
CHANGE_REASON_CODE,
CHANGE_REASON_TEXT,
MODIFIER_MECHANISM_TYPE_CODE,
UPDATED_FLAG,
APPLIED_FLAG,
OPERAND,
ARITHMETIC_OPERATOR,
COST_ID,
TAX_CODE,
TAX_EXEMPT_FLAG,
TAX_EXEMPT_NUMBER,
TAX_EXEMPT_REASON_CODE,
PARENT_ADJUSTMENT_ID,
INVOICED_FLAG,
ESTIMATED_FLAG,
INC_IN_SALES_PERFORMANCE,
SPLIT_ACTION_CODE,
ADJUSTED_AMOUNT,
PRICING_PHASE_ID,
CHARGE_TYPE_CODE,
CHARGE_SUBTYPE_CODE,
RANGE_BREAK_QUANTITY,
ACCRUAL_CONVERSION_RATE,
PRICING_GROUP_SEQUENCE,
ACCRUAL_FLAG,
LIST_LINE_NO,
SOURCE_SYSTEM_CODE,
BENEFIT_QTY,
BENEFIT_UOM_CODE,
PRINT_ON_INVOICE_FLAG,
EXPIRATION_DATE,
REBATE_TRANSACTION_TYPE_CODE,
REBATE_TRANSACTION_REFERENCE,
REBATE_PAYMENT_SYSTEM_CODE,
REDEEMED_DATE,
REDEEMED_FLAG,
MODIFIER_LEVEL_CODE,
PRICE_BREAK_TYPE_CODE,
SUBSTITUTION_ATTRIBUTE,
PRORATION_TYPE_CODE,
INCLUDE_ON_RETURNS_FLAG,
CREDIT_OR_CHARGE_FLAG,
AC_CONTEXT,
AC_ATTRIBUTE1,
AC_ATTRIBUTE2,
AC_ATTRIBUTE3,
AC_ATTRIBUTE4,
AC_ATTRIBUTE5,
AC_ATTRIBUTE6,
AC_ATTRIBUTE7,
AC_ATTRIBUTE8,
AC_ATTRIBUTE9,
AC_ATTRIBUTE10,
AC_ATTRIBUTE11,
AC_ATTRIBUTE12,
AC_ATTRIBUTE13,
AC_ATTRIBUTE14,
AC_ATTRIBUTE15,
LOCK_CONTROL,
HIST_TYPE_CODE,
HIST_CREATED_BY,
RESPONSIBILITY_ID,
VERSION_NUMBER,
AUDIT_FLAG,
VERSION_FLAG,
PHASE_CHANGE_FLAG
)
SELECT
PRICE_ADJUSTMENT_ID,
HEADER_ID,
sysdate,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
REQUEST_ID,
DISCOUNT_ID,
DISCOUNT_LINE_ID,
AUTOMATIC_FLAG,
PERCENT,
LINE_ID,
CONTEXT,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ORIG_SYS_DISCOUNT_REF,
CHANGE_SEQUENCE,
LIST_HEADER_ID,
LIST_LINE_ID,
LIST_LINE_TYPE_CODE,
MODIFIED_FROM,
MODIFIED_TO,
UPDATE_ALLOWED,
CHANGE_REASON_CODE,
CHANGE_REASON_TEXT,
MODIFIER_MECHANISM_TYPE_CODE,
UPDATED_FLAG,
APPLIED_FLAG,
OPERAND,
ARITHMETIC_OPERATOR,
COST_ID,
TAX_CODE,
TAX_EXEMPT_FLAG,
TAX_EXEMPT_NUMBER,
TAX_EXEMPT_REASON_CODE,
PARENT_ADJUSTMENT_ID,
INVOICED_FLAG,
ESTIMATED_FLAG,
INC_IN_SALES_PERFORMANCE,
SPLIT_ACTION_CODE,
ADJUSTED_AMOUNT,
PRICING_PHASE_ID,
CHARGE_TYPE_CODE,
CHARGE_SUBTYPE_CODE,
RANGE_BREAK_QUANTITY,
ACCRUAL_CONVERSION_RATE,
PRICING_GROUP_SEQUENCE,
ACCRUAL_FLAG,
LIST_LINE_NO,
SOURCE_SYSTEM_CODE,
BENEFIT_QTY,
BENEFIT_UOM_CODE,
PRINT_ON_INVOICE_FLAG,
EXPIRATION_DATE,
REBATE_TRANSACTION_TYPE_CODE,
REBATE_TRANSACTION_REFERENCE,
REBATE_PAYMENT_SYSTEM_CODE,
REDEEMED_DATE,
REDEEMED_FLAG,
MODIFIER_LEVEL_CODE,
PRICE_BREAK_TYPE_CODE,
SUBSTITUTION_ATTRIBUTE,
PRORATION_TYPE_CODE,
INCLUDE_ON_RETURNS_FLAG,
CREDIT_OR_CHARGE_FLAG,
AC_CONTEXT,
AC_ATTRIBUTE1,
AC_ATTRIBUTE2,
AC_ATTRIBUTE3,
AC_ATTRIBUTE4,
AC_ATTRIBUTE5,
AC_ATTRIBUTE6,
AC_ATTRIBUTE7,
AC_ATTRIBUTE8,
AC_ATTRIBUTE9,
AC_ATTRIBUTE10,
AC_ATTRIBUTE11,
AC_ATTRIBUTE12,
AC_ATTRIBUTE13,
AC_ATTRIBUTE14,
AC_ATTRIBUTE15,
LOCK_CONTROL,
NULL, --HIST_TYPE_CODE,
nvl(FND_GLOBAL.USER_ID, -1), --HIST_CREATED_BY,
nvl(FND_GLOBAL.RESP_ID, -1), --RESPONSIBILITY_ID,
l_version_number, --VERSION_NUMBER,
'N', --AUDIT_FLAG,
l_version_flag, --VERSION_FLAG,
p_phase_change_flag --PHASE_CHANGE_FLAG
FROM OE_PRICE_ADJUSTMENTS a
WHERE a.header_id = p_header_id
AND NOT EXISTS ( SELECT price_adjustment_id
FROM OE_PRICE_ADJS_HISTORY b
WHERE b.price_adjustment_id = a.price_adjustment_id
AND a.header_id = b.header_id
AND b.version_number = l_version_number
AND b.version_flag = l_version_flag);
INSERT INTO OE_SALES_CREDIT_HISTORY (
SALES_CREDIT_ID,
HEADER_ID,
HIST_CREATION_DATE,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
SALESREP_ID,
PERCENT,
LINE_ID,
CONTEXT,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
DW_UPDATE_ADVICE_FLAG,
WH_UPDATE_DATE,
ORIG_SYS_CREDIT_REF,
SALES_CREDIT_TYPE_ID,
LOCK_CONTROL,
REASON_CODE,
HIST_COMMENTS,
HIST_TYPE_CODE,
HIST_CREATED_BY,
RESPONSIBILITY_ID,
VERSION_NUMBER,
AUDIT_FLAG,
VERSION_FLAG,
PHASE_CHANGE_FLAG
)
SELECT
SALES_CREDIT_ID,
HEADER_ID,
sysdate,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
SALESREP_ID,
PERCENT,
LINE_ID,
CONTEXT,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
DW_UPDATE_ADVICE_FLAG,
WH_UPDATE_DATE,
ORIG_SYS_CREDIT_REF,
SALES_CREDIT_TYPE_ID,
LOCK_CONTROL,
NULL, --REASON_CODE,
NULL, --HIST_COMMENTS,
NULL, --HIST_TYPE_CODE,
nvl(FND_GLOBAL.USER_ID, -1), --HIST_CREATED_BY,
nvl(FND_GLOBAL.RESP_ID, -1), --RESPONSIBILITY_ID,
l_version_number, --VERSION_NUMBER,
'N', --AUDIT_FLAG,
l_version_flag, --VERSION_FLAG,
p_phase_change_flag --PHASE_CHANGE_FLAG,
FROM oe_sales_credits a
WHERE a.header_id = p_header_id
AND NOT EXISTS ( SELECT b.SALES_CREDIT_ID
FROM OE_SALES_CREDIT_HISTORY b
WHERE b.SALES_CREDIT_ID = a.SALES_CREDIT_ID
AND a.header_id = b.header_id
AND b.VERSION_NUMBER = l_version_number
AND b.version_flag = l_version_flag);
SELECT h.version_number INTO l_current_version_number
FROM OE_ORDER_HEADERS_ALL h, OE_PRICE_ADJUSTMENTS p
WHERE h.header_id = p.header_id
AND p.price_adjustment_id = p_price_adjustment_id;
SELECT h.version_number INTO l_current_version_number
FROM OE_ORDER_HEADERS_ALL h, OE_PRICE_ADJS_HISTORY p
WHERE h.header_id = p.header_id
AND p.price_adjustment_id = p_price_adjustment_id
AND rownum = 1;
SELECT h.version_number INTO l_current_version_number
FROM OE_ORDER_HEADERS_ALL h, OE_SALES_CREDITS s
WHERE h.header_id = s.header_id
AND s.sales_credit_id = p_sales_credit_id;
SELECT h.version_number INTO l_current_version_number
FROM OE_ORDER_HEADERS_ALL h, OE_SALES_CREDIT_HISTORY s
WHERE h.header_id = s.header_id
AND s.sales_credit_id = p_sales_credit_id
AND rownum = 1;
SELECT h.version_number INTO l_current_version_number
FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_ALL l
WHERE h.header_id = l.header_id
AND l.line_id = p_line_id;
SELECT h.version_number INTO l_current_version_number
FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_HISTORY l
WHERE h.header_id = l.header_id
AND l.line_id = p_line_id
AND rownum = 1;
SELECT version_number INTO l_current_version_number
FROM OE_ORDER_HEADERS_ALL WHERE header_id = p_header_id;
SELECT ACCOUNTING_RULE_ID
, ACCOUNTING_RULE_DURATION
, AGREEMENT_ID
, ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16 --For bug 2184255
, 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
, NULL --DEFAULT_FULFILLMENT_SET
, NULL --FULFILLMENT_SET_NAME
, NULL --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
, NULL --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
--key Transaction Dates
, order_firmed_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 --For bug 2184255
, 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
--key Transaction Dates
, x_header_rec.order_firmed_date
FROM OE_ORDER_HEADER_HISTORY
WHERE HEADER_ID = p_header_id
AND VERSION_NUMBER = l_version_number
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
, AUTOMATIC_FLAG
, CONTEXT
, CREATED_BY
, CREATION_DATE
, DISCOUNT_ID
, DISCOUNT_LINE_ID
, HEADER_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LINE_ID
, PERCENT
, PRICE_ADJUSTMENT_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, LIST_HEADER_ID
, LIST_LINE_ID
, LIST_LINE_TYPE_CODE
, MODIFIER_MECHANISM_TYPE_CODE
, MODIFIED_FROM
, MODIFIED_TO
, UPDATED_FLAG
, UPDATE_ALLOWED
, APPLIED_FLAG
, CHANGE_REASON_CODE
, CHANGE_REASON_TEXT
, operand
, arithmetic_operator
, COST_ID
, TAX_CODE
, TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE
, PARENT_ADJUSTMENT_ID
, INVOICED_FLAG
, ESTIMATED_FLAG
, INC_IN_SALES_PERFORMANCE
, SPLIT_ACTION_CODE
, ADJUSTED_AMOUNT
, PRICING_PHASE_ID
, CHARGE_TYPE_CODE
, CHARGE_SUBTYPE_CODE
, list_line_no
, source_system_code
, benefit_qty
, benefit_uom_code
, print_on_invoice_flag
, expiration_date
, rebate_transaction_type_code
, rebate_transaction_reference
, rebate_payment_system_code
, redeemed_date
, redeemed_flag
, accrual_flag
, range_break_quantity
, accrual_conversion_rate
, pricing_group_sequence
, modifier_level_code
, price_break_type_code
, substitution_attribute
, proration_type_code
, CREDIT_OR_CHARGE_FLAG
, INCLUDE_ON_RETURNS_FLAG
, AC_ATTRIBUTE1
, AC_ATTRIBUTE10
, AC_ATTRIBUTE11
, AC_ATTRIBUTE12
, AC_ATTRIBUTE13
, AC_ATTRIBUTE14
, AC_ATTRIBUTE15
, AC_ATTRIBUTE2
, AC_ATTRIBUTE3
, AC_ATTRIBUTE4
, AC_ATTRIBUTE5
, AC_ATTRIBUTE6
, AC_ATTRIBUTE7
, AC_ATTRIBUTE8
, AC_ATTRIBUTE9
, AC_CONTEXT
--uom begin
-- , OPERAND_PER_PQTY
-- , ADJUSTED_AMOUNT_PER_PQTY
--uom end
, LOCK_CONTROL
FROM OE_PRICE_ADJS_HISTORY
WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id
AND VERSION_NUMBER = l_version_number
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
, AUTOMATIC_FLAG
, CONTEXT
, CREATED_BY
, CREATION_DATE
, DISCOUNT_ID
, DISCOUNT_LINE_ID
, HEADER_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LINE_ID
, PERCENT
, PRICE_ADJUSTMENT_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, LIST_HEADER_ID
, LIST_LINE_ID
, LIST_LINE_TYPE_CODE
, MODIFIER_MECHANISM_TYPE_CODE
, MODIFIED_FROM
, MODIFIED_TO
, UPDATED_FLAG
, UPDATE_ALLOWED
, APPLIED_FLAG
, CHANGE_REASON_CODE
, CHANGE_REASON_TEXT
, operand
, arithmetic_operator
, COST_ID
, TAX_CODE
, TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE
, PARENT_ADJUSTMENT_ID
, INVOICED_FLAG
, ESTIMATED_FLAG
, INC_IN_SALES_PERFORMANCE
, SPLIT_ACTION_CODE
, ADJUSTED_AMOUNT
, PRICING_PHASE_ID
, CHARGE_TYPE_CODE
, CHARGE_SUBTYPE_CODE
, list_line_no
, source_system_code
, benefit_qty
, benefit_uom_code
, print_on_invoice_flag
, expiration_date
, rebate_transaction_type_code
, rebate_transaction_reference
, rebate_payment_system_code
, redeemed_date
, redeemed_flag
, accrual_flag
, range_break_quantity
, accrual_conversion_rate
, pricing_group_sequence
, modifier_level_code
, price_break_type_code
, substitution_attribute
, proration_type_code
, CREDIT_OR_CHARGE_FLAG
, INCLUDE_ON_RETURNS_FLAG
, AC_ATTRIBUTE1
, AC_ATTRIBUTE10
, AC_ATTRIBUTE11
, AC_ATTRIBUTE12
, AC_ATTRIBUTE13
, AC_ATTRIBUTE14
, AC_ATTRIBUTE15
, AC_ATTRIBUTE2
, AC_ATTRIBUTE3
, AC_ATTRIBUTE4
, AC_ATTRIBUTE5
, AC_ATTRIBUTE6
, AC_ATTRIBUTE7
, AC_ATTRIBUTE8
, AC_ATTRIBUTE9
, AC_CONTEXT
--uom begin
-- , OPERAND_PER_PQTY
-- , ADJUSTED_AMOUNT_PER_PQTY
--uom end
, LOCK_CONTROL
FROM OE_PRICE_ADJS_HISTORY
WHERE HEADER_ID = p_header_id AND LINE_ID IS NULL
AND VERSION_NUMBER = l_version_number
AND (PHASE_CHANGE_FLAG = p_phase_change_flag
OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'
AND VERSION_FLAG = 'Y'));
x_Header_Adj_tbl(l_count).last_updated_by := l_rec.LAST_UPDATED_BY;
x_Header_Adj_tbl(l_count).last_update_date := l_rec.LAST_UPDATE_DATE;
x_Header_Adj_tbl(l_count).last_update_login := l_rec.LAST_UPDATE_LOGIN;
x_Header_Adj_tbl(l_count).program_update_date := l_rec.PROGRAM_UPDATE_DATE;
x_Header_Adj_tbl(l_count).updated_flag := l_rec.updated_flag;
x_Header_Adj_tbl(l_count).update_allowed := l_rec.update_allowed;
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
--SG {
-- , SALES_GROUP_ID
-- , SALES_GROUP_UPDATED
--SG }
, LOCK_CONTROL
FROM OE_SALES_CREDIT_HISTORY
WHERE SALES_CREDIT_ID = p_sales_credit_id
AND VERSION_NUMBER = l_version_number
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
--SG {
-- , SALES_GROUP_ID
-- , SALES_GROUP_UPDATED
--SG }
, LOCK_CONTROL
FROM OE_SALES_CREDIT_HISTORY
WHERE HEADER_ID = p_header_id
AND LINE_ID IS NULL
AND VERSION_NUMBER = l_version_number
AND (PHASE_CHANGE_FLAG = p_phase_change_flag
OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'
AND VERSION_FLAG = 'Y'));
x_header_scredit_tbl(l_count).dw_update_advice_flag := l_rec.DW_UPDATE_ADVICE_FLAG;
x_header_scredit_tbl(l_count).last_updated_by := l_rec.LAST_UPDATED_BY;
x_header_scredit_tbl(l_count).last_update_date := l_rec.LAST_UPDATE_DATE;
x_header_scredit_tbl(l_count).last_update_login := l_rec.LAST_UPDATE_LOGIN;
x_header_scredit_tbl(l_count).wh_update_date := l_rec.WH_UPDATE_DATE;
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 --For bug 2184255
, 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 --OPM 02/JUN/00
, ORDER_QUANTITY_UOM
, ORDERED_QUANTITY_UOM2 --OPM 02/JUN/00
, 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 --OPM 02/JUN/00
, PRICE_LIST_ID
, PRICE_REQUEST_CODE --PROMOTIONS MAY/01
, 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 -- OPM B1661023 04/02/01
, SHIPPING_METHOD_CODE
, SHIPPING_QUANTITY
, SHIPPING_QUANTITY2 -- OPM B1661023 04/02/01
, 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 -- aksingh
-- , 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
--MRG B
-- , UNIT_COST
--MRG E
-- , LOCK_CONTROL
, NVL(OPTION_NUMBER, -1) OPN
, NVL(COMPONENT_NUMBER, -1) CPN
, NVL(SERVICE_NUMBER, -1) SVN
, CHANGE_SEQUENCE
--key Transaction Dates
, order_firmed_date
, actual_fulfillment_date
-- 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
FROM OE_ORDER_LINES_HISTORY
WHERE LINE_ID = p_line_id
AND VERSION_NUMBER = l_version_number
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 --For bug 2184255
, 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 --OPM 02/JUN/00
, ORDER_QUANTITY_UOM
, ORDERED_QUANTITY_UOM2 --OPM 02/JUN/00
, 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 --OPM 02/JUN/00
, PRICE_LIST_ID
, PRICE_REQUEST_CODE --PROMOTIONS SEP/01
, 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 -- OPM B1661023 04/02/01
, SHIPPING_METHOD_CODE
, SHIPPING_QUANTITY
, SHIPPING_QUANTITY2 -- OPM B1661023 04/02/01
, 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 -- aksingh
-- , 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
--MRG B
-- , UNIT_COST
--MRG E
-- , LOCK_CONTROL
, NVL(OPTION_NUMBER, -1) OPN
, NVL(COMPONENT_NUMBER, -1) CPN
, NVL(SERVICE_NUMBER, -1) SVN
, CHANGE_SEQUENCE
--key Transaction Dates
, order_firmed_date
, actual_fulfillment_date
-- 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
FROM OE_ORDER_LINES_HISTORY
WHERE HEADER_ID = p_header_id
AND VERSION_NUMBER = l_version_number
AND (PHASE_CHANGE_FLAG = p_phase_change_flag
OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'
AND VERSION_FLAG = 'Y'))
ORDER BY LINE_NUMBER,SHIPMENT_NUMBER,OPN, CPN, SVN;
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 --For bug 2184255
, 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 --OPM 02/JUN/00
, ORDER_QUANTITY_UOM
, ORDERED_QUANTITY_UOM2 --OPM 02/JUN/00
, 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 --OPM 02/JUN/00
, PRICE_LIST_ID
, PRICE_REQUEST_CODE --PROMOTIONS SEP/01
, 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 -- OPM B1661023 04/02/01
, SHIPPING_METHOD_CODE
, SHIPPING_QUANTITY
, SHIPPING_QUANTITY2 -- OPM B1661023 04/02/01
, 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 -- aksingh
-- , 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
--MRG B
-- , UNIT_COST
--MRG E
-- , LOCK_CONTROL
, NVL(OPTION_NUMBER, -1) OPN
, NVL(COMPONENT_NUMBER, -1) CPN
, NVL(SERVICE_NUMBER, -1) SVN
, CHANGE_SEQUENCE
--key Transaction Dates
, order_firmed_date
, actual_fulfillment_date
-- 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
FROM OE_ORDER_LINES_HISTORY
WHERE LINE_SET_ID = p_line_set_id
AND VERSION_NUMBER = l_version_number
AND (PHASE_CHANGE_FLAG = p_phase_change_flag
OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'
AND VERSION_FLAG = 'Y'))
ORDER BY LINE_NUMBER,SHIPMENT_NUMBER,OPN, CPN, SVN;
x_line_tbl(l_count).auto_selected_quantity := l_rec.AUTO_SELECTED_QUANTITY;
x_line_tbl(l_count).last_updated_by := l_rec.LAST_UPDATED_BY;
x_line_tbl(l_count).last_update_date := l_rec.LAST_UPDATE_DATE;
x_line_tbl(l_count).last_update_login := l_rec.LAST_UPDATE_LOGIN;
x_line_tbl(l_count).program_update_date := l_rec.PROGRAM_UPDATE_DATE;
SELECT ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, AUTOMATIC_FLAG
, CONTEXT
, CREATED_BY
, CREATION_DATE
, DISCOUNT_ID
, DISCOUNT_LINE_ID
, HEADER_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LINE_ID
, PERCENT
, PRICE_ADJUSTMENT_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, LIST_HEADER_ID
, LIST_LINE_ID
, LIST_LINE_TYPE_CODE
, MODIFIER_MECHANISM_TYPE_CODE
, MODIFIED_FROM
, MODIFIED_TO
, UPDATED_FLAG
, UPDATE_ALLOWED
, APPLIED_FLAG
, CHANGE_REASON_CODE
, CHANGE_REASON_TEXT
, operand
, Arithmetic_operator
, COST_ID
, TAX_CODE
, TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE
, PARENT_ADJUSTMENT_ID
, INVOICED_FLAG
, ESTIMATED_FLAG
, INC_IN_SALES_PERFORMANCE
, SPLIT_ACTION_CODE
, ADJUSTED_AMOUNT
, PRICING_PHASE_ID
, CHARGE_TYPE_CODE
, CHARGE_SUBTYPE_CODE
, list_line_no
, source_system_code
, benefit_qty
, benefit_uom_code
, print_on_invoice_flag
, expiration_date
, rebate_transaction_type_code
, rebate_transaction_reference
, rebate_payment_system_code
, redeemed_date
, redeemed_flag
, accrual_flag
, range_break_quantity
, accrual_conversion_rate
, pricing_group_sequence
, modifier_level_code
, price_break_type_code
, substitution_attribute
, proration_type_code
, credit_or_charge_flag
, include_on_returns_flag
, AC_ATTRIBUTE1
, AC_ATTRIBUTE10
, AC_ATTRIBUTE11
, AC_ATTRIBUTE12
, AC_ATTRIBUTE13
, AC_ATTRIBUTE14
, AC_ATTRIBUTE15
, AC_ATTRIBUTE2
, AC_ATTRIBUTE3
, AC_ATTRIBUTE4
, AC_ATTRIBUTE5
, AC_ATTRIBUTE6
, AC_ATTRIBUTE7
, AC_ATTRIBUTE8
, AC_ATTRIBUTE9
, AC_CONTEXT
--uom begin
-- , OPERAND_PER_PQTY
-- , ADJUSTED_AMOUNT_PER_PQTY
--uom end
, LOCK_CONTROL
-- eBTax changes
, TAX_RATE_ID
FROM OE_PRICE_ADJS_HISTORY
WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id
and version_number = l_version_number
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
, AUTOMATIC_FLAG
, CONTEXT
, CREATED_BY
, CREATION_DATE
, DISCOUNT_ID
, DISCOUNT_LINE_ID
, HEADER_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LINE_ID
, PERCENT
, PRICE_ADJUSTMENT_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, LIST_HEADER_ID
, LIST_LINE_ID
, LIST_LINE_TYPE_CODE
, MODIFIER_MECHANISM_TYPE_CODE
, MODIFIED_FROM
, MODIFIED_TO
, UPDATED_FLAG
, UPDATE_ALLOWED
, APPLIED_FLAG
, CHANGE_REASON_CODE
, CHANGE_REASON_TEXT
, operand
, Arithmetic_operator
, COST_ID
, TAX_CODE
, TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE
, PARENT_ADJUSTMENT_ID
, INVOICED_FLAG
, ESTIMATED_FLAG
, INC_IN_SALES_PERFORMANCE
, SPLIT_ACTION_CODE
, ADJUSTED_AMOUNT
, PRICING_PHASE_ID
, CHARGE_TYPE_CODE
, CHARGE_SUBTYPE_CODE
, list_line_no
, source_system_code
, benefit_qty
, benefit_uom_code
, print_on_invoice_flag
, expiration_date
, rebate_transaction_type_code
, rebate_transaction_reference
, rebate_payment_system_code
, redeemed_date
, redeemed_flag
, accrual_flag
, range_break_quantity
, accrual_conversion_rate
, pricing_group_sequence
, modifier_level_code
, price_break_type_code
, substitution_attribute
, proration_type_code
, credit_or_charge_flag
, include_on_returns_flag
, AC_ATTRIBUTE1
, AC_ATTRIBUTE10
, AC_ATTRIBUTE11
, AC_ATTRIBUTE12
, AC_ATTRIBUTE13
, AC_ATTRIBUTE14
, AC_ATTRIBUTE15
, AC_ATTRIBUTE2
, AC_ATTRIBUTE3
, AC_ATTRIBUTE4
, AC_ATTRIBUTE5
, AC_ATTRIBUTE6
, AC_ATTRIBUTE7
, AC_ATTRIBUTE8
, AC_ATTRIBUTE9
, AC_CONTEXT
--uom begin
-- , OPERAND_PER_PQTY
-- , ADJUSTED_AMOUNT_PER_PQTY
--uom end
, LOCK_CONTROL
-- eBTax changes
, TAX_RATE_ID
FROM OE_PRICE_ADJS_HISTORY
WHERE line_id = p_line_id
and version_number = l_version_number
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
, AUTOMATIC_FLAG
, CONTEXT
, CREATED_BY
, CREATION_DATE
, DISCOUNT_ID
, DISCOUNT_LINE_ID
, HEADER_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LINE_ID
, PERCENT
, PRICE_ADJUSTMENT_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, LIST_HEADER_ID
, LIST_LINE_ID
, LIST_LINE_TYPE_CODE
, MODIFIER_MECHANISM_TYPE_CODE
, MODIFIED_FROM
, MODIFIED_TO
, UPDATED_FLAG
, UPDATE_ALLOWED
, APPLIED_FLAG
, CHANGE_REASON_CODE
, CHANGE_REASON_TEXT
, operand
, Arithmetic_operator
, COST_ID
, TAX_CODE
, TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE
, PARENT_ADJUSTMENT_ID
, INVOICED_FLAG
, ESTIMATED_FLAG
, INC_IN_SALES_PERFORMANCE
, SPLIT_ACTION_CODE
, ADJUSTED_AMOUNT
, PRICING_PHASE_ID
, CHARGE_TYPE_CODE
, CHARGE_SUBTYPE_CODE
, list_line_no
, source_system_code
, benefit_qty
, benefit_uom_code
, print_on_invoice_flag
, expiration_date
, rebate_transaction_type_code
, rebate_transaction_reference
, rebate_payment_system_code
, redeemed_date
, redeemed_flag
, accrual_flag
, range_break_quantity
, accrual_conversion_rate
, pricing_group_sequence
, modifier_level_code
, price_break_type_code
, substitution_attribute
, proration_type_code
, credit_or_charge_flag
, include_on_returns_flag
, AC_ATTRIBUTE1
, AC_ATTRIBUTE10
, AC_ATTRIBUTE11
, AC_ATTRIBUTE12
, AC_ATTRIBUTE13
, AC_ATTRIBUTE14
, AC_ATTRIBUTE15
, AC_ATTRIBUTE2
, AC_ATTRIBUTE3
, AC_ATTRIBUTE4
, AC_ATTRIBUTE5
, AC_ATTRIBUTE6
, AC_ATTRIBUTE7
, AC_ATTRIBUTE8
, AC_ATTRIBUTE9
, AC_CONTEXT
--uom begin
-- , OPERAND_PER_PQTY
-- , ADJUSTED_AMOUNT_PER_PQTY
--uom end
, LOCK_CONTROL
-- eBTax changes
, TAX_RATE_ID
FROM OE_PRICE_ADJS_HISTORY
WHERE header_id = p_header_id
and line_id is not null
and version_number = l_version_number
AND (PHASE_CHANGE_FLAG = p_phase_change_flag
OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'
AND VERSION_FLAG = 'Y'));
x_Line_Adj_tbl(l_count).last_updated_by := l_rec.LAST_UPDATED_BY;
x_Line_Adj_tbl(l_count).last_update_date := l_rec.LAST_UPDATE_DATE;
x_Line_Adj_tbl(l_count).last_update_login := l_rec.LAST_UPDATE_LOGIN;
x_Line_Adj_tbl(l_count).program_update_date := l_rec.PROGRAM_UPDATE_DATE;
x_Line_Adj_tbl(l_count).updated_flag := l_rec.updated_flag;
x_Line_Adj_tbl(l_count).update_allowed := l_rec.update_allowed;
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
, LOCK_CONTROL
FROM OE_SALES_CREDIT_HISTORY
WHERE SALES_CREDIT_ID = p_sales_credit_id
AND VERSION_NUMBER = l_version_number
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
, LOCK_CONTROL
FROM OE_SALES_CREDIT_HISTORY
WHERE LINE_ID = p_line_id
AND VERSION_NUMBER = l_version_number
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
, LOCK_CONTROL
FROM OE_SALES_CREDIT_HISTORY
WHERE HEADER_ID = p_header_id
AND LINE_ID IS NOT NULL
AND VERSION_NUMBER = l_version_number
AND (PHASE_CHANGE_FLAG = p_phase_change_flag
OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'
AND VERSION_FLAG = 'Y'));
x_line_scredit_tbl(l_count).dw_update_advice_flag := l_rec.DW_UPDATE_ADVICE_FLAG;
x_line_scredit_tbl(l_count).last_updated_by := l_rec.LAST_UPDATED_BY;
x_line_scredit_tbl(l_count).last_update_date := l_rec.LAST_UPDATE_DATE;
x_line_scredit_tbl(l_count).last_update_login := l_rec.LAST_UPDATE_LOGIN;
x_line_scredit_tbl(l_count).wh_update_date := l_rec.WH_UPDATE_DATE;