APPS.OE_ITORD_PUB dependencies on OE_ITEM_ORDERABILITY

Line 852: oe_item_orderability oei

848: SELECT 'Y'
849: INTO l_exists
850: FROM mtl_item_categories ic,
851: mtl_default_category_sets cs,
852: oe_item_orderability oei
853: WHERE ic.category_set_id=cs.category_set_id
854: AND cs.functional_area_id = 7
855: AND ic.organization_id = oe_sys_parameters.Value('MASTER_ORGANIZATION_ID',p_Item_Orderability_Import_Rec.org_id)
856: AND ic.inventory_item_id = p_Item_Orderability_Import_Rec.inventory_item_id

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 914: oe_item_orderability oei

910: SELECT 'Y'
911: into l_exists
912: FROM mtl_item_categories ic,
913: mtl_default_category_sets cs,
914: oe_item_orderability oei
915: WHERE ic.category_set_id=cs.category_set_id
916: AND cs.functional_area_id = 7
917: AND ic.organization_id=oe_sys_parameters.Value('MASTER_ORGANIZATION_ID',p_Item_Orderability_Import_Rec.org_id)
918: AND ic.inventory_item_id = oei.inventory_item_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 1064: from oe_item_orderability

1060:
1061:
1062: begin
1063: select orderability_id into l_orderability_id
1064: from oe_item_orderability
1065: where enable_flag = 'Y'
1066: and org_id = p_Item_Orderability_Import_Rec.org_id
1067: and item_level = p_Item_Orderability_Import_Rec.ITEM_LEVEL
1068: and ( inventory_item_id = p_Item_Orderability_Import_Rec.inventory_item_id

Line 1079: SELECT OE_ITEM_ORDERABILITY_S.nextval

1075: End;
1076:
1077: IF l_orderability_id IS NULL then
1078:
1079: SELECT OE_ITEM_ORDERABILITY_S.nextval
1080: INTO l_orderability_id
1081: FROM dual;
1082:
1083: l_item_orderability_rec.orderability_id := l_orderability_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;