APPS.PO_ASL_SV dependencies on MTL_ITEM_CATEGORIES

Line 63: from mtl_item_categories

59:
60: -- Bug 2072963
61: cursor c_category_ids (p_item_id Number, p_org_id Number) IS
62: select category_id
63: from mtl_item_categories
64: where inventory_item_id = p_item_id
65: and organization_id = p_org_id;
66:
67: x_asl_s NUMBER := 0;

Line 96: FROM MTL_ITEM_CATEGORIES MIC

92: AND nvl(ASL.vendor_site_id, nvl(x_vendor_site_id,-1)) = nvl(x_vendor_site_id,-1)
93: AND ( (ASL.item_id = x_item_id) OR
94: (ASL.category_id = x_category_id) OR
95: (ASL.category_id in (SELECT MIC.category_id
96: FROM MTL_ITEM_CATEGORIES MIC
97: WHERE MIC.inventory_item_id = x_item_id
98: AND MIC.organization_id = x_ship_to_org)))
99: AND ASL.asl_status_id = ASR.status_id
100: AND ASR.business_rule = x_action;

Line 152: FROM MTL_ITEM_CATEGORIES MIC

148: WHERE ASL.using_organization_id IN (nvl(x_ship_to_org,-1), -1)
149: AND ASL.vendor_id = x_vendor_id
150: AND nvl(ASL.vendor_site_id, nvl(x_vendor_site_id,-1)) = nvl(x_vendor_site_id,-1)
151: AND ASL.category_id in (SELECT MIC.category_id
152: FROM MTL_ITEM_CATEGORIES MIC
153: WHERE MIC.inventory_item_id = x_item_id
154: AND MIC.organization_id = x_ship_to_org)
155: AND ASL.asl_status_id = ASR.status_id
156: AND ASR.business_rule = x_action;