DBA Data[Home] [Help]

APPS.CS_WF_AUTO_NTFY_UPDATE_PKG dependencies on CS_STD

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

6328: AND INC.PROBLEM_CODE = CSLKUP.LOOKUP_CODE(+)
6329: AND CSLKUP.LOOKUP_TYPE(+) = 'REQUEST_PROBLEM_CODE'
6330: AND MTL.INVENTORY_ITEM_ID(+) = INC.INVENTORY_ITEM_ID
6331: AND MTL.LANGUAGE(+) = userenv('LANG')
6332: AND (MTL.ORGANIZATION_ID = CS_STD.Get_Item_Valdn_Orgzn_ID OR MTL.ORGANIZATION_ID IS NULL);
6333: --AND NVL(MTL.ORGANIZATION_ID,CS_STD.Get_Item_Valdn_Orgzn_ID) = CS_STD.Get_Item_Valdn_Orgzn_ID;
6334:
6335: l_ServiceRequest_rec l_ServiceRequest_csr%ROWTYPE;
6336:

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

6329: AND CSLKUP.LOOKUP_TYPE(+) = 'REQUEST_PROBLEM_CODE'
6330: AND MTL.INVENTORY_ITEM_ID(+) = INC.INVENTORY_ITEM_ID
6331: AND MTL.LANGUAGE(+) = userenv('LANG')
6332: AND (MTL.ORGANIZATION_ID = CS_STD.Get_Item_Valdn_Orgzn_ID OR MTL.ORGANIZATION_ID IS NULL);
6333: --AND NVL(MTL.ORGANIZATION_ID,CS_STD.Get_Item_Valdn_Orgzn_ID) = CS_STD.Get_Item_Valdn_Orgzn_ID;
6334:
6335: l_ServiceRequest_rec l_ServiceRequest_csr%ROWTYPE;
6336:
6337: