APPS.EGO_ITEM_ASSOCIATIONS_PUB dependencies on MTL_SYSTEM_ITEMS_B

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 334: FROM mtl_system_items_b msib

330: AND ( eiai.inventory_item_id IS NULL
331: OR NOT EXISTS
332: (
333: SELECT 1
334: FROM mtl_system_items_b msib
335: WHERE msib.inventory_item_id = eiai.inventory_item_id
336: AND msib.organization_id = eiai.organization_id
337: )
338: );

Line 628: FROM mtl_system_items_b_kfv msibk

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

Line 1666: FROM mtl_system_items_b_kfv msibk

1662: AND eiai.pk2_value IS NOT NULL;
1663:
1664: UPDATE ego_item_associations_intf eiai
1665: SET inventory_item_id = ( SELECT inventory_item_id
1666: FROM mtl_system_items_b_kfv msibk
1667: WHERE msibk.organization_id = eiai.organization_id
1668: AND msibk.concatenated_segments = eiai.item_number
1669: )
1670: WHERE eiai.batch_id = p_batch_id

Line 2372: ,mtl_system_items_b_kfv msibk

2368: ,NULL
2369: ,G_REQUEST_ID
2370: ,G_SKIP_SECURIY_CHECK -- Bug 6459846
2371: FROM ego_item_associations_intf eiai1
2372: ,mtl_system_items_b_kfv msibk
2373: ,mtl_parameters mp
2374: WHERE eiai1.inventory_item_id = msibk.style_item_id
2375: AND eiai1.organization_id = msibk.organization_id
2376: AND msibk.organization_id = mp.organization_id

Line 2502: FROM ego_item_associations_intf eiai, mtl_system_items_b_kfv msibk

2498: CURSOR l_pack_item_csr(p_batch_id IN NUMBER)
2499: IS
2500: SELECT msibk.inventory_item_id
2501: ,msibk.organization_id
2502: FROM ego_item_associations_intf eiai, mtl_system_items_b_kfv msibk
2503: WHERE msibk.concatenated_segments = eiai.item_number
2504: AND msibk.organization_id = eiai.organization_id
2505: AND eiai.batch_id = p_batch_id
2506: AND eiai.process_flag = G_REC_TO_BE_PROCESSED

Line 2611: FROM ego_item_associations_intf eiai, mtl_system_items_b_kfv msibk,

2607: ,G_REC_TO_BE_PROCESSED
2608: ,mtl_system_items_interface_s.NEXTVAL
2609: ,G_REQUEST_ID
2610: ,G_SKIP_SECURIY_CHECK -- Bug 6459846
2611: FROM ego_item_associations_intf eiai, mtl_system_items_b_kfv msibk,
2612: mtl_parameters mp
2613: WHERE eiai.inventory_item_id = l_pack_rec.inventory_item_id
2614: AND eiai.organization_id = mp.organization_id
2615: --AND mp.master_organization_id = mp.organization_id