APPS.AMS_PROD_TEMPLATE_PVT dependencies on AMS_SETUP_TYPES

Line 63: FROM ams_setup_types stp

59: CURSOR c_get_prod_attr
60: IS
61: SELECT stp.parent_setup_attribute,
62: stp.setup_attribute
63: FROM ams_setup_types stp
64: WHERE stp.object_type = 'PTMP'
65: AND stp.setup_attribute not in ('AMS_PROD_SUPP_SRV','AMS_PROD_WARRN','AMS_PROD_COV_TEMP'
66: ,'AMS_PROD_DUR_VAL','AMS_PROD_DUR_PER','AMS_CONTRACT_ITEM_TYPE')
67: --,'AMS_SUBSCRIPTION_DEPENDENCY')

Line 76: FROM ams_setup_types stp

72: CURSOR c_get_service_attr
73: IS
74: SELECT stp.parent_setup_attribute,
75: stp.setup_attribute
76: FROM ams_setup_types stp
77: WHERE stp.object_type = 'PTMP'
78: AND parent_setup_attribute not in ('AMS_INVENTORY','AMS_BILL_OF_MATERIAL')
79: AND setup_attribute not in ('AMS_PROD_RET','AMS_PROD_SHP','AMS_PROD_BACK_ORD','AMS_PROD_SRP','AMS_BILLING_TYPE','AMS_SUBSCRIPTION_DEPENDENCY','AMS_CONTRACT_ITEM_TYPE')
80: ORDER BY display_sequence_no;

Line 319: FROM ams_setup_types stp

315: stp.setup_attribute,
316: 'N',
317: 'N',
318: 'N'
319: FROM ams_setup_types stp
320: WHERE stp.object_type = 'PTMP'
321: AND parent_setup_attribute not in ('AMS_INVENTORY','AMS_BILL_OF_MATERIAL')
322: AND setup_attribute not in ('AMS_PROD_RET','AMS_PROD_SHP','AMS_PROD_BACK_ORD','AMS_PROD_SRP','AMS_BILLING_TYPE') ;
323: */