[Home] [Help]
71: SELECT
72: DISPLAY_NAME
73: INTO P_ALT_BOM_DESG_DSP
74: FROM
75: BOM_ALTERNATE_DESIGNATORS_VL
76: WHERE ORGANIZATION_ID = NVL(P_ORGANIZATION_ID
77: ,P_DEFAULT_ORG_ID)
78: AND ALTERNATE_DESIGNATOR_CODE = P_ALT_BOM_DESG;
79: END IF;
81: SELECT
82: DISPLAY_NAME
83: INTO P_ALT_RTG_DESG_DSP
84: FROM
85: BOM_ALTERNATE_DESIGNATORS_VL
86: WHERE ORGANIZATION_ID = NVL(P_ORGANIZATION_ID
87: ,P_DEFAULT_ORG_ID)
88: AND ALTERNATE_DESIGNATOR_CODE = P_ALT_RTG_DESG;
89: END IF;