DBA Data[Home] [Help]

APPS.INV_RCV_TXN_MATCH dependencies on MTL_SYSTEM_ITEMS

Line 2817: FROM mtl_system_items

2813: IF x_cascaded_table(n).item_id IS NOT NULL THEN
2814: BEGIN
2815: SELECT primary_unit_of_measure
2816: INTO temp_cascaded_table(current_n).primary_unit_of_measure
2817: FROM mtl_system_items
2818: WHERE mtl_system_items.inventory_item_id =
2819: temp_cascaded_table(current_n).item_id
2820: AND mtl_system_items.organization_id =
2821: temp_cascaded_table(current_n).to_organization_id;

Line 2818: WHERE mtl_system_items.inventory_item_id =

2814: BEGIN
2815: SELECT primary_unit_of_measure
2816: INTO temp_cascaded_table(current_n).primary_unit_of_measure
2817: FROM mtl_system_items
2818: WHERE mtl_system_items.inventory_item_id =
2819: temp_cascaded_table(current_n).item_id
2820: AND mtl_system_items.organization_id =
2821: temp_cascaded_table(current_n).to_organization_id;
2822: EXCEPTION

Line 2820: AND mtl_system_items.organization_id =

2816: INTO temp_cascaded_table(current_n).primary_unit_of_measure
2817: FROM mtl_system_items
2818: WHERE mtl_system_items.inventory_item_id =
2819: temp_cascaded_table(current_n).item_id
2820: AND mtl_system_items.organization_id =
2821: temp_cascaded_table(current_n).to_organization_id;
2822: EXCEPTION
2823: WHEN no_data_found THEN
2824: temp_cascaded_table(current_n).error_status := 'W';