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 905: mtl_system_items_tl t

901: IS
902: SELECT t.description NAME,
903: b.concatenated_segments description
904: FROM mtl_system_items_b_kfv b,
905: mtl_system_items_tl t
906: WHERE b.inventory_item_id = t.inventory_item_id
907: AND b.organization_id = t.organization_id
908: AND t.LANGUAGE = USERENV ('LANG')
909: AND b.inventory_item_id = p_product_item