DBA Data[Home] [Help]

APPS.CS_WF_AUTO_NTFY_UPDATE_PKG dependencies on CS_STD

Line 6268: AND (MTL.ORGANIZATION_ID = CS_STD.Get_Item_Valdn_Orgzn_ID OR MTL.ORGANIZATION_ID IS NULL);

6264: AND INC.PROBLEM_CODE = CSLKUP.LOOKUP_CODE(+)
6265: AND CSLKUP.LOOKUP_TYPE(+) = 'REQUEST_PROBLEM_CODE'
6266: AND MTL.INVENTORY_ITEM_ID(+) = INC.INVENTORY_ITEM_ID
6267: AND MTL.LANGUAGE(+) = userenv('LANG')
6268: AND (MTL.ORGANIZATION_ID = CS_STD.Get_Item_Valdn_Orgzn_ID OR MTL.ORGANIZATION_ID IS NULL);
6269: --AND NVL(MTL.ORGANIZATION_ID,CS_STD.Get_Item_Valdn_Orgzn_ID) = CS_STD.Get_Item_Valdn_Orgzn_ID;
6270:
6271: l_ServiceRequest_rec l_ServiceRequest_csr%ROWTYPE;
6272:

Line 6269: --AND NVL(MTL.ORGANIZATION_ID,CS_STD.Get_Item_Valdn_Orgzn_ID) = CS_STD.Get_Item_Valdn_Orgzn_ID;

6265: AND CSLKUP.LOOKUP_TYPE(+) = 'REQUEST_PROBLEM_CODE'
6266: AND MTL.INVENTORY_ITEM_ID(+) = INC.INVENTORY_ITEM_ID
6267: AND MTL.LANGUAGE(+) = userenv('LANG')
6268: AND (MTL.ORGANIZATION_ID = CS_STD.Get_Item_Valdn_Orgzn_ID OR MTL.ORGANIZATION_ID IS NULL);
6269: --AND NVL(MTL.ORGANIZATION_ID,CS_STD.Get_Item_Valdn_Orgzn_ID) = CS_STD.Get_Item_Valdn_Orgzn_ID;
6270:
6271: l_ServiceRequest_rec l_ServiceRequest_csr%ROWTYPE;
6272:
6273: