DBA Data[Home] [Help]

APPS.CSI_RMA_FULFILL_PUB dependencies on CSI_ITEM_INSTANCES

Line 1130: FROM csi_item_instances

1126: l_u_instance_rec.quantity := ABS(l_txn_line_dtl_rec.quantity);
1127: Begin
1128: SELECT object_version_number
1129: INTO l_u_instance_rec.object_version_number
1130: FROM csi_item_instances
1131: WHERE instance_id = l_instance_rec.instance_id;
1132: Exception when others then
1133: debug('Fetch instance details failed ...');
1134: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');

Line 1414: from CSI_ITEM_INSTANCES

1410: l_p_instances_tbl(J).config_inst_item_id,
1411: l_p_instances_tbl(J).config_inst_rev_num,
1412: l_p_instances_tbl(J).instance_usage_code,
1413: l_p_instances_tbl(J).active_end_date
1414: from CSI_ITEM_INSTANCES
1415: where instance_id = l_p_instances_tbl(J).instance_id;
1416: --
1417: IF l_locked = TRUE THEN
1418: -- Instance is in Locked Status