APPS.CZ_PB_SYNC dependencies on MTL_SYSTEM_ITEMS_VL

Line 492: l_concatenated_segments MTL_SYSTEM_ITEMS_VL.concatenated_segments%TYPE;

488: p_org_id IN OUT NOCOPY cz_model_publications.organization_id%TYPE,
489: p_product_key IN OUT NOCOPY cz_model_publications.product_key%TYPE
490: )
491: IS
492: l_concatenated_segments MTL_SYSTEM_ITEMS_VL.concatenated_segments%TYPE;
493: l_remote_item_cursor ref_cursor;
494: c_local_item_id ref_cursor;
495: l_org_id cz_model_publications.organization_id%TYPE;
496:

Line 551: OPEN l_remote_item_cursor FOR ' SELECT concatenated_segments FROM MTL_SYSTEM_ITEMS_VL'

547:
548: -- Transform Item ID
549:
550:
551: OPEN l_remote_item_cursor FOR ' SELECT concatenated_segments FROM MTL_SYSTEM_ITEMS_VL'
552: || p_sync_tgt_link_name || ' t ' || ' WHERE t.inventory_item_id = ' || p_item_id
553: || ' AND organization_id = '||l_org_id;
554: LOOP
555: FETCH l_remote_item_cursor

Line 567: OPEN c_local_item_id FOR ' SELECT inventory_item_id FROM MTL_SYSTEM_ITEMS_VL'

563:
564: -- here if p_import_link_name is NULL then we are effectively querying the local BOM data
565:
566: BEGIN
567: OPEN c_local_item_id FOR ' SELECT inventory_item_id FROM MTL_SYSTEM_ITEMS_VL'
568: || p_import_link_name||' WHERE concatenated_segments = '''||l_concatenated_segments||''' AND organization_id = '||p_org_id;
569: FETCH c_local_item_id
570: INTO p_item_id;
571: CLOSE c_local_item_id;