The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
p_Line_Type_id
, nvl(enforce_line_prices_flag,'N')
INTO
g_Enforce_list_price_rec.Line_Type_id
, g_Enforce_list_price_rec.enforce_line_prices_flag
from oe_line_types_v
WHERE LINE_TYPE_ID = p_Line_Type_id;
SELECT /*MOAC_SQL_CHANGES*/
p_header_id
, nvl(oot.enforce_line_prices_flag,'N')
INTO
g_Enforce_list_price_rec.header_id
, g_Enforce_list_price_rec.enforce_line_prices_flag
from oe_Order_types_v oot,oe_order_headers_all ooh
where oot.order_type_id= ooh.order_type_id and
ooh.header_id = p_header_id and ooh.org_id=oot.org_id;
SELECT ORDER_TYPE_ID
, NAME
, INVOICING_RULE_ID
, ACCOUNTING_RULE_ID
, PRICE_LIST_ID
, SHIPMENT_PRIORITY_CODE
, fob_point_code FOB_POINT_CODE
, FREIGHT_TERMS_CODE
, warehouse_id SHIP_FROM_ORG_ID
, AGREEMENT_TYPE_CODE
, shipping_method_code SHIPPING_METHOD_CODE
, AGREEMENT_REQUIRED_FLAG
, PO_REQUIRED_FLAG
, enforce_line_prices_flag
, auto_scheduling_flag
-- QUOTING changes
, quote_num_as_ord_num_flag
, invoice_source_id
, non_delivery_invoice_source_id
, cust_trx_type_id
--added for bug 4200055
, start_date_active
, end_date_active
, tax_calculation_event_code
INTO g_order_type_rec.order_type_id
, g_order_type_rec.name
, g_order_type_rec.invoicing_rule_id
, g_order_type_rec.accounting_rule_id
, g_order_type_rec.price_list_id
, g_order_type_rec.shipment_priority_code
, g_order_type_rec.fob_point_code
, g_order_type_rec.freight_terms_code
, g_order_type_rec.ship_from_org_id
, g_order_type_rec.agreement_type_code
, g_order_type_rec.shipping_method_code
, g_order_type_rec.agreement_required_flag
, g_order_type_rec.require_po_flag
, g_order_type_rec.enforce_line_prices_flag
, g_order_type_rec.auto_scheduling_flag
-- QUOTING changes
, g_order_type_rec.quote_num_as_ord_num_flag
, g_order_type_rec.invoice_source_id
, g_order_type_rec.non_delivery_invoice_source_id
, g_order_type_rec.cust_trx_type_id
-- added for bug 4200055
, g_order_type_rec.start_date_active
, g_order_type_rec.end_date_active
, g_order_type_rec.tax_calculation_event_code
FROM OE_ORDER_TYPES_V
WHERE ORDER_TYPE_ID = p_key;
oe_debug_pub.add('before selecting line_type info : ' || g_line_type_rec.calculate_tax_flag, 1);
SELECT LINE_TYPE_ID
, NAME
, CUST_TRX_TYPE_ID
, INVOICING_RULE_ID
, ACCOUNTING_RULE_ID
, PRICE_LIST_ID
, SHIPMENT_PRIORITY_CODE
, fob_point_code FOB_POINT_CODE
, FREIGHT_TERMS_CODE
, warehouse_id SHIP_FROM_ORG_ID
, AGREEMENT_TYPE_CODE
, shipping_method_code SHIPPING_METHOD_CODE
, AGREEMENT_REQUIRED_FLAG
, enforce_line_prices_flag
, order_category_code
, ship_source_type_code
, invoice_source_id
, non_delivery_invoice_source_id
--added for bug 4200055
, start_date_active
, end_date_active
, tax_calculation_event_code
INTO g_line_type_rec.line_type_id
, g_line_type_rec.name
, g_line_type_rec.cust_trx_type_id
, g_line_type_rec.invoicing_rule_id
, g_line_type_rec.accounting_rule_id
, g_line_type_rec.price_list_id
, g_line_type_rec.shipment_priority_code
, g_line_type_rec.fob_point_code
, g_line_type_rec.freight_terms_code
, g_line_type_rec.ship_from_org_id
, g_line_type_rec.agreement_type_code
, g_line_type_rec.shipping_method_code
, g_line_type_rec.agreement_required_flag
, g_line_type_rec.enforce_line_prices_flag
, g_line_type_rec.order_category_code
, g_line_type_rec.ship_source_type_code
, g_line_type_rec.invoice_source_id
, g_line_type_rec.non_delivery_invoice_source_id
-- added for bug 4200055
, g_line_type_rec.start_date_active
, g_line_type_rec.end_date_active
, g_line_type_rec.tax_calculation_event_code
FROM OE_LINE_TYPES_V
WHERE LINE_TYPE_ID = p_key;
oe_debug_pub.add('after selecting line_type info : ' || g_line_type_rec.calculate_tax_flag, 1);
SELECT tax_calculation_flag
INTO l_calculate_tax_flag
FROM RA_CUST_TRX_TYPES
WHERE CUST_TRX_TYPE_ID = g_line_type_rec.cust_trx_type_id;
oe_debug_pub.add('after selecting tax_flag info : ' || l_calculate_tax_flag, 1);
SELECT AGREEMENT_ID
, INVOICING_RULE_ID
, ACCOUNTING_RULE_ID
, PRICE_LIST_ID
, CUST_PO_NUMBER
, PAYMENT_TERM_ID
, INVOICE_TO_ORG_ID
, INVOICE_TO_CONTACT_ID
, AGREEMENT_TYPE_CODE
, DECODE(SOLD_TO_ORG_ID,-1,NULL,SOLD_TO_ORG_ID)
INTO g_agreement_rec.agreement_id
, g_agreement_rec.invoicing_rule_id
, g_agreement_rec.accounting_rule_id
, g_agreement_rec.price_list_id
, g_agreement_rec.cust_po_number
, g_agreement_rec.payment_term_id
, g_agreement_rec.invoice_to_org_id
, g_agreement_rec.invoice_to_contact_id
, g_agreement_rec.agreement_type_code
, g_agreement_rec.sold_to_org_id
FROM OE_AGREEMENTS_V
WHERE AGREEMENT_ID = p_key;
SELECT ORGANIZATION_ID
, PRICE_LIST_ID
, FOB_POINT_CODE
, FREIGHT_TERMS_CODE
, SOLD_FROM_ORG_ID
, SHIP_FROM_ORG_ID
, CONTACT_ID
, SHIP_PARTIAL_ALLOWED
, SHIPPING_METHOD_CODE
, BILL_TO_SITE_USE_ID
INTO g_ship_to_rec.org_id
, g_ship_to_rec.price_list_id
, g_ship_to_rec.fob_point_code
, g_ship_to_rec.freight_terms_code
, g_ship_to_rec.sold_from_org_id
, g_ship_to_rec.ship_from_org_id
, g_ship_to_rec.contact_id
, g_ship_to_rec.ship_partial_allowed
, g_ship_to_rec.shipping_method_code
, l_bill_to_site_use_id
FROM OE_SHIP_TO_ORGS_V
WHERE ORGANIZATION_ID = p_key;
SELECT ORGANIZATION_ID
INTO g_ship_to_rec.invoice_to_org_id
FROM OE_INVOICE_TO_ORGS_V
WHERE SITE_USE_ID = l_bill_to_site_use_id;
SELECT STANDARD_TERMS
INTO g_ship_to_rec.payment_term_id
FROM HZ_CUSTOMER_PROFILES
WHERE SITE_USE_ID = p_key;
SELECT ORGANIZATION_ID
, PRICE_LIST_ID
, FOB_POINT_CODE
, FREIGHT_TERMS_CODE
, CONTACT_ID
, SHIP_PARTIAL_ALLOWED
, SHIPPING_METHOD_CODE
--added for bug 4200055
, STATUS
, ADDRESS_STATUS
, START_DATE_ACTIVE
, END_DATE_ACTIVE
INTO g_invoice_to_rec.org_id
, g_invoice_to_rec.price_list_id
, g_invoice_to_rec.fob_point_code
, g_invoice_to_rec.freight_terms_code
, g_invoice_to_rec.contact_id
, g_invoice_to_rec.ship_partial_allowed
, g_invoice_to_rec.shipping_method_code
--added for bug 4200055
, g_invoice_to_rec.status
, g_invoice_to_rec.address_status
, g_invoice_to_rec.start_date_active
, g_invoice_to_rec.end_date_active
FROM OE_INVOICE_TO_ORGS_V
WHERE ORGANIZATION_ID = p_key;
SELECT STANDARD_TERMS
INTO g_invoice_to_rec.payment_term_id
FROM HZ_CUSTOMER_PROFILES
WHERE SITE_USE_ID = p_key;
SELECT ORGANIZATION_ID
, PRICE_LIST_ID
, FOB_POINT_CODE
, FREIGHT_TERMS_CODE
, SOLD_FROM_ORG_ID
, SHIP_FROM_ORG_ID
, CONTACT_ID
, SHIP_PARTIAL_ALLOWED
, SHIPPING_METHOD_CODE
, BILL_TO_SITE_USE_ID
INTO g_deliver_to_rec.org_id
, g_deliver_to_rec.price_list_id
, g_deliver_to_rec.fob_point_code
, g_deliver_to_rec.freight_terms_code
, g_deliver_to_rec.sold_from_org_id
, g_deliver_to_rec.ship_from_org_id
, g_deliver_to_rec.contact_id
, g_deliver_to_rec.ship_partial_allowed
, g_deliver_to_rec.shipping_method_code
, l_bill_to_site_use_id
FROM OE_DELIVER_TO_ORGS_V
WHERE ORGANIZATION_ID = p_key;
SELECT ORGANIZATION_ID
INTO g_deliver_to_rec.invoice_to_org_id
FROM OE_INVOICE_TO_ORGS_V
WHERE SITE_USE_ID = l_bill_to_site_use_id;
SELECT ORGANIZATION_ID
, PRICE_LIST_ID
, FOB_POINT_CODE
, FREIGHT_TERMS_CODE
, SHIP_PARTIAL_ALLOWED
, SHIPPING_METHOD_CODE
, ORDER_TYPE_ID
INTO g_sold_to_rec.sold_to_org_id --MOAC Changes
, g_sold_to_rec.price_list_id
, g_sold_to_rec.fob_point_code
, g_sold_to_rec.freight_terms_code
, g_sold_to_rec.ship_partial_allowed
, g_sold_to_rec.shipping_method_code
, g_sold_to_rec.order_type_id
FROM OE_SOLD_TO_ORGS_V
WHERE ORGANIZATION_ID = p_key;
SELECT /*MOAC_SQL_CHANGES*/ INV.ORGANIZATION_ID
INTO g_sold_to_rec.invoice_to_org_id
FROM OE_INVOICE_TO_ORGS_V INV
,HZ_CUST_ACCT_SITES_ALL ADDR
WHERE ADDR.CUST_ACCOUNT_ID = p_key
AND ADDR.BILL_TO_FLAG = 'P'
AND ADDR.STATUS = 'A'
AND INV.ADDRESS_ID = ADDR.CUST_ACCT_SITE_ID
AND INV.PRIMARY_FLAG = 'Y'
AND INV.STATUS = 'A' and inv.org_id=addr.org_id
and INV.address_status='A'; --2752321
SELECT /*MOAC_SQL_CHANGES*/ SHIP.ORGANIZATION_ID
INTO g_sold_to_rec.ship_to_org_id
FROM OE_SHIP_TO_ORGS_V SHIP
, HZ_CUST_ACCT_SITES_ALL ADDR
WHERE ADDR.CUST_ACCOUNT_ID = p_key
AND ADDR.SHIP_TO_FLAG = 'P'
AND ADDR.STATUS = 'A'
AND SHIP.ADDRESS_ID = ADDR.CUST_ACCT_SITE_ID
AND SHIP.PRIMARY_FLAG = 'Y'
AND SHIP.STATUS = 'A' and ship.org_id=addr.org_id
and ship.address_status='A'; --2752321
SELECT /*MOAC_SQL_CHANGES*/ DEL.ORGANIZATION_ID
INTO g_sold_to_rec.deliver_to_org_id
FROM OE_DELIVER_TO_ORGS_V DEL
,HZ_CUST_ACCT_SITES_ALL ADDR
WHERE ADDR.CUST_ACCOUNT_ID = p_key
AND ADDR.SHIP_TO_FLAG = 'P'
AND ADDR.STATUS = 'A'
AND DEL.ADDRESS_ID = ADDR.CUST_ACCT_SITE_ID
AND DEL.PRIMARY_FLAG = 'Y' and del.organization_id=addr.org_id
AND DEL.STATUS = 'A'
and DEL.address_status='A'; --2752321
SELECT STANDARD_TERMS
INTO g_sold_to_rec.payment_term_id
FROM HZ_CUSTOMER_PROFILES
WHERE CUST_ACCOUNT_ID = p_key
AND SITE_USE_ID IS NULL;
SELECT list_header_id
-- , PAYMENT_TERM_ID
, TERMS_ID
, SHIP_METHOD_CODE
, FREIGHT_TERMS_CODE
, CURRENCY_CODE
-- added for bug 4200055
, NAME
, LIST_TYPE_CODE
, ACTIVE_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
INTO g_price_list_rec.price_list_id
, g_price_list_rec.payment_term_id
, g_price_list_rec.ship_method_code
, g_price_list_rec.freight_terms_code
, g_price_list_rec.currency_code
--added for bug 4200055
, g_price_list_rec.name
, g_price_list_rec.list_type_code
, g_price_list_rec.active_flag
, g_price_list_rec.start_date_active
, g_price_list_rec.end_date_active
-- FROM qp_list_headers_b
FROM qp_list_headers_vl
WHERE list_header_id = p_key
and list_type_code in ('PRL', 'AGR');
SELECT SET_OF_BOOKS_ID
, CURRENCY_CODE
INTO g_set_of_books_rec.set_of_books_id
, g_set_of_books_rec.currency_code
FROM OE_GL_SETS_OF_BOOKS_V
WHERE SET_OF_BOOKS_ID = l_set_of_books_id;
SELECT INVENTORY_ITEM_ID
, ORGANIZATION_ID
, MATERIAL_COST
, MATERIAL_OVERHEAD_COST
, RESOURCE_COST
, OUTSIDE_PROCESSING_COST
, OVERHEAD_COST
INTO g_item_cost_rec.inventory_item_id
, g_item_cost_rec.organization_id
, g_item_cost_rec.material_cost
, g_item_cost_rec.material_overhead_cost
, g_item_cost_rec.resource_cost
, g_item_cost_rec.outside_processing_cost
, g_item_cost_rec.overhead_cost
FROM CST_ITEM_COSTS
WHERE INVENTORY_ITEM_ID = p_key1
AND ORGANIZATION_ID = p_key2;
SELECT NVL( Nvl(sodsc.percent, sodls.percent), 0),
sodsc.discount_id,
NVL(sodls.discount_line_id, -1),
sodsc.name,
l_adj_id
INTO g_hdr_discount_rec.percent,
g_hdr_discount_rec.discount_id,
g_hdr_discount_rec.discount_line_id,
g_hdr_discount_rec.adjustment_name,
g_hdr_discount_rec.price_adjustment_id
FROM oe_discounts sodsc,
oe_discount_lines sodls
WHERE sodls.discount_line_id = l_discount_line_id
AND sodls.discount_id = sodsc.discount_id;
SELECT Nvl(sodsc.percent, 0),
sodsc.discount_id,
-1,
sodsc.name,
l_adj_id
INTO g_hdr_discount_rec.percent,
g_hdr_discount_rec.discount_id,
g_hdr_discount_rec.discount_line_id,
g_hdr_discount_rec.adjustment_name,
g_hdr_discount_rec.price_adjustment_id
FROM oe_discounts sodsc
WHERE l_discount_id = sodsc.discount_id;
SELECT (nvl(sodsc.amount / oeorln.UNIT_LIST_PRICE * 100,
nvl(sodsc.percent,
nvl((oeorln.UNIT_LIST_PRICE - sodls.price ) /
oeorln.UNIT_LIST_PRICE * 100,
nvl(sodls.amount / oeorln.UNIT_LIST_PRICE * 100,
nvl(sodls.percent,
nvl((oeorln.UNIT_LIST_PRICE - sopbl.price ) /
oeorln.UNIT_LIST_PRICE * 100,
nvl(sopbl.amount / oeorln.UNIT_LIST_PRICE * 100,
nvl( sopbl.percent, 0 ))))))))),
sodsc.discount_id,
Nvl(sodls.discount_line_id, -1),
sodsc.name,
l_adj_id
INTO g_line_discount_rec.percent,
g_line_discount_rec.discount_id,
g_line_discount_rec.discount_line_id,
g_line_discount_rec.adjustment_name,
g_line_discount_rec.price_adjustment_id
FROM oe_discounts sodsc,
oe_discount_lines sodls,
oe_price_break_lines sopbl,
oe_order_lines oeorln
WHERE sodls.discount_line_id = l_discount_line_id
AND sodls.discount_id = sodsc.discount_id
AND sopbl.discount_line_id(+) = sodls.discount_line_id
AND oeorln.line_id = l_line_id;
SELECT Nvl(nvl(sodsc.amount / oeorln.UNIT_LIST_PRICE * 100,
sodsc.percent), 0),
sodsc.discount_id,
-1,
sodsc.name,
l_adj_id
INTO g_line_discount_rec.percent,
g_line_discount_rec.discount_id,
g_line_discount_rec.discount_line_id,
g_line_discount_rec.adjustment_name,
g_line_discount_rec.price_adjustment_id
FROM oe_discounts sodsc,
oe_order_lines oeorln
WHERE sodsc.discount_id = l_discount_id
AND oeorln.line_id = l_line_id;
SELECT item_id
, item_um
, item_um2
, dualum_ind
, grade_ctl
FROM ic_item_mst
WHERE delete_mark = 0
AND item_no in (SELECT segment1
FROM mtl_system_items
WHERE organization_id = discrete_org_id
AND inventory_item_id = discrete_item_id);
SELECT INVENTORY_ITEM_ID
,ORGANIZATION_ID
,INVOICING_RULE_ID
,ACCOUNTING_RULE_ID
,DEFAULT_SHIPPING_ORG
,SHIP_MODEL_COMPLETE_FLAG
,BUILD_IN_WIP_FLAG
,BOM_ITEM_TYPE
,REPLENISH_TO_ORDER_FLAG
,PRIMARY_UOM_CODE
,PICK_COMPONENTS_FLAG
,SHIPPABLE_ITEM_FLAG
,SERVICE_ITEM_FLAG
-- Pack J catchweight
,ONT_PRICING_QTY_SOURCE -- INVCONV
,TRACKING_QUANTITY_IND
,SECONDARY_UOM_CODE
-- bug 4171642 FP
,ORGANIZATION_ID
,CUSTOMER_ORDER_ENABLED_FLAG
,INTERNAL_ORDER_ENABLED_FLAG
,RETURNABLE_FLAG
,RESTRICT_SUBINVENTORIES_CODE
-- bug 4171642
-- INVCONV start
,SECONDARY_DEFAULT_IND
,LOT_DIVISIBLE_FLAG
,GRADE_CONTROL_FLAG,
LOT_CONTROL_CODE
INTO g_item_rec.inventory_item_id
,g_item_rec.organization_id
,g_item_rec.invoicing_rule_id
,g_item_rec.accounting_rule_id
,g_item_rec.default_shipping_org
,g_item_rec.ship_model_complete_flag
,g_item_rec.build_in_wip_flag
,g_item_rec.bom_item_type
,g_item_rec.replenish_to_order_flag
,g_item_rec.primary_uom_code
,g_item_rec.pick_components_flag
,g_item_rec.shippable_item_flag
,g_item_rec.service_item_flag
-- Pack J catchweight
,g_item_rec.ont_pricing_qty_source
,g_item_rec.tracking_quantity_ind
,g_item_rec.secondary_uom_code
-- 4171642 FP
,g_item_rec.master_org_id
,g_item_rec.customer_order_enabled_flag
,g_item_rec.internal_order_enabled_flag
,g_item_rec.returnable_flag
,g_item_rec.restrict_subinventories_code
-- 4171642
-- INVCONV start
,g_item_rec.secondary_default_ind
,g_item_rec.lot_divisible_flag
,g_item_rec.grade_control_flag
,g_item_rec.lot_control_code
FROM MTL_SYSTEM_ITEMS
WHERE INVENTORY_ITEM_ID = p_key1
AND ORGANIZATION_ID = l_key2;
SELECT shippable_item_flag
,organization_id
, restrict_subinventories_code -- bug 4171642
,ONT_PRICING_QTY_SOURCE -- INVCONV
,TRACKING_QUANTITY_IND
,SECONDARY_UOM_CODE
,SECONDARY_DEFAULT_IND
,LOT_DIVISIBLE_FLAG
,GRADE_CONTROL_FLAG
,LOT_CONTROL_CODE
, returnable_flag --5608844
,PRIMARY_UOM_CODE -- 5608585
INTO g_item_rec.shippable_item_flag
,g_item_rec.organization_id
,g_item_rec.restrict_subinventories_code
,g_item_rec.ont_pricing_qty_source
,g_item_rec.tracking_quantity_ind
,g_item_rec.secondary_uom_code
-- INVCONV start
,g_item_rec.secondary_default_ind
,g_item_rec.lot_divisible_flag
,g_item_rec.grade_control_flag
,g_item_rec.lot_control_code
,g_item_rec.returnable_flag --5608844
,g_item_rec.primary_uom_code -- 5608585
FROM MTL_SYSTEM_ITEMS
WHERE INVENTORY_ITEM_ID = p_key1
AND ORGANIZATION_ID = p_key2;
SELECT wms_enabled_flag
INTO g_item_rec.wms_enabled_flag
FROM mtl_parameters
WHERE organization_id = p_key2;
SELECT INVENTORY_ITEM_ID
, ORGANIZATION_ID
, INVOICING_RULE_ID
, ACCOUNTING_RULE_ID
, DEFAULT_SHIPPING_ORG
, SHIP_MODEL_COMPLETE_FLAG
, BUILD_IN_WIP_FLAG
, BOM_ITEM_TYPE
, REPLENISH_TO_ORDER_FLAG
, PRIMARY_UOM_CODE
, PICK_COMPONENTS_FLAG
, SHIPPABLE_ITEM_FLAG
, SERVICE_ITEM_FLAG
-- added for bug 4171642
,ORGANIZATION_ID
,CUSTOMER_ORDER_ENABLED_FLAG
,INTERNAL_ORDER_ENABLED_FLAG
,RETURNABLE_FLAG
,RESTRICT_SUBINVENTORIES_CODE
INTO g_item_rec.inventory_item_id
, g_item_rec.organization_id
, g_item_rec.invoicing_rule_id
, g_item_rec.accounting_rule_id
, g_item_rec.default_shipping_org
, g_item_rec.ship_model_complete_flag
, g_item_rec.build_in_wip_flag
, g_item_rec.bom_item_type
, g_item_rec.replenish_to_order_flag
, g_item_rec.primary_uom_code
, g_item_rec.pick_components_flag
, g_item_rec.shippable_item_flag
, g_item_rec.service_item_flag
-- bug 4171642
,g_item_rec.master_org_id
,g_item_rec.customer_order_enabled_flag
,g_item_rec.internal_order_enabled_flag
,g_item_rec.returnable_flag
,g_item_rec.restrict_subinventories_code
FROM MTL_SYSTEM_ITEMS
WHERE INVENTORY_ITEM_ID = p_key1
AND ORGANIZATION_ID = OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',p_key3);
SELECT set_id
,set_name
,set_type
,header_Id
,ship_from_org_id
,ship_to_org_id
,schedule_ship_date
,schedule_arrival_date
,shipment_priority_code
,freight_carrier_code
,shipping_method_code
,set_status
INTO g_set_rec.set_id
,g_set_rec.set_name
,g_set_rec.set_type
,g_set_rec.Header_Id
,g_set_rec.Ship_from_org_id
,g_set_rec.Ship_to_org_id
,g_set_rec.Schedule_Ship_Date
,g_set_rec.Schedule_Arrival_Date
,g_set_rec.Shipment_priority_code
,g_set_rec.Freight_Carrier_Code
,g_set_Rec.Shipping_Method_Code
,g_set_rec.Set_Status
FROM oe_sets
WHERE oe_sets.set_id= p_set_id;
SELECT term_id ,
name,
start_date_active,
end_date_active
INTO
g_Payment_Term_rec.term_id,
g_Payment_Term_rec.name,
g_Payment_Term_rec.start_date_active,
g_Payment_Term_rec.end_date_active
FROM OE_RA_TERMS_V
WHERE term_id = p_key ;
SELECT salesrep_id ,
name,
status,
start_date_active,
end_date_active
INTO
g_Salesrep_rec.salesrep_id,
g_Salesrep_rec.name,
g_Salesrep_rec.status,
g_Salesrep_rec.start_date_active,
g_Salesrep_rec.end_date_active
FROM RA_SALESREPS
WHERE salesrep_id = p_key ;
SELECT arithmetic_operator
,automatic_flag
,base_qty
,base_uom_code
,inventory_item_id
,list_header_id
,list_line_id
,list_line_type_code
,modifier_level_code
,operand
,organization_id
,override_flag
,percent_price
,price_break_type_code
,price_by_formula_id
,primary_uom_flag
,print_on_invoice_flag
,rebate_transaction_type_code
,related_item_id
,relationship_type_id
,substitution_attribute
,substitution_context
,substitution_value
,accrual_flag
,pricing_group_sequence
,incompatibility_grp_code
,list_line_no
,pricing_phase_id
,product_precedence
,expiration_date
,charge_type_code
,charge_subtype_code
,benefit_qty
,benefit_uom_code
,accrual_conversion_rate
,proration_type_code
,include_on_returns_flag
,print_on_invoice_flag
,accrual_flag
INTO
g_Modifiers_Rec.arithmetic_operator
,g_Modifiers_Rec.automatic_flag
,g_Modifiers_Rec.base_qty
,g_Modifiers_Rec.base_uom_code
,g_Modifiers_Rec.inventory_item_id
,g_Modifiers_Rec.list_header_id
,g_Modifiers_Rec.list_line_id
,g_Modifiers_Rec.list_line_type_code
,g_Modifiers_Rec.modifier_level_code
,g_Modifiers_Rec.operand
,g_Modifiers_Rec.organization_id
,g_Modifiers_Rec.override_flag
,g_Modifiers_Rec.percent_price
,g_Modifiers_Rec.price_break_type_code
,g_Modifiers_Rec.price_by_formula_id
,g_Modifiers_Rec.primary_uom_flag
,g_Modifiers_Rec.print_on_invoice_flag
,g_Modifiers_Rec.rebate_transaction_type_code
,g_Modifiers_Rec.related_item_id
,g_Modifiers_Rec.relationship_type_id
,g_Modifiers_Rec.substitution_attribute
,g_Modifiers_Rec.substitution_context
,g_Modifiers_Rec.substitution_value
,g_Modifiers_Rec.accrual_flag
,g_Modifiers_Rec.pricing_group_sequence
,g_Modifiers_Rec.incompatibility_grp_code
,g_Modifiers_Rec.list_line_no
,g_Modifiers_Rec.pricing_phase_id
,g_Modifiers_Rec.product_precedence
,g_Modifiers_Rec.expiration_date
,g_Modifiers_Rec.charge_type_code
,g_Modifiers_Rec.charge_subtype_code
,g_Modifiers_Rec.benefit_qty
,g_Modifiers_Rec.benefit_uom_code
,g_Modifiers_Rec.accrual_conversion_rate
,g_Modifiers_Rec.proration_type_code
,g_Modifiers_Rec.include_on_returns_flag
,g_Modifiers_Rec.print_on_invoice_flag
,g_Modifiers_Rec.accrual_flag
FROM qp_list_lines
WHERE list_line_id= p_key;
SELECT tax_calculation_flag
,cust_trx_type_id
,org_id
INTO g_cust_trx_rec.tax_calculation_flag
,g_cust_trx_rec.cust_trx_type_id
,g_cust_trx_rec.org_id -- MOAC Changes
FROM RA_CUST_TRX_TYPES_ALL
WHERE CUST_TRX_TYPE_ID = p_key
AND ORG_ID = l_current_org_id ;
SELECT count(*)
INTO l_count
FROM fnd_descr_flex_column_usages
WHERE APPLICATION_ID = l_application_id
AND DESCRIPTIVE_FLEXFIELD_NAME = p_flex_name
AND ENABLED_FLAG = 'Y'
AND ROWNUM = 1;