[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT nvl(order_source_id, FND_API.G_MISS_NUM)
, nvl(orig_sys_document_ref, FND_API.G_MISS_CHAR)
, nvl(orig_sys_line_ref, FND_API.G_MISS_CHAR)
, nvl(orig_sys_shipment_ref, FND_API.G_MISS_CHAR)
, nvl(change_request_code, FND_API.G_MISS_CHAR)
, nvl(org_id, FND_API.G_MISS_NUM)
, nvl(line_number, FND_API.G_MISS_NUM)
, nvl(shipment_number, FND_API.G_MISS_NUM)
, nvl(line_id, FND_API.G_MISS_NUM)
, nvl(line_type_id, FND_API.G_MISS_NUM)
, line_type
, nvl(item_type_code, FND_API.G_MISS_CHAR)
, nvl(inventory_item_id, FND_API.G_MISS_NUM)
, inventory_item
, nvl(top_model_line_ref, FND_API.G_MISS_CHAR)
, nvl(link_to_line_ref, FND_API.G_MISS_CHAR)
, nvl(explosion_date, FND_API.G_MISS_DATE)
, nvl(ato_line_id, FND_API.G_MISS_NUM)
, nvl(component_sequence_id, FND_API.G_MISS_NUM)
, nvl(component_code, FND_API.G_MISS_CHAR)
, nvl(sort_order, FND_API.G_MISS_CHAR)
, nvl(model_group_number, FND_API.G_MISS_NUM)
, nvl(option_number, FND_API.G_MISS_NUM)
, nvl(option_flag, 'N')
, nvl(ship_model_complete_flag, FND_API.G_MISS_CHAR)
, nvl(source_type_code, FND_API.G_MISS_CHAR)
, nvl(schedule_status_code, FND_API.G_MISS_CHAR)
, nvl(schedule_ship_date, FND_API.G_MISS_DATE)
, nvl(late_demand_penalty_factor, FND_API.G_MISS_NUM)
, nvl(schedule_arrival_date, FND_API.G_MISS_DATE)
, nvl(actual_arrival_date, FND_API.G_MISS_DATE)
, nvl(request_date, FND_API.G_MISS_DATE)
, nvl(promise_date, FND_API.G_MISS_DATE)
, nvl(delivery_lead_time, FND_API.G_MISS_NUM)
, nvl(ordered_quantity, FND_API.G_MISS_NUM)
, nvl(order_quantity_uom , FND_API.G_MISS_CHAR)
, nvl(shipping_quantity, FND_API.G_MISS_NUM)
, nvl(shipping_quantity_uom, FND_API.G_MISS_CHAR)
, nvl(shipped_quantity, FND_API.G_MISS_NUM)
, nvl(cancelled_quantity, FND_API.G_MISS_NUM)
, nvl(fulfilled_quantity, FND_API.G_MISS_NUM)
/* OPM variables */
, nvl(ordered_quantity2, FND_API.G_MISS_NUM)
, nvl(ordered_quantity_uom2 , FND_API.G_MISS_CHAR)
, nvl(shipping_quantity2, FND_API.G_MISS_NUM)
, nvl(shipping_quantity_uom2, FND_API.G_MISS_CHAR)
, nvl(shipped_quantity2, FND_API.G_MISS_NUM)
, nvl(cancelled_quantity2, FND_API.G_MISS_NUM)
, nvl(fulfilled_quantity2, FND_API.G_MISS_NUM)
, nvl(preferred_grade, FND_API.G_MISS_CHAR)
/* end of OPM variables */
, nvl(pricing_quantity, FND_API.G_MISS_NUM)
, nvl(pricing_quantity_uom, FND_API.G_MISS_CHAR)
, nvl(sold_from_org_id, FND_API.G_MISS_NUM)
, sold_from_org
, nvl(sold_to_org_id , FND_API.G_MISS_NUM)
, sold_to_org
, nvl(ship_from_org_id, FND_API.G_MISS_NUM)
, ship_from_org
, nvl(ship_to_org_id , FND_API.G_MISS_NUM)
, ship_to_org
, nvl(deliver_to_org_id, FND_API.G_MISS_NUM)
, deliver_to_org
, nvl(invoice_to_org_id, FND_API.G_MISS_NUM)
, invoice_to_org
, ship_to_address1
, ship_to_address2
, ship_to_address3
, ship_to_address4
, ship_to_city
, ship_to_state
, ship_to_postal_code
, ship_to_country
, nvl(ship_to_contact_id, FND_API.G_MISS_NUM)
, ship_to_contact
, nvl(deliver_to_contact_id, FND_API.G_MISS_NUM)
, deliver_to_contact
, nvl(invoice_to_contact_id, FND_API.G_MISS_NUM)
, invoice_to_contact
, nvl(drop_ship_flag, FND_API.G_MISS_CHAR)
, nvl(ship_tolerance_above, FND_API.G_MISS_NUM)
, nvl(ship_tolerance_below, FND_API.G_MISS_NUM)
, nvl(price_list_id, FND_API.G_MISS_NUM)
, price_list
, nvl(pricing_date, FND_API.G_MISS_DATE)
, nvl(unit_list_price, FND_API.G_MISS_NUM)
, nvl(unit_selling_price, FND_API.G_MISS_NUM)
, nvl(calculate_price_flag, 'Y')
, nvl(ship_set_id, FND_API.G_MISS_NUM)
, nvl(ship_set_name, FND_API.G_MISS_CHAR)
, nvl(arrival_set_id, FND_API.G_MISS_NUM)
, nvl(arrival_set_name, FND_API.G_MISS_CHAR)
, nvl(fulfillment_set_id, FND_API.G_MISS_NUM)
, nvl(fulfillment_set_name, FND_API.G_MISS_CHAR)
, nvl(tax_code, FND_API.G_MISS_CHAR)
, nvl(tax_value, FND_API.G_MISS_NUM)
, nvl(tax_date, FND_API.G_MISS_DATE)
, nvl(tax_point_code, FND_API.G_MISS_CHAR)
, tax_point
, nvl(tax_exempt_flag, FND_API.G_MISS_CHAR)
, nvl(tax_exempt_number, FND_API.G_MISS_CHAR)
, nvl(tax_exempt_reason_code, FND_API.G_MISS_CHAR)
, tax_exempt_reason
, nvl(agreement_id, FND_API.G_MISS_NUM)
, agreement
, nvl(invoicing_rule_id, FND_API.G_MISS_NUM)
, invoicing_rule
, nvl(accounting_rule_id, FND_API.G_MISS_NUM)
, nvl(accounting_rule_duration, FND_API.G_MISS_NUM)
, accounting_rule
, nvl(payment_term_id, FND_API.G_MISS_NUM)
, payment_term
, nvl(demand_class_code, FND_API.G_MISS_CHAR)
, nvl(shipment_priority_code, FND_API.G_MISS_CHAR)
, shipment_priority
, nvl(shipping_method_code, FND_API.G_MISS_CHAR)
, nvl(shipping_instructions, FND_API.G_MISS_CHAR)
, nvl(packing_instructions, FND_API.G_MISS_CHAR)
, nvl(freight_carrier_code, FND_API.G_MISS_CHAR)
, nvl(freight_terms_code, FND_API.G_MISS_CHAR)
, freight_terms
, nvl(fob_point_code, FND_API.G_MISS_CHAR)
, fob_point
, nvl(return_reason_code, FND_API.G_MISS_CHAR)
, nvl(reference_type, FND_API.G_MISS_CHAR)
, nvl(reference_header_id, FND_API.G_MISS_NUM)
, nvl(reference_line_id, FND_API.G_MISS_NUM)
, nvl(credit_invoice_line_id, FND_API.G_MISS_NUM)
, nvl(customer_po_number, FND_API.G_MISS_CHAR)
, nvl(customer_line_number, FND_API.G_MISS_CHAR)
, nvl(customer_shipment_number, FND_API.G_MISS_CHAR)
, nvl(customer_item_id, FND_API.G_MISS_NUM)
, nvl(customer_item_id_type, FND_API.G_MISS_CHAR)
, nvl(customer_item_name, FND_API.G_MISS_CHAR)
-- , nvl(customer_item_revision, FND_API.G_MISS_CHAR)
, nvl(customer_item_net_price, FND_API.G_MISS_NUM)
, nvl(customer_payment_term_id, FND_API.G_MISS_NUM)
, customer_payment_term
, nvl(demand_bucket_type_code, FND_API.G_MISS_CHAR)
, demand_bucket_type
, nvl(customer_dock_code, FND_API.G_MISS_CHAR)
, nvl(customer_job, FND_API.G_MISS_CHAR)
, nvl(customer_production_line, FND_API.G_MISS_CHAR)
, nvl(cust_model_serial_number, FND_API.G_MISS_CHAR)
, nvl(project_id, FND_API.G_MISS_NUM)
, project
, nvl(task_id, FND_API.G_MISS_NUM)
, task
, nvl(end_item_unit_number, FND_API.G_MISS_CHAR)
, nvl(item_revision, FND_API.G_MISS_CHAR)
, nvl(service_duration, FND_API.G_MISS_NUM)
, nvl(service_period, FND_API.G_MISS_CHAR)
, nvl(service_start_date, FND_API.G_MISS_DATE)
, nvl(service_end_date, FND_API.G_MISS_DATE)
, nvl(service_coterminate_flag, FND_API.G_MISS_CHAR)
, nvl(unit_selling_percent, FND_API.G_MISS_NUM)
, nvl(unit_list_percent, FND_API.G_MISS_NUM)
, nvl(unit_percent_base_price, FND_API.G_MISS_NUM)
, nvl(service_number, FND_API.G_MISS_NUM)
-- , nvl(fulfilled_flag, FND_API.G_MISS_CHAR)--ToBeAdded
-- , nvl(closed_flag, FND_API.G_MISS_CHAR)
, nvl(cancelled_flag, FND_API.G_MISS_CHAR)
, nvl(context, FND_API.G_MISS_CHAR)
, nvl(attribute1, FND_API.G_MISS_CHAR)
, nvl(attribute2, FND_API.G_MISS_CHAR)
, nvl(attribute3, FND_API.G_MISS_CHAR)
, nvl(attribute4, FND_API.G_MISS_CHAR)
, nvl(attribute5, FND_API.G_MISS_CHAR)
, nvl(attribute6, FND_API.G_MISS_CHAR)
, nvl(attribute7, FND_API.G_MISS_CHAR)
, nvl(attribute8, FND_API.G_MISS_CHAR)
, nvl(attribute9, FND_API.G_MISS_CHAR)
, nvl(attribute10, FND_API.G_MISS_CHAR)
, nvl(attribute11, FND_API.G_MISS_CHAR)
, nvl(attribute12, FND_API.G_MISS_CHAR)
, nvl(attribute13, FND_API.G_MISS_CHAR)
, nvl(attribute14, FND_API.G_MISS_CHAR)
, nvl(attribute15, FND_API.G_MISS_CHAR)
, nvl(attribute16, FND_API.G_MISS_CHAR) -- for bug 2184255
, nvl(attribute17, FND_API.G_MISS_CHAR)
, nvl(attribute18, FND_API.G_MISS_CHAR)
, nvl(attribute19, FND_API.G_MISS_CHAR)
, nvl(attribute20, FND_API.G_MISS_CHAR)
, nvl(tp_context, FND_API.G_MISS_CHAR)
, nvl(tp_attribute1, FND_API.G_MISS_CHAR)
, nvl(tp_attribute2, FND_API.G_MISS_CHAR)
, nvl(tp_attribute3, FND_API.G_MISS_CHAR)
, nvl(tp_attribute4, FND_API.G_MISS_CHAR)
, nvl(tp_attribute5, FND_API.G_MISS_CHAR)
, nvl(tp_attribute6, FND_API.G_MISS_CHAR)
, nvl(tp_attribute7, FND_API.G_MISS_CHAR)
, nvl(tp_attribute8, FND_API.G_MISS_CHAR)
, nvl(tp_attribute9, FND_API.G_MISS_CHAR)
, nvl(tp_attribute10, FND_API.G_MISS_CHAR)
, nvl(tp_attribute11, FND_API.G_MISS_CHAR)
, nvl(tp_attribute12, FND_API.G_MISS_CHAR)
, nvl(tp_attribute13, FND_API.G_MISS_CHAR)
, nvl(tp_attribute14, FND_API.G_MISS_CHAR)
, nvl(tp_attribute15, FND_API.G_MISS_CHAR)
, nvl(industry_context, FND_API.G_MISS_CHAR)
, nvl(industry_attribute1, FND_API.G_MISS_CHAR)
, nvl(industry_attribute2, FND_API.G_MISS_CHAR)
, nvl(industry_attribute3, FND_API.G_MISS_CHAR)
, nvl(industry_attribute4, FND_API.G_MISS_CHAR)
, nvl(industry_attribute5, FND_API.G_MISS_CHAR)
, nvl(industry_attribute6, FND_API.G_MISS_CHAR)
, nvl(industry_attribute7, FND_API.G_MISS_CHAR)
, nvl(industry_attribute8, FND_API.G_MISS_CHAR)
, nvl(industry_attribute9, FND_API.G_MISS_CHAR)
, nvl(industry_attribute10, FND_API.G_MISS_CHAR)
, nvl(industry_attribute11, FND_API.G_MISS_CHAR)
, nvl(industry_attribute12, FND_API.G_MISS_CHAR)
, nvl(industry_attribute13, FND_API.G_MISS_CHAR)
, nvl(industry_attribute14, FND_API.G_MISS_CHAR)
, nvl(industry_attribute15, FND_API.G_MISS_CHAR)
, nvl(industry_attribute16, FND_API.G_MISS_CHAR)
, nvl(industry_attribute17, FND_API.G_MISS_CHAR)
, nvl(industry_attribute18, FND_API.G_MISS_CHAR)
, nvl(industry_attribute19, FND_API.G_MISS_CHAR)
, nvl(industry_attribute20, FND_API.G_MISS_CHAR)
, nvl(industry_attribute21, FND_API.G_MISS_CHAR)
, nvl(industry_attribute22, FND_API.G_MISS_CHAR)
, nvl(industry_attribute23, FND_API.G_MISS_CHAR)
, nvl(industry_attribute24, FND_API.G_MISS_CHAR)
, nvl(industry_attribute25, FND_API.G_MISS_CHAR)
, nvl(industry_attribute26, FND_API.G_MISS_CHAR)
, nvl(industry_attribute27, FND_API.G_MISS_CHAR)
, nvl(industry_attribute28, FND_API.G_MISS_CHAR)
, nvl(industry_attribute29, FND_API.G_MISS_CHAR)
, nvl(industry_attribute30, FND_API.G_MISS_CHAR)
, nvl(pricing_context, FND_API.G_MISS_CHAR)
, nvl(pricing_attribute1, FND_API.G_MISS_CHAR)
, nvl(pricing_attribute2, FND_API.G_MISS_CHAR)
, nvl(pricing_attribute3, FND_API.G_MISS_CHAR)
, nvl(pricing_attribute4, FND_API.G_MISS_CHAR)
, nvl(pricing_attribute5, FND_API.G_MISS_CHAR)
, nvl(pricing_attribute6, FND_API.G_MISS_CHAR)
, nvl(pricing_attribute7, FND_API.G_MISS_CHAR)
, nvl(pricing_attribute8, FND_API.G_MISS_CHAR)
, nvl(pricing_attribute9, FND_API.G_MISS_CHAR)
, nvl(pricing_attribute10, FND_API.G_MISS_CHAR)
, nvl(global_attribute_category, FND_API.G_MISS_CHAR)
, nvl(global_attribute1, FND_API.G_MISS_CHAR)
, nvl(global_attribute2, FND_API.G_MISS_CHAR)
, nvl(global_attribute3, FND_API.G_MISS_CHAR)
, nvl(global_attribute4, FND_API.G_MISS_CHAR)
, nvl(global_attribute5, FND_API.G_MISS_CHAR)
, nvl(global_attribute6, FND_API.G_MISS_CHAR)
, nvl(global_attribute7, FND_API.G_MISS_CHAR)
, nvl(global_attribute8, FND_API.G_MISS_CHAR)
, nvl(global_attribute9, FND_API.G_MISS_CHAR)
, nvl(global_attribute10, FND_API.G_MISS_CHAR)
, nvl(global_attribute11, FND_API.G_MISS_CHAR)
, nvl(global_attribute12, FND_API.G_MISS_CHAR)
, nvl(global_attribute13, FND_API.G_MISS_CHAR)
, nvl(global_attribute14, FND_API.G_MISS_CHAR)
, nvl(global_attribute15, FND_API.G_MISS_CHAR)
, nvl(global_attribute16, FND_API.G_MISS_CHAR)
, nvl(global_attribute17, FND_API.G_MISS_CHAR)
, nvl(global_attribute18, FND_API.G_MISS_CHAR)
, nvl(global_attribute19, FND_API.G_MISS_CHAR)
, nvl(global_attribute20, FND_API.G_MISS_CHAR)
, nvl(return_context, FND_API.G_MISS_CHAR)
, nvl(return_attribute1, FND_API.G_MISS_CHAR)
, nvl(return_attribute2, FND_API.G_MISS_CHAR)
, nvl(return_attribute3, FND_API.G_MISS_CHAR)
, nvl(return_attribute4, FND_API.G_MISS_CHAR)
, nvl(return_attribute5, FND_API.G_MISS_CHAR)
, nvl(return_attribute6, FND_API.G_MISS_CHAR)
, nvl(return_attribute7, FND_API.G_MISS_CHAR)
, nvl(return_attribute8, FND_API.G_MISS_CHAR)
, nvl(return_attribute9, FND_API.G_MISS_CHAR)
, nvl(return_attribute10, FND_API.G_MISS_CHAR)
, nvl(return_attribute11, FND_API.G_MISS_CHAR)
, nvl(return_attribute12, FND_API.G_MISS_CHAR)
, nvl(return_attribute13, FND_API.G_MISS_CHAR)
, nvl(return_attribute14, FND_API.G_MISS_CHAR)
, nvl(return_attribute15, FND_API.G_MISS_CHAR)
, request_id
, nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)
, nvl(status_flag, FND_API.G_MISS_CHAR)
, nvl(change_reason, FND_API.G_MISS_CHAR)
, nvl(change_comments, FND_API.G_MISS_CHAR)
, nvl(service_txn_reason_code, FND_API.G_MISS_CHAR)
, nvl(service_txn_comments, FND_API.G_MISS_CHAR)
, nvl(service_reference_type_code, FND_API.G_MISS_CHAR)
, nvl(service_reference_order, FND_API.G_MISS_CHAR)
, nvl(service_reference_line, FND_API.G_MISS_CHAR)
, nvl(service_reference_system, FND_API.G_MISS_CHAR)
, INVENTORY_ITEM_SEGMENT_1
, INVENTORY_ITEM_SEGMENT_2
, INVENTORY_ITEM_SEGMENT_3
, INVENTORY_ITEM_SEGMENT_4
, INVENTORY_ITEM_SEGMENT_5
, INVENTORY_ITEM_SEGMENT_6
, INVENTORY_ITEM_SEGMENT_7
, INVENTORY_ITEM_SEGMENT_8
, INVENTORY_ITEM_SEGMENT_9
, INVENTORY_ITEM_SEGMENT_10
, INVENTORY_ITEM_SEGMENT_11
, INVENTORY_ITEM_SEGMENT_12
, INVENTORY_ITEM_SEGMENT_13
, INVENTORY_ITEM_SEGMENT_14
, INVENTORY_ITEM_SEGMENT_15
, INVENTORY_ITEM_SEGMENT_16
, INVENTORY_ITEM_SEGMENT_17
, INVENTORY_ITEM_SEGMENT_18
, INVENTORY_ITEM_SEGMENT_19
, INVENTORY_ITEM_SEGMENT_20
, commitment
, nvl(commitment_id, FND_API.G_MISS_NUM)
-- aksingh subinventory
, nvl(subinventory, FND_API.G_MISS_CHAR)
, salesrep
, nvl(salesrep_id, FND_API.G_MISS_NUM)
, nvl(earliest_acceptable_date, FND_API.G_MISS_DATE)
, nvl(latest_acceptable_date, FND_API.G_MISS_DATE)
, split_from_line_ref --bsadri
, split_from_shipment_ref
, invoice_to_address1
, invoice_to_address2
, invoice_to_address3
, invoice_to_address4
, invoice_to_city
, invoice_to_state
, invoice_to_postal_code
, invoice_to_country
-- { Start add new columns to select for the Add Customer
-- , Orig_Ship_Address_Ref
-- , Orig_Bill_Address_Ref
-- , Orig_Deliver_Address_Ref
-- , Ship_to_Contact_Ref
-- , Bill_to_Contact_Ref
-- , Deliver_to_Contact_Ref
-- End add new columns to select for the Add Customer}
, nvl(Config_Header_Id, FND_API.G_MISS_NUM)
, nvl(Config_Rev_Nbr, FND_API.G_MISS_NUM)
, nvl(Configuration_ID, FND_API.G_MISS_NUM)
, ship_to_customer_name
, ship_to_customer_number
, nvl(ship_to_customer_id, FND_API.G_MISS_NUM)
, invoice_to_customer_name
, invoice_to_customer_number
, nvl(invoice_to_customer_id, FND_API.G_MISS_NUM)
, deliver_to_customer_name
, deliver_to_customer_number
, nvl(deliver_to_customer_id, FND_API.G_MISS_NUM)
, nvl(user_item_description, FND_API.G_MISS_CHAR)
, override_atp_date_code
, xml_transaction_type_code
, nvl(blanket_number, FND_API.G_MISS_NUM)
, nvl(blanket_line_number, FND_API.G_MISS_NUM)
, shipping_method
FROM oe_lines_interface
WHERE order_source_id = l_order_source_id
AND orig_sys_document_ref = l_orig_sys_document_ref
AND (decode(l_customer_key_profile, 'Y',
nvl(sold_to_org_id, -999), 1)
= decode(l_customer_key_profile, 'Y',
nvl(p_sold_to_org_id, -999), 1)
OR decode(l_customer_key_profile, 'Y',
nvl(sold_to_org, ' '), '')
= decode(l_customer_key_profile, 'Y',
nvl(p_sold_to_org, ' '), ''))
AND nvl(change_sequence, FND_API.G_MISS_CHAR)
= nvl(l_change_sequence, FND_API.G_MISS_CHAR)
AND request_id = l_request_id
AND nvl(rejected_flag, 'N') = 'Y'
;
SELECT nvl(orig_sys_lotserial_ref, FND_API.G_MISS_CHAR)
, nvl(change_request_code, FND_API.G_MISS_CHAR)
, nvl(lot_number, FND_API.G_MISS_CHAR)
, nvl(from_serial_number, FND_API.G_MISS_CHAR)
, nvl(to_serial_number, FND_API.G_MISS_CHAR)
, nvl(quantity, FND_API.G_MISS_NUM)
, nvl(context, FND_API.G_MISS_CHAR)
, nvl(attribute1, FND_API.G_MISS_CHAR)
, nvl(attribute2, FND_API.G_MISS_CHAR)
, nvl(attribute3, FND_API.G_MISS_CHAR)
, nvl(attribute4, FND_API.G_MISS_CHAR)
, nvl(attribute5, FND_API.G_MISS_CHAR)
, nvl(attribute6, FND_API.G_MISS_CHAR)
, nvl(attribute7, FND_API.G_MISS_CHAR)
, nvl(attribute8, FND_API.G_MISS_CHAR)
, nvl(attribute9, FND_API.G_MISS_CHAR)
, nvl(attribute10, FND_API.G_MISS_CHAR)
, nvl(attribute11, FND_API.G_MISS_CHAR)
, nvl(attribute12, FND_API.G_MISS_CHAR)
, nvl(attribute13, FND_API.G_MISS_CHAR)
, nvl(attribute14, FND_API.G_MISS_CHAR)
, nvl(attribute15, FND_API.G_MISS_CHAR)
, nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)
FROM oe_lotserials_interface
WHERE order_source_id = l_order_source_id
AND orig_sys_document_ref = l_orig_sys_document_ref
AND (decode(l_customer_key_profile, 'Y',
nvl(sold_to_org_id, -999), 1)
= decode(l_customer_key_profile, 'Y',
nvl(p_sold_to_org_id, -999), 1)
OR decode(l_customer_key_profile, 'Y',
nvl(sold_to_org, ' '), '')
= decode(l_customer_key_profile, 'Y',
nvl(p_sold_to_org, ' '), ''))
AND nvl(change_sequence, FND_API.G_MISS_CHAR)
= nvl(l_change_sequence, FND_API.G_MISS_CHAR)
AND orig_sys_line_ref = l_orig_sys_line_ref
AND nvl(orig_sys_shipment_ref, FND_API.G_MISS_CHAR)
= nvl(l_orig_sys_shipment_ref, FND_API.G_MISS_CHAR)
AND request_id = p_request_id
;