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

APPS.ASO_ORDER_FEEDBACK_UPDATE_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 108


PROCEDURE UPDATE_NOTICE
(
 p_api_version                   IN  NUMBER,
 p_init_msg_list                 IN  VARCHAR2 :=  FND_API.G_FALSE,
 p_commit                        IN  VARCHAR2 := FND_API.G_FALSE,
 x_return_status                 OUT NOCOPY /* file.sql.39 change */   VARCHAR2,
 x_msg_count                     OUT NOCOPY /* file.sql.39 change */   NUMBER,
 x_msg_data                      OUT NOCOPY /* file.sql.39 change */   VARCHAR2,
 p_header_rec                    IN  OE_Order_PUB.Header_Rec_Type :=
                                        OE_Order_PUB.G_MISS_HEADER_REC,
 p_old_header_rec                IN  OE_Order_PUB.Header_Rec_Type :=
                                        OE_Order_PUB.G_MISS_HEADER_REC,
 p_Header_Adj_tbl                IN  OE_Order_PUB.Header_Adj_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
 p_old_Header_Adj_tbl            IN  OE_Order_PUB.Header_Adj_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
 p_Header_price_Att_tbl          IN  OE_Order_PUB.Header_Price_Att_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
 p_old_Header_Price_Att_tbl      IN  OE_Order_PUB.Header_Price_Att_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
 p_Header_Adj_Att_tbl            IN  OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
 p_old_Header_Adj_Att_tbl        IN  OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
 p_Header_Adj_Assoc_tbl          IN  OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
 p_old_Header_Adj_Assoc_tbl      IN  OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
 p_Header_Scredit_tbl            IN  OE_Order_PUB.Header_Scredit_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
 p_old_Header_Scredit_tbl        IN  OE_Order_PUB.Header_Scredit_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
 p_line_tbl                      IN  OE_Order_PUB.Line_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_LINE_TBL,
 p_old_line_tbl                  IN  OE_Order_PUB.Line_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_LINE_TBL,
 p_Line_Adj_tbl                  IN  OE_Order_PUB.Line_Adj_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
 p_old_Line_Adj_tbl              IN  OE_Order_PUB.Line_Adj_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
 p_Line_price_Att_tbl            IN  OE_Order_PUB.Line_Price_Att_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
 p_old_Line_Price_Att_tbl        IN  OE_Order_PUB.Line_Price_Att_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
 p_Line_Adj_Att_tbl              IN  OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
 p_old_Line_Adj_Att_tbl          IN  OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
 p_Line_Adj_Assoc_tbl            IN  OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
 p_old_Line_Adj_Assoc_tbl        IN  OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
 p_Line_Scredit_tbl              IN  OE_Order_PUB.Line_Scredit_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
 p_old_Line_Scredit_tbl          IN  OE_Order_PUB.Line_Scredit_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
 p_Lot_Serial_tbl                IN  OE_Order_PUB.Lot_Serial_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
 p_old_Lot_Serial_tbl            IN  OE_Order_PUB.Lot_Serial_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
 p_action_request_tbl            IN  OE_Order_PUB.Request_Tbl_Type   :=
                                        OE_Order_PUB.G_MISS_REQUEST_TBL,
 p_app_short_name                IN  VARCHAR2         := NULL,
 p_queue_type                    IN  VARCHAR2       := 'OF_QUEUE'
)
IS
l_api_name	CONSTANT		VARCHAR2(30)	:= 'UPDATE_NOTICE';

Line: 208


	SAVEPOINT	UPDATE_NOTICE_PVT;

Line: 331


		ROLLBACK TO  UPDATE_NOTICE_PVT;

Line: 338


		ROLLBACK TO  UPDATE_NOTICE_PVT;

Line: 345


		ROLLBACK TO UPDATE_NOTICE_PVT;

Line: 354


END UPDATE_NOTICE;

Line: 439


, p_header_rec.last_updated_by
, p_header_rec.last_update_date
, p_header_rec.last_update_login
, p_header_rec.latest_schedule_limit
, p_header_rec.open_flag
, p_header_rec.order_category_code
, p_header_rec.ordered_date
, p_header_rec.order_date_type_code
, p_header_rec.order_number
, p_header_rec.order_source_id
, p_header_rec.order_type_id
, p_header_rec.org_id
, p_header_rec.orig_sys_document_ref
, p_header_rec.partial_shipments_allowed
, p_header_rec.payment_term_id
, p_header_rec.price_list_id
, p_header_rec.pricing_date
, p_header_rec.program_application_id
, p_header_rec.program_id
, p_header_rec.program_update_date
, p_header_rec.request_date
, p_header_rec.request_id
, p_header_rec.return_reason_code
, p_header_rec.salesrep_id
, p_header_rec.sales_channel_code
, p_header_rec.shipment_priority_code
, p_header_rec.shipping_method_code
, p_header_rec.ship_from_org_id
, p_header_rec.ship_tolerance_above
, p_header_rec.ship_tolerance_below
, p_header_rec.ship_to_contact_id
, p_header_rec.ship_to_org_id
, p_header_rec.sold_from_org_id
, p_header_rec.sold_to_contact_id
, p_header_rec.sold_to_org_id
, p_header_rec.source_document_id
, p_header_rec.source_document_type_id
, p_header_rec.tax_exempt_flag
, p_header_rec.tax_exempt_number
, p_header_rec.tax_exempt_reason_code
, p_header_rec.tax_point_code
, p_header_rec.transactional_curr_code
, p_header_rec.version_number
, p_header_rec.return_status
, p_header_rec.db_flag
, p_header_rec.operation
, p_header_rec.first_ack_code
, p_header_rec.first_ack_date
, p_header_rec.last_ack_code
, p_header_rec.last_ack_date
, p_header_rec.change_reason
, p_header_rec.change_comments
, p_header_rec.change_sequence
, p_header_rec.change_request_code
, p_header_rec.ready_flag
, p_header_rec.status_flag
, p_header_rec.force_apply_flag
, p_header_rec.drop_ship_flag
, p_header_rec.customer_payment_term_id
, p_header_rec.payment_type_code
, p_header_rec.payment_amount
, p_header_rec.check_number
, p_header_rec.credit_card_code
, p_header_rec.credit_card_holder_name
, p_header_rec.credit_card_number
, p_header_rec.credit_card_expiration_date
, p_header_rec.credit_card_approval_code
, p_header_rec.shipping_instructions
, p_header_rec.packing_instructions
, p_header_rec.flow_status_code
);

Line: 552


, p_header_adj_tbl_type(i).last_updated_by
, p_header_adj_tbl_type(i).last_update_date
, p_header_adj_tbl_type(i).last_update_login
, p_header_adj_tbl_type(i).line_id
, p_header_adj_tbl_type(i).percent
, p_header_adj_tbl_type(i).price_adjustment_id
, p_header_adj_tbl_type(i).program_application_id
, p_header_adj_tbl_type(i).program_id
, p_header_adj_tbl_type(i).program_update_date
, p_header_adj_tbl_type(i).request_id
, p_header_adj_tbl_type(i).return_status
, p_header_adj_tbl_type(i).db_flag
, p_header_adj_tbl_type(i).operation
, p_header_adj_tbl_type(i).orig_sys_discount_ref
, p_header_adj_tbl_type(i).change_request_code
, p_header_adj_tbl_type(i).status_flag
, p_header_adj_tbl_type(i).list_header_id
, p_header_adj_tbl_type(i).list_line_id
, p_header_adj_tbl_type(i).list_line_type_code
, p_header_adj_tbl_type(i).modifier_mechanism_type_code
, p_header_adj_tbl_type(i).modified_from
, p_header_adj_tbl_type(i).modified_to
, p_header_adj_tbl_type(i).updated_flag
, p_header_adj_tbl_type(i).update_allowed
, p_header_adj_tbl_type(i).applied_flag
, p_header_adj_tbl_type(i).change_reason_code
, p_header_adj_tbl_type(i).change_reason_text
, p_header_adj_tbl_type(i).operand
, p_header_adj_tbl_type(i).arithmetic_operator
, p_header_adj_tbl_type(i).cost_id
, p_header_adj_tbl_type(i).tax_code
, p_header_adj_tbl_type(i).tax_exempt_flag
, p_header_adj_tbl_type(i).tax_exempt_number
, p_header_adj_tbl_type(i).tax_exempt_reason_code
, p_header_adj_tbl_type(i).parent_adjustment_id
, p_header_adj_tbl_type(i).invoiced_flag
, p_header_adj_tbl_type(i).estimated_flag
, p_header_adj_tbl_type(i).inc_in_sales_performance
, p_header_adj_tbl_type(i).split_action_code
, p_header_adj_tbl_type(i).adjusted_amount
, p_header_adj_tbl_type(i).pricing_phase_id
);

Line: 631


                                , p_header_adj_assoc_tbl_type(i).last_update_date
                                , p_header_adj_assoc_tbl_type(i).last_updated_by
                                , p_header_adj_assoc_tbl_type(i).last_update_login
                                , p_header_adj_assoc_tbl_type(i).program_application_id
                                , p_header_adj_assoc_tbl_type(i).program_id
                                , p_header_adj_assoc_tbl_type(i).program_update_date
                                , p_header_adj_assoc_tbl_type(i).request_id
                                , p_header_adj_assoc_tbl_type(i).return_status
                                , p_header_adj_assoc_tbl_type(i).db_flag
                                , p_header_adj_assoc_tbl_type(i).operation
                                );

Line: 680


, p_header_adj_att_tbl_type(i).last_update_date
, p_header_adj_att_tbl_type(i).last_updated_by
, p_header_adj_att_tbl_type(i).last_update_login
, p_header_adj_att_tbl_type(i).program_application_id
, p_header_adj_att_tbl_type(i).program_id
, p_header_adj_att_tbl_type(i).program_update_date
, p_header_adj_att_tbl_type(i).request_id
, p_header_adj_att_tbl_type(i).pricing_attr_value_from
, p_header_adj_att_tbl_type(i).pricing_attr_value_to
, p_header_adj_att_tbl_type(i).comparison_operator
, p_header_adj_att_tbl_type(i).return_status
, p_header_adj_att_tbl_type(i).db_flag
, p_header_adj_att_tbl_type(i).operation
);

Line: 727


, p_header_price_att_tbl_type(i).last_update_date
, p_header_price_att_tbl_type(i).last_updated_by
, p_header_price_att_tbl_type(i).last_update_login
, p_header_price_att_tbl_type(i).program_application_id
, p_header_price_att_tbl_type(i).program_id
, p_header_price_att_tbl_type(i).program_update_date
, p_header_price_att_tbl_type(i).request_id
, p_header_price_att_tbl_type(i).flex_title
, p_header_price_att_tbl_type(i).pricing_context
, p_header_price_att_tbl_type(i).pricing_attribute1
, p_header_price_att_tbl_type(i).pricing_attribute2
, p_header_price_att_tbl_type(i).pricing_attribute3
, p_header_price_att_tbl_type(i).pricing_attribute4
, p_header_price_att_tbl_type(i).pricing_attribute5
, p_header_price_att_tbl_type(i).pricing_attribute6
, p_header_price_att_tbl_type(i).pricing_attribute7
, p_header_price_att_tbl_type(i).pricing_attribute8
, p_header_price_att_tbl_type(i).pricing_attribute9
, p_header_price_att_tbl_type(i).pricing_attribute10
, p_header_price_att_tbl_type(i).pricing_attribute11
, p_header_price_att_tbl_type(i).pricing_attribute12
, p_header_price_att_tbl_type(i).pricing_attribute13
, p_header_price_att_tbl_type(i).pricing_attribute14
, p_header_price_att_tbl_type(i).pricing_attribute15
, p_header_price_att_tbl_type(i).pricing_attribute16
, p_header_price_att_tbl_type(i).pricing_attribute17
, p_header_price_att_tbl_type(i).pricing_attribute18
, p_header_price_att_tbl_type(i).pricing_attribute19
, p_header_price_att_tbl_type(i).pricing_attribute20
, p_header_price_att_tbl_type(i).pricing_attribute21
, p_header_price_att_tbl_type(i).pricing_attribute22
, p_header_price_att_tbl_type(i).pricing_attribute23
, p_header_price_att_tbl_type(i).pricing_attribute24
, p_header_price_att_tbl_type(i).pricing_attribute25
, p_header_price_att_tbl_type(i).pricing_attribute26
, p_header_price_att_tbl_type(i).pricing_attribute27
, p_header_price_att_tbl_type(i).pricing_attribute28
, p_header_price_att_tbl_type(i).pricing_attribute29
, p_header_price_att_tbl_type(i).pricing_attribute30
, p_header_price_att_tbl_type(i).pricing_attribute31
, p_header_price_att_tbl_type(i).pricing_attribute32
, p_header_price_att_tbl_type(i).pricing_attribute33
, p_header_price_att_tbl_type(i).pricing_attribute34
, p_header_price_att_tbl_type(i).pricing_attribute35
, p_header_price_att_tbl_type(i).pricing_attribute36
, p_header_price_att_tbl_type(i).pricing_attribute37
, p_header_price_att_tbl_type(i).pricing_attribute38
, p_header_price_att_tbl_type(i).pricing_attribute39
, p_header_price_att_tbl_type(i).pricing_attribute40
, p_header_price_att_tbl_type(i).pricing_attribute41
, p_header_price_att_tbl_type(i).pricing_attribute42
, p_header_price_att_tbl_type(i).pricing_attribute43
, p_header_price_att_tbl_type(i).pricing_attribute44
, p_header_price_att_tbl_type(i).pricing_attribute45
, p_header_price_att_tbl_type(i).pricing_attribute46
, p_header_price_att_tbl_type(i).pricing_attribute47
, p_header_price_att_tbl_type(i).pricing_attribute48
, p_header_price_att_tbl_type(i).pricing_attribute49
, p_header_price_att_tbl_type(i).pricing_attribute50
, p_header_price_att_tbl_type(i).pricing_attribute51
, p_header_price_att_tbl_type(i).pricing_attribute52
, p_header_price_att_tbl_type(i).pricing_attribute53
, p_header_price_att_tbl_type(i).pricing_attribute54
, p_header_price_att_tbl_type(i).pricing_attribute55
, p_header_price_att_tbl_type(i).pricing_attribute56
, p_header_price_att_tbl_type(i).pricing_attribute57
, p_header_price_att_tbl_type(i).pricing_attribute58
, p_header_price_att_tbl_type(i).pricing_attribute59
, p_header_price_att_tbl_type(i).pricing_attribute60
, p_header_price_att_tbl_type(i).pricing_attribute61
, p_header_price_att_tbl_type(i).pricing_attribute62
, p_header_price_att_tbl_type(i).pricing_attribute63
, p_header_price_att_tbl_type(i).pricing_attribute64
, p_header_price_att_tbl_type(i).pricing_attribute65
, p_header_price_att_tbl_type(i).pricing_attribute66
, p_header_price_att_tbl_type(i).pricing_attribute67
, p_header_price_att_tbl_type(i).pricing_attribute68
, p_header_price_att_tbl_type(i).pricing_attribute69
, p_header_price_att_tbl_type(i).pricing_attribute70
, p_header_price_att_tbl_type(i).pricing_attribute71
, p_header_price_att_tbl_type(i).pricing_attribute72
, p_header_price_att_tbl_type(i).pricing_attribute73
, p_header_price_att_tbl_type(i).pricing_attribute74
, p_header_price_att_tbl_type(i).pricing_attribute75
, p_header_price_att_tbl_type(i).pricing_attribute76
, p_header_price_att_tbl_type(i).pricing_attribute77
, p_header_price_att_tbl_type(i).pricing_attribute78
, p_header_price_att_tbl_type(i).pricing_attribute79
, p_header_price_att_tbl_type(i).pricing_attribute80
, p_header_price_att_tbl_type(i).pricing_attribute81
, p_header_price_att_tbl_type(i).pricing_attribute82
, p_header_price_att_tbl_type(i).pricing_attribute83
, p_header_price_att_tbl_type(i).pricing_attribute84
, p_header_price_att_tbl_type(i).pricing_attribute85
, p_header_price_att_tbl_type(i).pricing_attribute86
, p_header_price_att_tbl_type(i).pricing_attribute87
, p_header_price_att_tbl_type(i).pricing_attribute88
, p_header_price_att_tbl_type(i).pricing_attribute89
, p_header_price_att_tbl_type(i).pricing_attribute90
, p_header_price_att_tbl_type(i).pricing_attribute91
, p_header_price_att_tbl_type(i).pricing_attribute92
, p_header_price_att_tbl_type(i).pricing_attribute93
, p_header_price_att_tbl_type(i).pricing_attribute94
, p_header_price_att_tbl_type(i).pricing_attribute95
, p_header_price_att_tbl_type(i).pricing_attribute96
, p_header_price_att_tbl_type(i).pricing_attribute97
, p_header_price_att_tbl_type(i).pricing_attribute98
, p_header_price_att_tbl_type(i).pricing_attribute99
, p_header_price_att_tbl_type(i).pricing_attribute100
, p_header_price_att_tbl_type(i).context
, p_header_price_att_tbl_type(i).attribute1
, p_header_price_att_tbl_type(i).attribute2
, p_header_price_att_tbl_type(i).attribute3
, p_header_price_att_tbl_type(i).attribute4
, p_header_price_att_tbl_type(i).attribute5
, p_header_price_att_tbl_type(i).attribute6
, p_header_price_att_tbl_type(i).attribute7
, p_header_price_att_tbl_type(i).attribute8
, p_header_price_att_tbl_type(i).attribute9
, p_header_price_att_tbl_type(i).attribute10
, p_header_price_att_tbl_type(i).attribute11
, p_header_price_att_tbl_type(i).attribute12
, p_header_price_att_tbl_type(i).attribute13
, p_header_price_att_tbl_type(i).attribute14
, p_header_price_att_tbl_type(i).attribute15
, p_header_price_att_tbl_type(i).return_status
, p_header_price_att_tbl_type(i).db_flag
, p_header_price_att_tbl_type(i).operation
);

Line: 903


,  p_header_scredit_tbl_type(i).dw_update_advice_flag
,  p_header_scredit_tbl_type(i).header_id
,  p_header_scredit_tbl_type(i).last_updated_by
,  p_header_scredit_tbl_type(i).last_update_date
,  p_header_scredit_tbl_type(i).last_update_login
,  p_header_scredit_tbl_type(i).line_id
,  p_header_scredit_tbl_type(i).percent
,  p_header_scredit_tbl_type(i).salesrep_id
,  p_header_scredit_tbl_type(i). sales_credit_id
,  p_header_scredit_tbl_type(i).wh_update_date
,  p_header_scredit_tbl_type(i).return_status
,  p_header_scredit_tbl_type(i).db_flag
,  p_header_scredit_tbl_type(i).operation
,  p_header_scredit_tbl_type(i).orig_sys_credit_ref
,  p_header_scredit_tbl_type(i).change_request_code
,  p_header_scredit_tbl_type(i).status_flag
);

Line: 979


, p_line_tbl_type(i).auto_selected_quantity
, p_line_tbl_type(i).booked_flag
, p_line_tbl_type(i).cancelled_flag
, p_line_tbl_type(i).cancelled_quantity
, p_line_tbl_type(i).commitment_id
, p_line_tbl_type(i).component_code
, p_line_tbl_type(i).component_number
, p_line_tbl_type(i).component_sequence_id
, p_line_tbl_type(i).config_header_id
, p_line_tbl_type(i).config_rev_nbr
, p_line_tbl_type(i).config_display_sequence
, p_line_tbl_type(i).configuration_id
, p_line_tbl_type(i).context
, p_line_tbl_type(i).created_by
, p_line_tbl_type(i).creation_date
, p_line_tbl_type(i).credit_invoice_line_id
, p_line_tbl_type(i).customer_dock_code
, p_line_tbl_type(i).customer_job
, p_line_tbl_type(i).customer_production_line
, p_line_tbl_type(i).customer_trx_line_id
, p_line_tbl_type(i).cust_model_serial_number
, p_line_tbl_type(i).cust_po_number
, p_line_tbl_type(i).cust_production_seq_num
, p_line_tbl_type(i).delivery_lead_time
, p_line_tbl_type(i).deliver_to_contact_id
, p_line_tbl_type(i).deliver_to_org_id
, p_line_tbl_type(i).demand_bucket_type_code
, p_line_tbl_type(i).demand_class_code
, p_line_tbl_type(i).dep_plan_required_flag
, p_line_tbl_type(i).earliest_acceptable_date
, p_line_tbl_type(i).end_item_unit_number
, p_line_tbl_type(i).explosion_date
, p_line_tbl_type(i).fob_point_code
, p_line_tbl_type(i).freight_carrier_code
, p_line_tbl_type(i).freight_terms_code
, p_line_tbl_type(i).fulfilled_quantity
, p_line_tbl_type(i).global_attribute1
, p_line_tbl_type(i).global_attribute10
, p_line_tbl_type(i).global_attribute11
, p_line_tbl_type(i).global_attribute12
, p_line_tbl_type(i).global_attribute13
, p_line_tbl_type(i).global_attribute14
, p_line_tbl_type(i).global_attribute15
, p_line_tbl_type(i).global_attribute16
, p_line_tbl_type(i).global_attribute17
, p_line_tbl_type(i).global_attribute18
, p_line_tbl_type(i).global_attribute19
, p_line_tbl_type(i).global_attribute2
, p_line_tbl_type(i).global_attribute20
, p_line_tbl_type(i).global_attribute3
, p_line_tbl_type(i).global_attribute4
, p_line_tbl_type(i).global_attribute5
, p_line_tbl_type(i).global_attribute6
, p_line_tbl_type(i).global_attribute7
, p_line_tbl_type(i).global_attribute8
, p_line_tbl_type(i).global_attribute9
, p_line_tbl_type(i).global_attribute_category
, p_line_tbl_type(i).header_id
, p_line_tbl_type(i).industry_attribute1
, p_line_tbl_type(i).industry_attribute10
, p_line_tbl_type(i).industry_attribute11
, p_line_tbl_type(i).industry_attribute12
, p_line_tbl_type(i).industry_attribute13
, p_line_tbl_type(i).industry_attribute14
, p_line_tbl_type(i).industry_attribute15
, p_line_tbl_type(i).industry_attribute16
, p_line_tbl_type(i).industry_attribute17
, p_line_tbl_type(i).industry_attribute18
, p_line_tbl_type(i).industry_attribute19
, p_line_tbl_type(i).industry_attribute20
, p_line_tbl_type(i).industry_attribute21
, p_line_tbl_type(i).industry_attribute22
, p_line_tbl_type(i).industry_attribute23
, p_line_tbl_type(i).industry_attribute24
, p_line_tbl_type(i).industry_attribute25
, p_line_tbl_type(i).industry_attribute26
, p_line_tbl_type(i).industry_attribute27
, p_line_tbl_type(i).industry_attribute28
, p_line_tbl_type(i).industry_attribute29
, p_line_tbl_type(i).industry_attribute30
, p_line_tbl_type(i).industry_attribute2
, p_line_tbl_type(i).industry_attribute3
, p_line_tbl_type(i).industry_attribute4
, p_line_tbl_type(i).industry_attribute5
, p_line_tbl_type(i).industry_attribute6
, p_line_tbl_type(i).industry_attribute7
, p_line_tbl_type(i).industry_attribute8
, p_line_tbl_type(i).industry_attribute9
, p_line_tbl_type(i).industry_context
, p_line_tbl_type(i).TP_CONTEXT
, p_line_tbl_type(i).TP_ATTRIBUTE1
, p_line_tbl_type(i).TP_ATTRIBUTE2
, p_line_tbl_type(i).TP_ATTRIBUTE3
, p_line_tbl_type(i).TP_ATTRIBUTE4
, p_line_tbl_type(i).TP_ATTRIBUTE5
, p_line_tbl_type(i).TP_ATTRIBUTE6
, p_line_tbl_type(i).TP_ATTRIBUTE7
, p_line_tbl_type(i).TP_ATTRIBUTE8
, p_line_tbl_type(i).TP_ATTRIBUTE9
, p_line_tbl_type(i).TP_ATTRIBUTE10
, p_line_tbl_type(i).TP_ATTRIBUTE11
, p_line_tbl_type(i).TP_ATTRIBUTE12
, p_line_tbl_type(i).TP_ATTRIBUTE13
, p_line_tbl_type(i).TP_ATTRIBUTE14
, p_line_tbl_type(i).TP_ATTRIBUTE15
, p_line_tbl_type(i).intermed_ship_to_org_id
, p_line_tbl_type(i).intermed_ship_to_contact_id
, p_line_tbl_type(i).inventory_item_id
, p_line_tbl_type(i).invoice_interface_status_code
, p_line_tbl_type(i).invoice_to_contact_id
, p_line_tbl_type(i).invoice_to_org_id
, p_line_tbl_type(i).invoicing_rule_id
, p_line_tbl_type(i).ordered_item
, p_line_tbl_type(i).item_revision
, p_line_tbl_type(i).item_type_code
, p_line_tbl_type(i).last_updated_by
, p_line_tbl_type(i).last_update_date
, p_line_tbl_type(i).last_update_login
, p_line_tbl_type(i).latest_acceptable_date
, p_line_tbl_type(i).line_category_code
, p_line_tbl_type(i).line_id
, p_line_tbl_type(i).line_number
, p_line_tbl_type(i).line_type_id
, p_line_tbl_type(i).link_to_line_ref
, p_line_tbl_type(i).link_to_line_id
, p_line_tbl_type(i).link_to_line_index
, p_line_tbl_type(i).model_group_number
, p_line_tbl_type(i).mfg_component_sequence_id
, p_line_tbl_type(i).open_flag
, p_line_tbl_type(i).option_flag
, p_line_tbl_type(i).option_number
, p_line_tbl_type(i).ordered_quantity
, p_line_tbl_type(i).order_quantity_uom
, p_line_tbl_type(i).org_id
, p_line_tbl_type(i).orig_sys_document_ref
, p_line_tbl_type(i).orig_sys_line_ref
, p_line_tbl_type(i).over_ship_reason_code
, p_line_tbl_type(i).over_ship_resolved_flag
, p_line_tbl_type(i).payment_term_id
, p_line_tbl_type(i).planning_priority
, p_line_tbl_type(i).price_list_id
, p_line_tbl_type(i).pricing_attribute1
, p_line_tbl_type(i).pricing_attribute10
, p_line_tbl_type(i).pricing_attribute2
, p_line_tbl_type(i).pricing_attribute3
, p_line_tbl_type(i).pricing_attribute4
, p_line_tbl_type(i).pricing_attribute5
, p_line_tbl_type(i).pricing_attribute6
, p_line_tbl_type(i).pricing_attribute7
, p_line_tbl_type(i).pricing_attribute8
, p_line_tbl_type(i).pricing_attribute9
, p_line_tbl_type(i).pricing_context
, p_line_tbl_type(i).pricing_date
, p_line_tbl_type(i).pricing_quantity
, p_line_tbl_type(i).pricing_quantity_uom
, p_line_tbl_type(i).program_application_id
, p_line_tbl_type(i).program_id
, p_line_tbl_type(i).program_update_date
, p_line_tbl_type(i).project_id
, p_line_tbl_type(i).promise_date
, p_line_tbl_type(i).re_source_flag
, p_line_tbl_type(i).reference_customer_trx_line_id
, p_line_tbl_type(i).reference_header_id
, p_line_tbl_type(i).reference_line_id
, p_line_tbl_type(i).reference_type
, p_line_tbl_type(i).request_date
, p_line_tbl_type(i).request_id
, p_line_tbl_type(i).reserved_quantity
, p_line_tbl_type(i).return_attribute1
, p_line_tbl_type(i).return_attribute10
, p_line_tbl_type(i).return_attribute11
, p_line_tbl_type(i).return_attribute12
, p_line_tbl_type(i).return_attribute13
, p_line_tbl_type(i).return_attribute14
, p_line_tbl_type(i).return_attribute15
, p_line_tbl_type(i).return_attribute2
, p_line_tbl_type(i).return_attribute3
, p_line_tbl_type(i).return_attribute4
, p_line_tbl_type(i).return_attribute5
, p_line_tbl_type(i).return_attribute6
, p_line_tbl_type(i).return_attribute7
, p_line_tbl_type(i).return_attribute8
, p_line_tbl_type(i).return_attribute9
, p_line_tbl_type(i).return_context
, p_line_tbl_type(i).return_reason_code
, p_line_tbl_type(i).rla_schedule_type_code
, p_line_tbl_type(i).salesrep_id
, p_line_tbl_type(i).schedule_arrival_date
, p_line_tbl_type(i).schedule_ship_date
, p_line_tbl_type(i).schedule_action_code
, p_line_tbl_type(i).schedule_status_code
, p_line_tbl_type(i).shipment_number
, p_line_tbl_type(i).shipment_priority_code
, p_line_tbl_type(i).shipped_quantity
, p_line_tbl_type(i).shipping_interfaced_flag
, p_line_tbl_type(i).shipping_method_code
, p_line_tbl_type(i).shipping_quantity
, p_line_tbl_type(i).shipping_quantity_uom
, p_line_tbl_type(i).ship_from_org_id
, p_line_tbl_type(i).ship_model_complete_flag
, p_line_tbl_type(i).ship_set_id
, p_line_tbl_type(i).ship_tolerance_above
, p_line_tbl_type(i).ship_tolerance_below
, p_line_tbl_type(i).ship_to_contact_id
, p_line_tbl_type(i).ship_to_org_id
, p_line_tbl_type(i).sold_to_org_id
, p_line_tbl_type(i).sold_from_org_id
, p_line_tbl_type(i).sort_order
, p_line_tbl_type(i).source_document_id
, p_line_tbl_type(i).source_document_line_id
, p_line_tbl_type(i).source_document_type_id
, p_line_tbl_type(i).source_type_code
, p_line_tbl_type(i).split_from_line_id
, p_line_tbl_type(i).task_id
, p_line_tbl_type(i).tax_code
, p_line_tbl_type(i).tax_date
, p_line_tbl_type(i).tax_exempt_flag
, p_line_tbl_type(i).tax_exempt_number
, p_line_tbl_type(i).tax_exempt_reason_code
, p_line_tbl_type(i).tax_point_code
, p_line_tbl_type(i).tax_rate
, p_line_tbl_type(i).tax_value
, p_line_tbl_type(i).top_model_line_ref
, p_line_tbl_type(i).top_model_line_id
, p_line_tbl_type(i).top_model_line_index
, p_line_tbl_type(i).unit_list_price
, p_line_tbl_type(i).unit_selling_price
, p_line_tbl_type(i).veh_cus_item_cum_key_id
, p_line_tbl_type(i).visible_demand_flag
, p_line_tbl_type(i).return_status
, p_line_tbl_type(i).db_flag
, p_line_tbl_type(i).operation
, p_line_tbl_type(i).first_ack_code
, p_line_tbl_type(i).first_ack_date
, p_line_tbl_type(i).last_ack_code
, p_line_tbl_type(i).last_ack_date
, p_line_tbl_type(i).change_reason
, p_line_tbl_type(i).change_comments
, p_line_tbl_type(i).arrival_set
, p_line_tbl_type(i).ship_set
, p_line_tbl_type(i).order_source_id
, p_line_tbl_type(i).orig_sys_shipment_ref
, p_line_tbl_type(i).change_sequence
, p_line_tbl_type(i).change_request_code
, p_line_tbl_type(i).status_flag
, p_line_tbl_type(i).drop_ship_flag
, p_line_tbl_type(i).customer_line_number
, p_line_tbl_type(i).customer_shipment_number
, p_line_tbl_type(i).customer_item_net_price
, p_line_tbl_type(i).customer_payment_term_id
, p_line_tbl_type(i).ordered_item_id
, p_line_tbl_type(i).item_identifier_type
, p_line_tbl_type(i).shipping_instructions
, p_line_tbl_type(i).packing_instructions
, p_line_tbl_type(i).calculate_price_flag
, p_line_tbl_type(i).invoiced_quantity
, p_line_tbl_type(i).service_txn_reason_code
, p_line_tbl_type(i).service_txn_comments
, p_line_tbl_type(i).service_duration
, p_line_tbl_type(i).service_period
, p_line_tbl_type(i).service_start_date
, p_line_tbl_type(i).service_end_date
, p_line_tbl_type(i).service_coterminate_flag
, p_line_tbl_type(i).unit_list_percent
, p_line_tbl_type(i).unit_selling_percent
, p_line_tbl_type(i).unit_percent_base_price
, p_line_tbl_type(i).service_number
, p_line_tbl_type(i).service_reference_type_code
, p_line_tbl_type(i).service_reference_line_id
, p_line_tbl_type(i).service_reference_system_id
, p_line_tbl_type(i).service_ref_order_number
, p_line_tbl_type(i).service_ref_line_number
, p_line_tbl_type(i).service_ref_shipment_number
, p_line_tbl_type(i).service_ref_option_number
, p_line_tbl_type(i).service_line_index
, p_line_tbl_type(i).Line_set_id
, p_line_tbl_type(i).split_by
, p_line_tbl_type(i).Split_Action_Code
, p_line_tbl_type(i).shippable_flag
, p_line_tbl_type(i).model_remnant_flag
, p_line_tbl_type(i).flow_status_code
, p_line_tbl_type(i).fulfilled_flag
, p_line_tbl_type(i).fulfillment_method_code
, l_semi_processed_flag
);

Line: 1314


, p_line_adj_tbl_type(i).last_updated_by
, p_line_adj_tbl_type(i).last_update_date
, p_line_adj_tbl_type(i).last_update_login
, p_line_adj_tbl_type(i).line_id
, p_line_adj_tbl_type(i).percent
, p_line_adj_tbl_type(i).price_adjustment_id
, p_line_adj_tbl_type(i).program_application_id
, p_line_adj_tbl_type(i).program_id
, p_line_adj_tbl_type(i).program_update_date
, p_line_adj_tbl_type(i).request_id
, p_line_adj_tbl_type(i).return_status
, p_line_adj_tbl_type(i).db_flag
, p_line_adj_tbl_type(i).operation
, p_line_adj_tbl_type(i).line_index
, p_line_adj_tbl_type(i).orig_sys_discount_ref
, p_line_adj_tbl_type(i).change_request_code
, p_line_adj_tbl_type(i).status_flag
, p_line_adj_tbl_type(i).list_header_id
, p_line_adj_tbl_type(i).list_line_id
, p_line_adj_tbl_type(i).list_line_type_code
, p_line_adj_tbl_type(i).modifier_mechanism_type_code
, p_line_adj_tbl_type(i).modified_from
, p_line_adj_tbl_type(i).modified_to
, p_line_adj_tbl_type(i).updated_flag
, p_line_adj_tbl_type(i).update_allowed
, p_line_adj_tbl_type(i).applied_flag
, p_line_adj_tbl_type(i).change_reason_code
, p_line_adj_tbl_type(i).change_reason_text
, p_line_adj_tbl_type(i).operand
, p_line_adj_tbl_type(i).arithmetic_operator
, p_line_adj_tbl_type(i).cost_id
, p_line_adj_tbl_type(i).tax_code
, p_line_adj_tbl_type(i).tax_exempt_flag
, p_line_adj_tbl_type(i).tax_exempt_number
, p_line_adj_tbl_type(i).tax_exempt_reason_code
, p_line_adj_tbl_type(i).parent_adjustment_id
, p_line_adj_tbl_type(i).invoiced_flag
, p_line_adj_tbl_type(i).estimated_flag
, p_line_adj_tbl_type(i).inc_in_sales_performance
, p_line_adj_tbl_type(i).split_action_code
, p_line_adj_tbl_type(i).adjusted_amount
, p_line_adj_tbl_type(i).pricing_phase_id
);

Line: 1392


, p_line_adj_assoc_tbl_type(i).last_update_date
, p_line_adj_assoc_tbl_type(i).last_updated_by
, p_line_adj_assoc_tbl_type(i).last_update_login
, p_line_adj_assoc_tbl_type(i).program_application_id
, p_line_adj_assoc_tbl_type(i).program_id
, p_line_adj_assoc_tbl_type(i).program_update_date
, p_line_adj_assoc_tbl_type(i).request_id
, p_line_adj_assoc_tbl_type(i).return_status
, p_line_adj_assoc_tbl_type(i).db_flag
, p_line_adj_assoc_tbl_type(i).operation
);

Line: 1441


, p_line_adj_att_tbl_type(i).last_update_date
, p_line_adj_att_tbl_type(i).last_updated_by
, p_line_adj_att_tbl_type(i).last_update_login
, p_line_adj_att_tbl_type(i).program_application_id
, p_line_adj_att_tbl_type(i).program_id
, p_line_adj_att_tbl_type(i).program_update_date
, p_line_adj_att_tbl_type(i).request_id
, p_line_adj_att_tbl_type(i).pricing_attr_value_from
, p_line_adj_att_tbl_type(i).pricing_attr_value_to
, p_line_adj_att_tbl_type(i).comparison_operator
, p_line_adj_att_tbl_type(i).return_status
, p_line_adj_att_tbl_type(i).db_flag
, p_line_adj_att_tbl_type(i).operation
);

Line: 1491


, p_line_price_att_tbl_type(i).last_update_date
, p_line_price_att_tbl_type(i).last_updated_by
, p_line_price_att_tbl_type(i).last_update_login
, p_line_price_att_tbl_type(i).program_application_id
, p_line_price_att_tbl_type(i).program_id
, p_line_price_att_tbl_type(i).program_update_date
, p_line_price_att_tbl_type(i).request_id
, p_line_price_att_tbl_type(i).flex_title
, p_line_price_att_tbl_type(i).pricing_context
, p_line_price_att_tbl_type(i).pricing_attribute1
, p_line_price_att_tbl_type(i).pricing_attribute2
, p_line_price_att_tbl_type(i).pricing_attribute3
, p_line_price_att_tbl_type(i).pricing_attribute4
, p_line_price_att_tbl_type(i).pricing_attribute5
, p_line_price_att_tbl_type(i).pricing_attribute6
, p_line_price_att_tbl_type(i).pricing_attribute7
, p_line_price_att_tbl_type(i).pricing_attribute8
, p_line_price_att_tbl_type(i).pricing_attribute9
, p_line_price_att_tbl_type(i).pricing_attribute10
, p_line_price_att_tbl_type(i).pricing_attribute11
, p_line_price_att_tbl_type(i).pricing_attribute12
, p_line_price_att_tbl_type(i).pricing_attribute13
, p_line_price_att_tbl_type(i).pricing_attribute14
, p_line_price_att_tbl_type(i).pricing_attribute15
, p_line_price_att_tbl_type(i).pricing_attribute16
, p_line_price_att_tbl_type(i).pricing_attribute17
, p_line_price_att_tbl_type(i).pricing_attribute18
, p_line_price_att_tbl_type(i).pricing_attribute19
, p_line_price_att_tbl_type(i).pricing_attribute20
, p_line_price_att_tbl_type(i).pricing_attribute21
, p_line_price_att_tbl_type(i).pricing_attribute22
, p_line_price_att_tbl_type(i).pricing_attribute23
, p_line_price_att_tbl_type(i).pricing_attribute24
, p_line_price_att_tbl_type(i).pricing_attribute25
, p_line_price_att_tbl_type(i).pricing_attribute26
, p_line_price_att_tbl_type(i).pricing_attribute27
, p_line_price_att_tbl_type(i).pricing_attribute28
, p_line_price_att_tbl_type(i).pricing_attribute29
, p_line_price_att_tbl_type(i).pricing_attribute30
, p_line_price_att_tbl_type(i).pricing_attribute31
, p_line_price_att_tbl_type(i).pricing_attribute32
, p_line_price_att_tbl_type(i).pricing_attribute33
, p_line_price_att_tbl_type(i).pricing_attribute34
, p_line_price_att_tbl_type(i).pricing_attribute35
, p_line_price_att_tbl_type(i).pricing_attribute36
, p_line_price_att_tbl_type(i).pricing_attribute37
, p_line_price_att_tbl_type(i).pricing_attribute38
, p_line_price_att_tbl_type(i).pricing_attribute39
, p_line_price_att_tbl_type(i).pricing_attribute40
, p_line_price_att_tbl_type(i).pricing_attribute41
, p_line_price_att_tbl_type(i).pricing_attribute42
, p_line_price_att_tbl_type(i).pricing_attribute43
, p_line_price_att_tbl_type(i).pricing_attribute44
, p_line_price_att_tbl_type(i).pricing_attribute45
, p_line_price_att_tbl_type(i).pricing_attribute46
, p_line_price_att_tbl_type(i).pricing_attribute47
, p_line_price_att_tbl_type(i).pricing_attribute48
, p_line_price_att_tbl_type(i).pricing_attribute49
, p_line_price_att_tbl_type(i).pricing_attribute50
, p_line_price_att_tbl_type(i).pricing_attribute51
, p_line_price_att_tbl_type(i).pricing_attribute52
, p_line_price_att_tbl_type(i).pricing_attribute53
, p_line_price_att_tbl_type(i).pricing_attribute54
, p_line_price_att_tbl_type(i).pricing_attribute55
, p_line_price_att_tbl_type(i).pricing_attribute56
, p_line_price_att_tbl_type(i).pricing_attribute57
, p_line_price_att_tbl_type(i).pricing_attribute58
, p_line_price_att_tbl_type(i).pricing_attribute59
, p_line_price_att_tbl_type(i).pricing_attribute60
, p_line_price_att_tbl_type(i).pricing_attribute61
, p_line_price_att_tbl_type(i).pricing_attribute62
, p_line_price_att_tbl_type(i).pricing_attribute63
, p_line_price_att_tbl_type(i).pricing_attribute64
, p_line_price_att_tbl_type(i).pricing_attribute65
, p_line_price_att_tbl_type(i).pricing_attribute66
, p_line_price_att_tbl_type(i).pricing_attribute67
, p_line_price_att_tbl_type(i).pricing_attribute68
, p_line_price_att_tbl_type(i).pricing_attribute69
, p_line_price_att_tbl_type(i).pricing_attribute70
, p_line_price_att_tbl_type(i).pricing_attribute71
, p_line_price_att_tbl_type(i).pricing_attribute72
, p_line_price_att_tbl_type(i).pricing_attribute73
, p_line_price_att_tbl_type(i).pricing_attribute74
, p_line_price_att_tbl_type(i).pricing_attribute75
, p_line_price_att_tbl_type(i).pricing_attribute76
, p_line_price_att_tbl_type(i).pricing_attribute77
, p_line_price_att_tbl_type(i).pricing_attribute78
, p_line_price_att_tbl_type(i).pricing_attribute79
, p_line_price_att_tbl_type(i).pricing_attribute80
, p_line_price_att_tbl_type(i).pricing_attribute81
, p_line_price_att_tbl_type(i).pricing_attribute82
, p_line_price_att_tbl_type(i).pricing_attribute83
, p_line_price_att_tbl_type(i).pricing_attribute84
, p_line_price_att_tbl_type(i).pricing_attribute85
, p_line_price_att_tbl_type(i).pricing_attribute86
, p_line_price_att_tbl_type(i).pricing_attribute87
, p_line_price_att_tbl_type(i).pricing_attribute88
, p_line_price_att_tbl_type(i).pricing_attribute89
, p_line_price_att_tbl_type(i).pricing_attribute90
, p_line_price_att_tbl_type(i).pricing_attribute91
, p_line_price_att_tbl_type(i).pricing_attribute92
, p_line_price_att_tbl_type(i).pricing_attribute93
, p_line_price_att_tbl_type(i).pricing_attribute94
, p_line_price_att_tbl_type(i).pricing_attribute95
, p_line_price_att_tbl_type(i).pricing_attribute96
, p_line_price_att_tbl_type(i).pricing_attribute97
, p_line_price_att_tbl_type(i).pricing_attribute98
, p_line_price_att_tbl_type(i).pricing_attribute99
, p_line_price_att_tbl_type(i).pricing_attribute100
, p_line_price_att_tbl_type(i).context
, p_line_price_att_tbl_type(i).attribute1
, p_line_price_att_tbl_type(i).attribute2
, p_line_price_att_tbl_type(i).attribute3
, p_line_price_att_tbl_type(i).attribute4
, p_line_price_att_tbl_type(i).attribute5
, p_line_price_att_tbl_type(i).attribute6
, p_line_price_att_tbl_type(i).attribute7
, p_line_price_att_tbl_type(i).attribute8
, p_line_price_att_tbl_type(i).attribute9
, p_line_price_att_tbl_type(i).attribute10
, p_line_price_att_tbl_type(i).attribute11
, p_line_price_att_tbl_type(i).attribute12
, p_line_price_att_tbl_type(i).attribute13
, p_line_price_att_tbl_type(i).attribute14
, p_line_price_att_tbl_type(i).attribute15
, p_line_price_att_tbl_type(i).return_status
, p_line_price_att_tbl_type(i).db_flag
, p_line_price_att_tbl_type(i).operation
);

Line: 1667


, p_line_scredit_tbl_type(i).dw_update_advice_flag
, p_line_scredit_tbl_type(i).header_id
, p_line_scredit_tbl_type(i).last_updated_by
, p_line_scredit_tbl_type(i).last_update_date
, p_line_scredit_tbl_type(i).last_update_login
, p_line_scredit_tbl_type(i).line_id
, p_line_scredit_tbl_type(i).percent
, p_line_scredit_tbl_type(i).salesrep_id
, p_line_scredit_tbl_type(i).sales_credit_id
, p_line_scredit_tbl_type(i).wh_update_date
, p_line_scredit_tbl_type(i).return_status
, p_line_scredit_tbl_type(i).db_flag
, p_line_scredit_tbl_type(i).operation
, p_line_scredit_tbl_type(i).line_index
, p_line_scredit_tbl_type(i).orig_sys_credit_ref
, p_line_scredit_tbl_type(i).change_request_code
, p_line_scredit_tbl_type(i).status_flag
);

Line: 1734


, p_lot_serial_tbl_type(i).last_updated_by
, p_lot_serial_tbl_type(i).last_update_date
, p_lot_serial_tbl_type(i).last_update_login
, p_lot_serial_tbl_type(i).line_id
, p_lot_serial_tbl_type(i).lot_number
, p_lot_serial_tbl_type(i).lot_serial_id
, p_lot_serial_tbl_type(i).quantity
, p_lot_serial_tbl_type(i).to_serial_number
, p_lot_serial_tbl_type(i).return_status
, p_lot_serial_tbl_type(i).db_flag
, p_lot_serial_tbl_type(i).operation
, p_lot_serial_tbl_type(i).line_index
, p_lot_serial_tbl_type(i).orig_sys_lotserial_ref
, p_lot_serial_tbl_type(i).change_request_code
, p_lot_serial_tbl_type(i).status_flag
, p_lot_serial_tbl_type(i).line_set_id
);

Line: 1894


		 SELECT LOOKUP_CODE from ASO_LOOKUPS where
		 LOOKUP_TYPE = 'ASO_ORDER_FEEDBACK_CRM_APPS'
		 and enabled_flag = 'Y' and
		 sysdate between nvl(start_date_active, sysdate)
		 and nvl(end_date_active,sysdate);