eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_ITEM_ASSOCIATIONS_PUB dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 218: FROM mtl_system_items_b_kfv msibk

214:
215: -- check whether item value converion is required..
216: UPDATE ego_item_associations_intf eiai
217: SET item_number = ( SELECT concatenated_segments
218: FROM mtl_system_items_b_kfv msibk
219: WHERE msibk.organization_id = eiai.organization_id
220: AND msibk.inventory_item_id = eiai.inventory_item_id
221: )
222: WHERE eiai.batch_id = p_batch_id

Line 229: FROM mtl_system_items_b_kfv msibk

225: AND eiai.inventory_item_id IS NOT NULL;
226: */
227: UPDATE ego_item_associations_intf eiai
228: SET inventory_item_id = ( SELECT inventory_item_id
229: FROM mtl_system_items_b_kfv msibk
230: WHERE msibk.organization_id = eiai.organization_id
231: AND msibk.concatenated_segments = eiai.item_number
232: )
233: WHERE eiai.batch_id = p_batch_id

Line 260: FROM mtl_system_items_b_kfv msibk

256: AND eiai.pk2_value IS NOT NULL;
257:
258: UPDATE ego_item_associations_intf eiai
259: SET item_number = ( SELECT concatenated_segments
260: FROM mtl_system_items_b_kfv msibk
261: WHERE msibk.organization_id = eiai.organization_id
262: AND msibk.inventory_item_id = eiai.inventory_item_id
263: )
264: WHERE eiai.batch_id = p_batch_id

Line 631: FROM mtl_system_items_b_kfv msibk

627: AND eiai.transaction_type = G_CREATE
628: AND NOT EXISTS
629: (
630: SELECT 1
631: FROM mtl_system_items_b_kfv msibk
632: WHERE msibk.inventory_item_id = eiai.inventory_item_id
633: AND msibk.organization_id = eiai.organization_id
634: );
635: -- Primary has been set in Create-Create or Create-Update or Update - Update

Line 1733: FROM mtl_system_items_b_kfv msibk

1729: AND eiai.pk2_value IS NOT NULL;
1730:
1731: UPDATE ego_item_associations_intf eiai
1732: SET inventory_item_id = ( SELECT inventory_item_id
1733: FROM mtl_system_items_b_kfv msibk
1734: WHERE msibk.organization_id = eiai.organization_id
1735: AND msibk.concatenated_segments = eiai.item_number
1736: )
1737: WHERE eiai.batch_id = p_batch_id

Line 2440: ,mtl_system_items_b_kfv msibk

2436: ,NULL
2437: ,G_REQUEST_ID
2438: ,G_SKIP_SECURIY_CHECK -- Bug 6459846
2439: FROM ego_item_associations_intf eiai1
2440: ,mtl_system_items_b_kfv msibk
2441: ,mtl_parameters mp
2442: WHERE eiai1.inventory_item_id = msibk.style_item_id
2443: AND eiai1.organization_id = msibk.organization_id
2444: AND msibk.organization_id = mp.organization_id

Line 2570: FROM ego_item_associations_intf eiai, mtl_system_items_b_kfv msibk

2566: CURSOR l_pack_item_csr(p_batch_id IN NUMBER)
2567: IS
2568: SELECT msibk.inventory_item_id
2569: ,msibk.organization_id
2570: FROM ego_item_associations_intf eiai, mtl_system_items_b_kfv msibk
2571: WHERE msibk.concatenated_segments = eiai.item_number
2572: AND msibk.organization_id = eiai.organization_id
2573: AND eiai.batch_id = p_batch_id
2574: AND eiai.process_flag = G_REC_TO_BE_PROCESSED

Line 2679: FROM ego_item_associations_intf eiai, mtl_system_items_b_kfv msibk,

2675: ,G_REC_TO_BE_PROCESSED
2676: ,mtl_system_items_interface_s.NEXTVAL
2677: ,G_REQUEST_ID
2678: ,G_SKIP_SECURIY_CHECK -- Bug 6459846
2679: FROM ego_item_associations_intf eiai, mtl_system_items_b_kfv msibk,
2680: mtl_parameters mp
2681: WHERE eiai.inventory_item_id = l_pack_rec.inventory_item_id
2682: AND eiai.organization_id = mp.organization_id
2683: --AND mp.master_organization_id = mp.organization_id