[Home] [Help]
104: l_minimum_accountable_unit fnd_currencies.minimum_accountable_unit%type;
105: l_commitment_id oe_order_lines.commitment_id%type;
106: l_cust_trx_type_id ra_cust_trx_types_all.cust_Trx_type_id%type;
107: l_AR_Sys_Param_Rec ar_system_parameters_all%ROWTYPE;
108: l_product_type zx_product_types_def_v.classification_code%TYPE;
109: --x_otoc_le_info_rec XLE_BUSINESSINFO_GRP.otoc_le_rec;
110: l_legal_entity_id NUMBER(15);
111: l_customer_type VARCHAR2(30);
112: l_customer_id NUMBER;
489: BEGIN
490: -- for getting product_type
491: SELECT classification_code
492: INTO l_product_type
493: FROM zx_product_types_def_v
494: WHERE org_id = l_inventory_org_id
495: AND inventory_item_id = l_line_rec.inventory_item_id;
496: IF l_debug_level > 0 THEN
497: oe_debug_pub.add('product type:'||l_product_type,3);
715: zx_global_structures_pkg.trx_line_dist_tbl.UOM_CODE(i) := l_uom_code;
716: if l_inventory_item_id is NULL then
717: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_TYPE(i) := NULL;
718: else
719: -- this should be GOODS/SERVICES based on zx_product_types_def_v.
720: -- to be changed when zx_product_types_def_v is available.
721: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_TYPE(i) := l_product_type;
722: end if;
723: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CODE(i) := l_product_code;
716: if l_inventory_item_id is NULL then
717: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_TYPE(i) := NULL;
718: else
719: -- this should be GOODS/SERVICES based on zx_product_types_def_v.
720: -- to be changed when zx_product_types_def_v is available.
721: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_TYPE(i) := l_product_type;
722: end if;
723: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CODE(i) := l_product_code;
724: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CATEGORY(i) := NULL;