DBA Data[Home] [Help]

APPS.GMO_DISPENSE_SETUP_PVT dependencies on MTL_SYSTEM_ITEMS

Line 19: MTL_SYSTEM_ITEMS_VL

15: CURSOR GET_ITEM_DISPLAY_NAME_CUR IS
16: SELECT
17: CONCATENATED_SEGMENTS
18: FROM
19: MTL_SYSTEM_ITEMS_VL
20: WHERE
21: INVENTORY_ITEM_ID = P_ITEM_ID;
22:
23: --This variable would hold the item display name.

Line 76: MTL_SYSTEM_ITEMS_VL

72: CURSOR GET_ITEM_DESCRIPTION_CUR IS
73: SELECT
74: DESCRIPTION
75: FROM
76: MTL_SYSTEM_ITEMS_VL
77: WHERE
78: INVENTORY_ITEM_ID = P_ITEM_ID;
79:
80: --This variable would hold the item description.

Line 711: FROM MTL_SYSTEM_ITEMS

707: L_RETURN_VALUE NUMBER;
708: BEGIN
709:
710: SELECT PRIMARY_UOM_CODE INTO L_ITEM_UOM
711: FROM MTL_SYSTEM_ITEMS
712: WHERE INVENTORY_ITEM_ID = P_ITEM_ID
713: AND ORGANIZATION_ID = NVL(P_ORGANIZATION_ID, ORGANIZATION_ID)
714: AND ROWNUM =1;
715: