APPS.OE_ITORD_PUB dependencies on OE_ITEM_ORDERABILITY_RULES

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

914:
915: OE_ITORD_PUB.get_rule_coulumn_details(p_Item_Orderability_Import_Rec,l_rule_level_coulmn,l_rule_level_value,l_data_type);
916:
917: sql_stmt := ' select count(1) '
918: || ' from oe_item_orderability io_hdr , oe_item_orderability_rules io_rules '
919: || ' where io_hdr.orderability_id = io_rules.orderability_id '
920: || ' and io_hdr.enable_flag = ''Y'' '
921: || ' and io_rules.enable_flag=''Y'' '
922: || ' and io_hdr.org_id = '|| p_Item_Orderability_Import_Rec.org_id

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

979:
980: OE_ITORD_PUB.get_rule_coulumn_details(p_Item_Orderability_Import_Rec,l_rule_level_coulmn,l_rule_level_value,l_data_type);
981:
982: sql_stmt := ' select count(1) '
983: || ' from oe_item_orderability io_hdr , oe_item_orderability_rules io_rules '
984: || ' where io_hdr.orderability_id = io_rules.orderability_id '
985: || ' and io_hdr.enable_flag = ''Y'' '
986: || ' and io_rules.enable_flag=''Y'' '
987: || ' and io_hdr.org_id = '|| p_Item_Orderability_Import_Rec.org_id

Line 1198: from oe_item_orderability_rules where rowid = l_rowid ;

1194:
1195: IF l_rowid IS NOT NULL then
1196:
1197: select orderability_id into l_orderability_id
1198: from oe_item_orderability_rules where rowid = l_rowid ;
1199:
1200: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_SUCCESS;
1201: p_Item_Orderability_Import_Rec.msg_data := 'Rule Created Successfully .Orderability_id ='||l_orderability_id;
1202: p_Item_Orderability_Import_Rec.msg_count := 1;