DBA Data[Home] [Help]

APPS.AMS_DMSELECTION_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 3842: FROM ams_act_products a, mtl_system_items_kfv b

3838: L_API_NAME VARCHAR2(60) := 'Validate Product Affinity Selection Status';
3839:
3840: CURSOR c_cats_for_model (p_model_id IN NUMBER) IS
3841: SELECT a.category_id, a.inventory_item_id, a.organization_id, a.category_set_id, b.padded_concatenated_segments
3842: FROM ams_act_products a, mtl_system_items_kfv b
3843: WHERE a.ARC_ACT_PRODUCT_USED_BY = 'MODL'
3844: AND a.ACT_PRODUCT_USED_BY_ID = p_model_id
3845: AND a.inventory_item_id = b.inventory_item_id(+)
3846: AND a.organization_id = b.organization_id(+)

Line 3859: FROM mtl_system_items_kfv items, mtl_item_categories_v cats

3855: ;
3856:
3857: CURSOR c_valid_prod (p_cat_id IN NUMBER, p_prod_id IN NUMBER, p_org_id IN NUMBER, p_cat_set_id IN NUMBER) IS
3858: SELECT 1
3859: FROM mtl_system_items_kfv items, mtl_item_categories_v cats
3860: WHERE cats.category_id = p_cat_id
3861: AND cats.inventory_item_id = p_prod_id
3862: AND items.inventory_item_id = p_prod_id
3863: AND UPPER(items.INVENTORY_ITEM_STATUS_CODE) <> 'INACTIVE'