APPS.OE_ITORD_PUB dependencies on OE_ITEM_ORDERABILITY_RULES

Line 875: || ' from oe_item_orderability io_hdr , oe_item_orderability_rules io_rules '

871:
872: OE_ITORD_PUB.get_rule_coulumn_details(p_Item_Orderability_Import_Rec,l_rule_level_coulmn,l_rule_level_value,l_data_type);
873:
874: sql_stmt := ' select count(1) '
875: || ' from oe_item_orderability io_hdr , oe_item_orderability_rules io_rules '
876: || ' where io_hdr.orderability_id = io_rules.orderability_id '
877: || ' and io_hdr.enable_flag = ''Y'' '
878: || ' and io_rules.enable_flag=''Y'' '
879: || ' and io_hdr.org_id = '|| p_Item_Orderability_Import_Rec.org_id

Line 938: || ' from oe_item_orderability io_hdr , oe_item_orderability_rules io_rules '

934:
935: OE_ITORD_PUB.get_rule_coulumn_details(p_Item_Orderability_Import_Rec,l_rule_level_coulmn,l_rule_level_value,l_data_type);
936:
937: sql_stmt := ' select count(1) '
938: || ' from oe_item_orderability io_hdr , oe_item_orderability_rules io_rules '
939: || ' where io_hdr.orderability_id = io_rules.orderability_id '
940: || ' and io_hdr.enable_flag = ''Y'' '
941: || ' and io_rules.enable_flag=''Y'' '
942: || ' and io_hdr.org_id = '|| p_Item_Orderability_Import_Rec.org_id

Line 1148: from oe_item_orderability_rules where rowid = l_rowid ;

1144:
1145: IF l_rowid IS NOT NULL then
1146:
1147: select orderability_id into l_orderability_id
1148: from oe_item_orderability_rules where rowid = l_rowid ;
1149:
1150: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_SUCCESS;
1151: p_Item_Orderability_Import_Rec.msg_data := 'Rule Created Successfully .Orderability_id ='||l_orderability_id;
1152: p_Item_Orderability_Import_Rec.msg_count := 1;