APPS.OE_ITORD_PUB dependencies on OE_ITEM_ORDERABILITY

Line 893: oe_item_orderability oei

889: SELECT 'Y'
890: INTO l_exists
891: FROM mtl_item_categories ic,
892: mtl_default_category_sets cs,
893: oe_item_orderability oei
894: WHERE ic.category_set_id=cs.category_set_id
895: AND cs.functional_area_id = 7
896: AND ic.organization_id = oe_sys_parameters.Value('MASTER_ORGANIZATION_ID',p_Item_Orderability_Import_Rec.org_id)
897: AND ic.inventory_item_id = p_Item_Orderability_Import_Rec.inventory_item_id

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

954: SELECT 'Y'
955: into l_exists
956: FROM mtl_item_categories ic,
957: mtl_default_category_sets cs,
958: oe_item_orderability oei
959: WHERE ic.category_set_id=cs.category_set_id
960: AND cs.functional_area_id = 7
961: AND ic.organization_id=oe_sys_parameters.Value('MASTER_ORGANIZATION_ID',p_Item_Orderability_Import_Rec.org_id)
962: AND ic.inventory_item_id = oei.inventory_item_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 1113: from oe_item_orderability

1109:
1110:
1111: begin
1112: select orderability_id into l_orderability_id
1113: from oe_item_orderability
1114: where enable_flag = 'Y'
1115: and org_id = p_Item_Orderability_Import_Rec.org_id
1116: and item_level = p_Item_Orderability_Import_Rec.ITEM_LEVEL
1117: and ( inventory_item_id = p_Item_Orderability_Import_Rec.inventory_item_id

Line 1129: SELECT OE_ITEM_ORDERABILITY_S.nextval

1125: End;
1126:
1127: IF l_orderability_id IS NULL then
1128:
1129: SELECT OE_ITEM_ORDERABILITY_S.nextval
1130: INTO l_orderability_id
1131: FROM dual;
1132:
1133: l_item_orderability_rec.orderability_id := l_orderability_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;