DBA Data[Home] [Help]

APPS.CSD_REPAIR_MANAGER_UTIL dependencies on MTL_ITEM_CATEGORIES

Line 558: mtl_item_categories mic

554:
555: select cqt.threshold_qty
556: into l_threshold
557: from csd_quality_thresholds_b cqt,
558: mtl_item_categories mic
559: where cqt.inventory_org_id = p_organization_id
560: and cqt.item_category_id = mic.category_id
561: and mic.organization_id = p_organization_id
562: and mic.inventory_item_id = p_inventory_item_id;

Line 642: from mtl_item_categories mic

638: from csd_aging_thresholds_b
639: where inventory_org_id = p_organization_id
640: and p_inventory_item_id =
641: ( select mic.inventory_item_id
642: from mtl_item_categories mic
643: where mic.organization_id = p_organization_id
644: and mic.category_id = item_category_id
645: and mic.inventory_item_id = p_inventory_item_id
646: );*/

Line 657: from mtl_item_categories mic

653: csd_flow_statuses_b cfs
654: WHERE cat.inventory_org_id = p_organization_id
655: AND p_inventory_item_id in (
656: select mic.inventory_item_id
657: from mtl_item_categories mic
658: where mic.organization_id = p_organization_id
659: and mic.category_id = cat.item_category_id
660: and mic.inventory_item_id = p_inventory_item_id
661: )