APPS.EGO_ITEM_AML_PVT dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 489: (SELECT 'x' FROM mtl_system_items_b_kfv item

485: AND process_flag = G_PS_IN_PROCESS
486: AND ( (inventory_item_id IS NOT NULL
487: AND
488: NOT EXISTS
489: (SELECT 'x' FROM mtl_system_items_b_kfv item
490: WHERE item.organization_id = aml_intf.organization_id
491: AND item.inventory_item_id = aml_intf.inventory_item_id)
492: )
493: OR

Line 497: (SELECT 'x' FROM mtl_system_items_b_kfv item

493: OR
494: (inventory_item_id IS NULL
495: AND
496: NOT EXISTS
497: (SELECT 'x' FROM mtl_system_items_b_kfv item
498: WHERE item.organization_id = aml_intf.organization_id
499: AND item.concatenated_segments = aml_intf.item_number)
500: )
501: );

Line 508: from mtl_system_items_b_kfv item

504: SET (item_number, prog_int_num1, prog_int_num2,
505: prog_int_num3, prog_int_char1) =
506: (Select concatenated_segments, item_catalog_group_id, lifecycle_id,
507: current_phase_id, NVL(approval_status,'A')
508: from mtl_system_items_b_kfv item
509: where item.organization_id = aml_intf.organization_id
510: and item.inventory_item_id = aml_intf.inventory_item_id)
511: WHERE data_set_id = p_data_set_id
512: AND process_flag = G_PS_IN_PROCESS

Line 520: from mtl_system_items_b_kfv item

516: SET (inventory_item_id, prog_int_num1, prog_int_num2,
517: prog_int_num3, prog_int_char1) =
518: (Select inventory_item_id, item_catalog_group_id, lifecycle_id,
519: current_phase_id, NVL(APPROVAL_STATUS,'A')
520: from mtl_system_items_b_kfv item
521: where item.organization_id = aml_intf.organization_id
522: and item.concatenated_segments = aml_intf.item_number)
523: WHERE data_set_id = p_data_set_id
524: AND process_flag = G_PS_IN_PROCESS