APPS.WSH_ECE_VIEWS_DEF dependencies on MTL_CROSS_REFERENCES

Line 475: SELECT CROSS_REFERENCE FROM MTL_CROSS_REFERENCES

471: X_ORGANIZATION_ID IN NUMBER,
472: X_CROSS_REFERENCE OUT NOCOPY VARCHAR2) IS
473:
474: CURSOR C_GET_CROSS_REFERENCE_1 IS
475: SELECT CROSS_REFERENCE FROM MTL_CROSS_REFERENCES
476: WHERE INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID AND
477: ORG_INDEPENDENT_FLAG = 'N' AND ORGANIZATION_ID = X_ORGANIZATION_ID;
478:
479: CURSOR C_GET_CROSS_REFERENCE_2 IS

Line 480: SELECT CROSS_REFERENCE FROM MTL_CROSS_REFERENCES

476: WHERE INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID AND
477: ORG_INDEPENDENT_FLAG = 'N' AND ORGANIZATION_ID = X_ORGANIZATION_ID;
478:
479: CURSOR C_GET_CROSS_REFERENCE_2 IS
480: SELECT CROSS_REFERENCE FROM MTL_CROSS_REFERENCES
481: WHERE INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID AND
482: ORG_INDEPENDENT_FLAG = 'Y';
483:
484: l_cross_reference VARCHAR2(25) := NULL;