DBA Data[Home] [Help]

APPS.INV_CYC_LOVS dependencies on MTL_CYCLE_COUNT_ENTRIES_V

Line 1958: FROM mtl_cycle_count_entries_v

1954: parent_lpn_id
1955: INTO l_pos_meas_err,
1956: l_neg_meas_err,
1957: l_parent_lpn_id
1958: FROM mtl_cycle_count_entries_v
1959: WHERE cycle_count_entry_id = g_cc_entry.cycle_count_entry_id
1960: AND organization_id = g_cc_entry.organization_id;
1961: EXCEPTION
1962: WHEN NO_DATA_FOUND THEN

Line 4259: FROM MTL_CYCLE_COUNT_ENTRIES_V

4255: IS
4256: SELECT cycle_count_entry_id,
4257: entry_status_code,
4258: inventory_item_id
4259: FROM MTL_CYCLE_COUNT_ENTRIES_V
4260: WHERE cycle_count_header_id = l_cc_header_id
4261: -- AND nvl(export_flag,2) = 2
4262: AND serial_number_control_code IN ( 2, 5 );
4263: