DBA Data[Home] [Help]

APPS.OKS_MASS_UPDATE_PVT dependencies on MTL_SYSTEM_ITEMS_TL

Line 17: --| MTL_SYSTEM_ITEMS_TL | X | | | | | |

13: --| OKS_STREAM_LEVELS_V | X | | | | | |
14: --+---------------------------------+---+---+---+---+---+----------------------+
15: --| HZ_CUST_ACCOUNTS | X | | | | | |
16: --+---------------------------------+---+---+---+---+---+----------------------+
17: --| MTL_SYSTEM_ITEMS_TL | X | | | | | |
18: --+---------------------------------+---+---+---+---+---+----------------------+
19: --| MTL_SYSTEM_ITEMS_B_KFV | X | | | | | |
20: --+---------------------------------+---+---+---+---+---+----------------------+
21: --| OKC_K_ITEMS | X | X | | | |X |

Line 909: mtl_system_items_tl t

905: IS
906: SELECT t.description NAME,
907: b.concatenated_segments description
908: FROM mtl_system_items_b_kfv b,
909: mtl_system_items_tl t
910: WHERE b.inventory_item_id = t.inventory_item_id
911: AND b.organization_id = t.organization_id
912: AND t.LANGUAGE = USERENV ('LANG')
913: AND b.inventory_item_id = p_product_item